Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Red face Unanswered: Oracle 9.2.0.5 - DBMS_STATS error

    I am executing the following code in sql/plus logging in as user XXX who owns a schema in the database

    BEGIN
    DBMS_STATS.GATHER_SCHEMA_STATS(NULL, NULL, FALSE,
    'FOR ALL COLUMNS SIZE 1', NULL, 'DEFAULT', TRUE);
    COMMIT;
    END;

    but get the following error after working for 10-15 minutes. How do I resolve this? Any help is appreciated. I tried to run "dbmsstat.sql" and then run the above script but got the same error.

    ERROR at line 1:
    ORA-12801: error signaled in parallel query server P007
    ORA-01410: invalid ROWID
    ORA-06512: at "SYS.DBMS_STATS", line 9643
    ORA-06512: at "SYS.DBMS_STATS", line 10137
    ORA-06512: at "SYS.DBMS_STATS", line 10324
    ORA-06512: at "SYS.DBMS_STATS", line 10378
    ORA-06512: at "SYS.DBMS_STATS", line 10355
    ORA-06512: at line 3

  2. #2
    Join Date
    Mar 2008
    Posts
    89
    MetaLink note 184416.1
    is detailing the ORA-12801, if you have access to metalink.

    In combination with the INVALID ROWID... This error might say that one of your indexes has an issue.
    and so the subprocesses run by the stats package stumbled over it.
    Just to check:
    Code:
    select * from dba_indexes where status != 'VALID'
    "My brain is just no good at being a relational Database - my relations suck real bad!"

  3. #3
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Thumbs down Did run the command

    and did not find any user indexes that are not valid. Found a few with owner=system and logminer utility one's. Ran again the said "execute ...." and still got the error. Any other suggestions, please?

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    What version of the database are you running.

    Select * from v$version;

    Never mind already answered
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Thumbs down The version is

    SQL> select * from v$version;

    BANNER
    ----------------------------------------------------------------
    Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
    PL/SQL Release 9.2.0.5.0 - Production
    CORE 9.2.0.6.0 Production
    TNS for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production
    NLSRTL Version 9.2.0.5.0 - Production

    SQL>

    The platform is: AIX 5.3 TL-3

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Perhaps I need another cup of coffee, but it appears strange to me that you have NULL for the schemaname.

    It might work better if you actually provided the desired schemaname within the procedure arguments.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Red face This has been working and is working at many sites

    I login as the user who owns the schema and execute this and it has been working at many sites and also on the same machine on a different database instance. I can try providing schema owner but the above fact still will be a question to solve.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > it has been working at many sites and also on the same machine on a different database instance.
    I'll accept the statement above as being true.
    You have all the facts & background information.
    We have only what you post.
    Has this ever worked in this instance & schema? If so, what changed?
    If not, how is this instance or schema different from where codes works?
    You have mystery & all the clues to find & fix the discrepancy.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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