STATSPACK CONFIGURATION - Page 4
DBAsupport.com Forums - Powered by vBulletin
Page 4 of 4 FirstFirst ... 234
Results 31 to 38 of 38

Thread: STATSPACK CONFIGURATION

  1. #31
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Login as the perfstat user and execute spctab.sql to create the tables.
    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."

  2. #32
    Join Date
    Jan 2002
    Posts
    474
    jEFF,

    Sorry, please don't be upset with the rookie, I am getting there. After I run the SPCTAB.SQL, tables were created and the package body is compiled and valid.

    What do I do next ??? I did read the doc but it miss too much info, none of the thing you mention are included on the doc. Like SPCPKG.sql and SPCTAB.sql, I didn't know we have to run them seperate. Any way, the doc is not good.

    Could you please tell me what I need to do next to get the snapshot of the database???


  3. #33
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    To compile the package body, login as perfstat and:
    ALTER PACKAGE STATSPACK COMPILE BODY;

    If there are any errors, post the errors.
    SHOW ERRORS PACKAGE BODY STATSPACK

    Otherwise, post the results of:
    Code:
    select owner, object_name, object_type
    from dba_objects
    where object_name like 'STATS%'
    order by owner, object_name
    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."

  4. #34
    Join Date
    Jan 2002
    Posts
    474
    Jeff,

    Every thing is good now, what I need to do next ???

    Run the STACKPACK.SNAP ???? HOW ???

    Please advise


  5. #35
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Now, all you have to do is take a snapshot of the database:
    exec statspack.snap;


    After about 15 minutes or so of activity, take another snapshot. You can then use spreport.sql to get a generalized report between the two time periods...
    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. #36
    Join Date
    Jan 2002
    Posts
    474
    Thanks so much for your help and kindness


  7. #37
    Join Date
    Jan 2002
    Posts
    474
    One final thing Jeff

    Where can I see the report or where the report will be stored at ???

    were the data stored in the tables owned by PERFSTAT schema ??? If so , I have to go to those tables and get the info about the database ????




    THanks again and Have a great weekend


    [Edited by ashley75 on 03-15-2002 at 01:35 PM]

  8. #38
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The report will go to a file of your choosing. The data stays in the database and you can report on it at any time.
    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."

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