what is the use of recording information about current session?



what is the use of recording information about current session?..

Answer / Minaxi Kumari

Recording information about the current session in Oracle Database is essential for monitoring and managing database resources. This information includes details such as the user's connection, the open cursors, locks held by the session, and the system statistics being collected for that session.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

what is the difference between db2start command and start database manager command?

1 Answers  


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1 Answers  


what are the differences of where and if in SAS?

1 Answers  


What purpose does the model database server? : sql server DBA

1 Answers  


How do you switch from an init.ora file to a spfile?

4 Answers   TCS,


what is asm?

1 Answers   Oracle,


what is logical system in sap basis

1 Answers  


how can you get actual data change values from previous transactions in oracle?

1 Answers   Oracle,


what do you understand by fine-grained auditing?

1 Answers   Oracle,


Name two files used for network connection to a database.

5 Answers  


i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,


How would you determine who has added a row to a table?

4 Answers  


Categories