Statspack report incomplete

Posted on 2009-04-21
Last Modified: 2013-12-19
We are getting statspack report in which there are few columns are emply mainly which require DBA access.

Is there any additional grant required.



ERROR at line 2:

ORA-06550: line 2, column 3:

PLS-00306: wrong number or types of arguments in call to 'STAT_CHANGES'

ORA-06550: line 2, column 3:

PL/SQL: Statement ignored

STATSPACK report for

DB Name         DB Id    Instance     Inst Num Release     Cluster Host

------------ ----------- ------------ -------- ----------- ------- ------------

PBS173        1919877720 PBS173              1   NO      binga

            Snap Id     Snap Time      Sessions Curs/Sess Comment

            ------- ------------------ -------- --------- -------------------

Begin Snap:   12704 12-Apr-09 23:00:00

  End Snap:   12706 13-Apr-09 01:00:02

   Elapsed:              120.03 (mins)

Cache Sizes (end)


               Buffer Cache:          M      Std Block Size:          K

           Shared Pool Size:          M          Log Buffer:          K

Load Profile

~~~~~~~~~~~~                            Per Second       Per Transaction

                                   ---------------       ---------------

                  Redo size:

              Logical reads:

              Block changes:

             Physical reads:

            Physical writes:

                 User calls:


                Hard parses:





  % Blocks changed per Read:            Recursive Call %:

 Rollback per transaction %:               Rows per Sort:

Instance Efficiency Percentages (Target 100%)


            Buffer Nowait %:               Redo NoWait %:

            Buffer  Hit   %:            In-memory Sort %:

            Library Hit   %:                Soft Parse %:

         Execute to Parse %:                 Latch Hit %:

Parse CPU to Parse Elapsd %:             % Non-Parse CPU:

 Shared Pool Statistics        Begin   End

                               ------  ------

             Memory Usage %:

    % SQL with executions>1:   94.39   94.39

  % Memory for SQL w/exec>1:   75.63   75.63

Top 5 Wait Events

~~~~~~~~~~~~~~~~~                                            Wait     % Total

Event                                               Waits  Time (s)   Wt Time

-------------------------------------------- ------------ ----------- -------

async disk IO                                   1,863,266       7,258

sbtremove2                                            583         395

SQL*Net more data to client                     3,136,753         132

db file scattered read                             86,794         112

sbtwrite2                                             521         106


Wait Events for DB: PBS173  Instance: PBS173  Snaps: 12704 -12706

-> s  - second

-> cs - centisecond -     100th of a second

-> ms - millisecond -    1000th of a second

-> us - microsecond - 1000000th of a second

-> ordered by wait time desc, waits desc (idle events last)


                                                     Total Wait   wait    Waits

Event                               Waits   Timeouts  Time (s)    (ms)     /txn

---------------------------- ------------ ---------- ---------- ------ --------

async disk IO                   1,863,266          0      7,258      4

sbtremove2                            583          0        395    677

Open in new window

Question by:sachin_dba
    LVL 47

    Expert Comment

    Use latest copy of 'spreport'.
    You use Oracle 9i.
    Migrate to or even to

    Author Comment

    can I download from somewhere??
    LVL 47

    Accepted Solution

    Upgrade are available only from metalink.
    But OTN also had as a start kit but I am not sure if
    they are still available on the site.

    Author Closing Comment

    It worked with scrips, thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    Able to SELECT but not DELETE 4 36
    PL/SQL Group by 2 34
    Oracle SQL Query Syntax 6 71
    Oracle SQL Syntax 8 40
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    Via a live example, show how to take different types of Oracle backups using RMAN.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now