STATSPACK CONFIGURATION - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 38

Thread: STATSPACK CONFIGURATION

  1. #11
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Its found under $ORACLE_HOME/rdbms/admin/spdoc.txt

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  2. #12
    Join Date
    Jan 2002
    Posts
    474
    Sam,

    Thanks for your help and now I am having problem to run STACKSPACK.SNAP


    any recomendations ???

  3. #13
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is the problem?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #14
    Join Date
    Jan 2002
    Posts
    474
    Sam,

    sorry , I kept bugging you on this since this is my first time.

    here is the error message

    SQL> execute statspack.snap
    BEGIN statspack.snap; END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'STATSPACK.SNAP' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    What I don't understand is STATSPACK.SNAP is not existed in
    %ORACLE_HOME%\rdbms\admin\

    so where is this procedures located ???


  5. #15
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    its in spcpkg.sql
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #16
    Join Date
    Jan 2002
    Posts
    474
    so I have to run spcpkg.sql instead ???


  7. #17
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    spcpkg will create the statspack package. After the package is created, you can call statspack.snap.

    There is a file called spdoc.txt that outlines the procedure to create the statspack repository and associated packages.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #18
    Join Date
    Mar 2001
    Posts
    77
    What is statspack? When do we use it?

  9. #19
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Stats pack is a performance tuning tool. It is used when you want to tune your database. So you would run the statspack on a regular interval and gather statistics on your database and then you would use it's report to find out the cholk points and bottle necks and start tuning in one by one.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  10. #20
    Join Date
    Jan 2002
    Posts
    474
    Jeff,

    Thanks for your reply,

    I did run the spcpkg package and it create statspack package,when I run statspack.snap I still have problem and I am sorry to bother you again but I tried to get this work.

    when I tried to call statspack.snap I still have the same problem

    Please help

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