Setting up a trace

Setting up a trace

Postby pete » Fri 10 Aug 2007 07:38

I'm trying to run a trace so I can see what SQL is passed to my Oracle server. I'm using Oracle 10g Express.
After reading help, I'm thinking that the session manager is the tool to use. I note that it says users of SYSDBA must use this tool. When I try to connect using SYS or SYSTEM (created by default in 10g Ex) it mentions that I need to connect as SYSDBA or SYSOPER. OK so I create a user called SYSDBA with full DBA rights and then connect that user.
When I now try to run a trace it returns an error:

ORA-06550: line 5, column 3:
PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored.

What am I doing wrong?

Regards,
Pete.
pete
 
Posts: 5
Joined: Fri 10 Aug 2007 07:16

Postby Duke » Fri 10 Aug 2007 11:43

SYSDBA and SYSOPER are standard roles used on connect. To connect as SYSDBA with SYS you need to choose appropriate 'Connect As' value in Database Connection Properties dialog box.
Duke
Devart Team
 
Posts: 476
Joined: Fri 29 Oct 2004 09:25

Postby pete » Fri 10 Aug 2007 11:54

Thanks for that - makes sense now.
pete
 
Posts: 5
Joined: Fri 10 Aug 2007 07:16


Return to dbForge for Oracle