DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: dbms_system package

  1. #1
    Join Date
    Nov 2005
    Posts
    32

    Exclamation dbms_system package

    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

  2. #2
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    Are you saying that you have not run catproc on your production database?
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  3. #3
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Why not use:

    SQL> alter session set sql_trace=TRUE;

    And trace the session

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    what are u talking about?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    u can use prvtutil.plb to create the package dbms_system
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Nov 2005
    Posts
    32
    Quote Originally Posted by simply_dba
    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]

  7. #7
    Join Date
    Nov 2005
    Posts
    32
    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

  8. #8
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    [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.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  9. #9
    Join Date
    Nov 2005
    Posts
    32
    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

  10. #10
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    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
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width