Home » RDBMS Server » Server Administration » Migration 11g: ora-01000 when I call DBMS_STATS (11.1.0.6)
Migration 11g: ora-01000 when I call DBMS_STATS [message #412306] Wed, 08 July 2009 10:48 Go to next message
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.

Re: Migration 11g: ora-01000 when I call DBMS_STATS [message #412316 is a reply to message #412306] Wed, 08 July 2009 11:33 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


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

after modifying open_cursor did you restarted your database?
Re: Migration 11g: ora-01000 when I call DBMS_STATS [message #412395 is a reply to message #412316] Thu, 09 July 2009 02:55 Go to previous messageGo to next message
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
Re: Migration 11g: ora-01000 when I call DBMS_STATS [message #412435 is a reply to message #412395] Thu, 09 July 2009 05:57 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

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:
  


Current Time: Tue Dec 06 13:54:10 CST 2016

Total time taken to generate the page: 0.11489 seconds