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.

Report message to a moderator

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

Report message to a moderator

Re: oracle trace [message #341348 is a reply to message #341331] Mon, 18 August 2008 08:18 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
dbms_monitor.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 19:36:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.