Home » RDBMS Server » Server Administration » oracle trace (unix,oracle 10g)
oracle trace [message #341331] Mon, 18 August 2008 07:00 Go to next message
xyzt
Messages: 27
Registered: April 2008
Junior Member
hello

i need to see which sql commands are executed in the server. how can i trace this commands?there's a utility or a setting for this?
thanks in advance.
Re: oracle trace [message #341340 is a reply to message #341331] Mon, 18 August 2008 07:30 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

v$sqlarea,v$session, v$active_session_history
Re: oracle trace [message #341348 is a reply to message #341331] Mon, 18 August 2008 08:18 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_monitor.

Regards
Michel
Previous Topic: Oracle Workspace Manager
Next Topic: ORA-01219: database not open: queries allowed on fixed tables/views only
Goto Forum:
  


Current Time: Fri Dec 09 08:14:38 CST 2016

Total time taken to generate the page: 0.13947 seconds