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.