As you know ddl from subpartitioned table is running extremely slow, i’m sure you know why (if not i can tell), but i want to present other strange situation during generation of ddl.
- Create table from attachement. This is subpartitioned table, simply, i want to simulate long running extract ddl.
- Try to extract ddl this table, watch CPU usage… afther fev seconds CPU should be 100% consumed for few seconds, afther that … do following:
3.Open sqlEditor and try execute any statement (during this time session is busy with creation ddl) for example select sysdate from dual …
- Than you will see dialog with question to use anothers session to execute because current session is busy. Click NO … sql will be executed!!
Watch trace log from attachement, at the end of file you can see seperate sqls selecting value of subpartitions, but between those sqls you can see “select sysdate from dual” - executed as I presented. I think ddl mechanism from subpartitioned/partitioned tables should be improve… (by the way as I wrote i previous post values for subpartitions are in uppercase, but partition/subpartition keys are caseSensitive)
navlog0003.zip (34.5 KB)