Re: Maximum number of enqueue resources exceeded -- but can't reset this!

I assume you modified init.ora parameter ENQUEUE_RESOURCES and bounced the database (its a static parameter that can't be changed dynamically)? And that did not work? That's strange.

I also think that 9000 partitions is a lot. See Metalink note 76765.1. The real limit of partitions and subpartitions for a table is 64K-1 but the note says that "practically, 1,000 partition tables have been tested". Another interesting remark in this note is that when a query on a table is compiled metadata is loaded in the cache, so physical limits may occur.

Carl <carl.petitt_at_verizon.net> schreef in berichtnieuws cc9148a2.0206221639.5a66d6e1_at_posting.google.com...
| Hi,
|
| I've created a fact table for a data warehouse (Oracle 8.1.6) and have
| partitioned the table using RANGE partitioning. I have over 9000
| partitions, which i assume is not a problem. But as soon as i tried
| to create a local index on a column i got this message:
|
| ERROR at line 1:
| ORA-00604: error occurred at recursive SQL level 1
| ORA-00052: maximum number of enqueue resources (1308) exceeded
|
| I checked DBA Studio, and indeed this is what my enqueue resources are
| set to. But i tried changing them and Oracle won't accept the change.
| I reset them to 10000 and it didn't take, i restarted the database,
| and finally restarted the machine, and Oracle still thinks the enqueue
| resources are set to 1308. I know this is related to processes,
| transactions, and so forth, but i am over my head.
|
| How do i reset the enqueue resources? what am i missing? Help!
|
| THanks, Carl Petitt
Received on Sun Jun 23 2002 - 04:30:06 CDT