DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Error with Statspack

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    83
    Hi. I'm trying to set up STATSPACK on one of our 8.1.6 db (OS is NT4.0), and keep getting the following error:

    begin
    *
    ERROR at line 1:
    ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at "SYS.STANDARD", line 1014
    ORA_06512: at line 3

    I had a look thru statsauto.sql but there is nothing to specify or request the number of rows.

    I know I have to change the number of rows requested to rectify this error - could anyone tell me the syntax for that?

    Cheers in advance
    Fiona

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi,

    Is the problem actaully occuring in the statsauto.sql script?

    If so the offending link will most likely be:

    select instance_number into :instno from v$instance;

    Is you v$instance view returning more than 1 row?

    regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Nov 2000
    Location
    London
    Posts
    83
    v$instance returns only 1 row - what could be the problem?!

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Sorry didn't read your first post correctly, the actual error results from an extra row in the DUAL table.

    connect as sys
    select count(*) from dual;

    if this returns 2 then you need to remove the extra row

    delete from daul where dummy is null or trim (dummy) is null;

    Regards

    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Nov 2000
    Location
    London
    Posts
    83
    Count for the table dual come back as 1 as well.

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi,

    This metalink note might assist

    http://support.oracle.co.uk/metalink...p_id=1036247.6

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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