Look at DBMS_SYSTEM and DBMS_SUPPORT
I think one of these doesn't support level of trace though which you need to set
in order to see bind variables.

John

________________________________

From: Gary Colbran (GJ) [mailto:oracledba-ezmlmshield-x82246431.[Email address protected]
Sent: Fri 08/10/2004 07:38
To: LazyDBA Discussion
Subject: Setting 10046




Hi,

I need to set trace on a session to see the bind variables,
but get the error ORA-06509, ICD Vector missing. I've checked on the
web and it suggests to run CATALOG and CATPROC, stating that they may
have been run as a user other than sys. I cannot run these on the live
system at the moment, so what is the best option to fix the problem,
or another way to set 10046 on another users session ?

Cheers

Gary

==================================================================
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at

http://www.telkom.co.za/TelkomEMailLegalNotice.PDF


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html





This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

Oracle LazyDBA home page