dbms_system package

[gurbirbhatia]

Hi All

i want to execute dbms_system.set_sql_trace_in_session
for that i need to execute catproc.sql.
but this is my production database ,so i dont want to execute the catproc.sql script
can anybody guide me out of catproc.sql which particular sql file i should execute to install dbms_system package on oracle9.2.0.4 and linux 9 OS

Thanks & regards

[simply_dba]

Are you saying that you have not run catproc on your production database?

[pareshjavkar]

Why not use:

SQL> alter session set sql_trace=TRUE;

And trace the session

[abhaysk]

what are u talking about?

[abhaysk]

u can use prvtutil.plb to create the package dbms_system

[gurbirbhatia]

Are you saying that you have not run catproc on your production database?

hi Simply....
off cousr i ran catproc -- i meant to say reexecute catproc again
but the question is why this package is not created with the catproc when i ran it way back 2 yrs approx
[QUOTE=Pl use some common sence ( that is not so common)[/QUOTE]

[gurbirbhatia]

Hi pareshjavkar

SQL> alter session set sql_trace=TRUE;
will not help me coz i , as a dba want to trace another users' session

will prvtutil.pld works !!!!!!!!!

Thanks & regards

[simply_dba]

[QUOTE]hi Simply....
off cousr i ran catproc -- i meant to say reexecute catproc again
but the question is why this package is not created with the catproc when i ran it way back 2 yrs approx
Of course I would use common sense,but only if you have sense to ask a question correctly.
this is what you asked:

but this is my production database ,so i dont want to execute the catproc.sql script
can anybody guide me out of catproc.sql which particular sql file i should execute to install dbms_system package on oracle9.2.0.4 and linux 9 OS

without any other details about your production database.

[gurbirbhatia]

ok my simply friend it was writing mistake ,i commited ,but instead of getting into argument ,if u have any solution of my query
lies can be of many types(facts not updated ,mistake, lies for good,lies for bad...... so many not just three types)

Have fun

[simply_dba]

Hi Gurbir,
well If yuo have run catproc then the proc set_sql_trace_in_session should have been present in dbms_system package.
Other than you first misleading query and criticism, you have still not posted any further information/investigation. Is the package dbms_system accesible ? what is the exact error you are getting when you run the proc.Are the procedures valid in the package?
And yes, I accept. It was a mistake in getting into argument with you as the present thread shows.
As it happens, you didn't even catch the pun of my signature.

Best wishes for the new year