Welcome to Splunk Answers, a Q&A forum for users to find answers to questions about deploying, managing, and using Splunk products. Contributors of all backgrounds and levels of expertise come here to find solutions to their issues, and to help other users in the Splunk community with their own questions.

This quick tutorial will help you get started with key features to help you find the answers you need. You will receive 10 karma points upon successful completion!

Refine your search:

Stream with TNS protocol

0

I use stream to parse my oracle DB server with tns protocol, and I enable all checkbox under tns configuration, but I can't find username and response time appearing in the raw data.So what are the steps for configuring this correctly?Thanks for your help!

People who like this

2 Answers

Username and response time will not appear in raw network data. Username is only transmitted at the time of the initial login and may be encrypted, and response time is calculated locally on the client or as detailed metrics information on the server, but not transmitted over the network. If you are trying to assess database performance, there is much more accurate information available in the v$ dynamic performance views, which you would access through DB Connect using SQL queries, not streams.

We're working on our database protocols. Keeping track of login name is a matter of maintaining a state table and understanding which session a particular stream is tied to, and we're looking into that. The response time is a calculation of observed elapsed time waiting for a query to complete from Stream's perspective, and should be available today.

Depending on your role or configuration, it may be preferable to not read performance metrics from the database server itself. The server itself is a more reliable place to instrument, but it may be easier to grab it passively from outside the database.

can you help me? I'm from a Chinese Young man,I'm very interested in splunk, are working on it, but a little problem, I want to use splunk APP for stream access to oracle TNS agreement, my stream of TNS switch is opened, a SQL statement in oracle interface operation, but did not return a result, could you tell me the steps?Although my brain is stupid, my English is very bad, but I'll try. thank you