Home » SQL & PL/SQL » SQL & PL/SQL » Trace files location and user commits question (2 merged)
Trace files location and user commits question (2 merged) [message #421209] Sat, 05 September 2009 20:31 Go to next message
Ricky_1362002
Messages: 111
Registered: February 2009
Senior Member
1. How can we find the location of the database trace files from within the data dictionary?

2. Which database views and columns would you use to determine the number of commits a user's session has performed?


-thank you
munna
Re: Trace files location and user commits question [message #421212 is a reply to message #421209] Sat, 05 September 2009 20:44 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
>1. How can we find the location of the database trace files from within the data dictionary?

SQL> SHOW PARAMETER DUMP

>2. Which database views and columns would you use to determine the number of commits a user's session has performed?

V$MYSTAT.STATISTIC#
Re: Trace files location and user commits question [message #421213 is a reply to message #421209] Sat, 05 September 2009 20:45 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.


Do NOT cross/multi-post!
Re: Trace files location and user commits question (2 merged) [message #421245 is a reply to message #421209] Sun, 06 September 2009 17:15 Go to previous message
Ricky_1362002
Messages: 111
Registered: February 2009
Senior Member
Thank you very much for your reply....
Previous Topic: comparing single value with many values at one go
Next Topic: help in string replace
Goto Forum:
  


Current Time: Mon Sep 26 06:02:37 CDT 2016

Total time taken to generate the page: 0.10037 seconds