Setting up a trace

pete · Post by **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.

Duke · Post by **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.

pete · Post by **pete** » Fri 10 Aug 2007 11:54

Thanks for that - makes sense now.