OraFAQ Forum: Server Administration » Migration 11g: ora-01000 when I call DBMS_STATS

Home » RDBMS Server » Server Administration » Migration 11g: ora-01000 when I call DBMS_STATS (11.1.0.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migration 11g: ora-01000 when I call DBMS_STATS [message #412306]

Wed, 08 July 2009 10:48

farenheiit
Messages: 31
Registered: June 2009
Location: Paris

Member

Hi,

I just migrated my database from 10g to 11.1.0.6

when I try to collect statistics with dbms_stats

EXEC DBMS_STATS.gather_schema_stats('TOTO');

I get the following error:

ERROR at line 1:
ORA-01000: maximum open cursors exceeded
ORA-06512: at "SYS.DBMS_STATS", line 17964
ORA-06512: at "SYS.DBMS_STATS", line 18450
ORA-06512: at "SYS.DBMS_STATS", line 18531
ORA-06512: at "SYS.DBMS_STATS", line 18487
ORA-06512: at line 1

The open_cursor parameter is set to 300 (as it was in 10g).
I increased it to 500 but I still get this issue.

could you help me please? I didn't find anything on metalink.

Report message to a moderator

Re: Migration 11g: ora-01000 when I call DBMS_STATS [message #412316 is a reply to message #412306]

Wed, 08 July 2009 11:33

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

>>I increased it to 500 but I still get this issue.

after modifying open_cursor did you restarted your database?

Report message to a moderator

Re: Migration 11g: ora-01000 when I call DBMS_STATS [message #412395 is a reply to message #412316]

Thu, 09 July 2009 02:55

farenheiit
Messages: 31
Registered: June 2009
Location: Paris

Member

Yes I did, but I think it's the same bug than bug 7651092.
I'm making others tests to be sure it's the same

Report message to a moderator

Re: Migration 11g: ora-01000 when I call DBMS_STATS [message #412435 is a reply to message #412395]

Thu, 09 July 2009 05:57

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

Thanks for the details.

But in feature please post your Operating System details also.

Thanks

[Updated on: Thu, 09 July 2009 06:04]

Report message to a moderator

Previous Topic:	How to remove Oracle Diagnostic pack in absence of OEM
Next Topic:	Multiple Ports on a Single Listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 01:35:14 CDT 2024