Hi I want to retrieve the following details from the V$ tables, Please help me out with the table names and column names for the following Insformation. Even if some one could provie the exact SQL, It will be much appreciated.
1. DB User ID
2. Tables being hit during the operation
3. Stored procedures being Called
4. Duration of Execution
5. NT Domain ID of user
6. Application name which is calling the DB Objects (SP/Table/sql)
You can take a look a v$session_longops, but as its name implies, you will only see operations there that takes a while to run (3 seconds and forth), most of the information you want you can retrieve it from there.