Oracle considers "long operation" any operation longer than 6 seconds. Rowid Range Scan: APPU.RT_SK: 1160535 out of 1160535 Blocks done Rowid Range Scan: APPU.RT_SK: 42273 out of 42273 Blocks done Rowid Range Scan: APPU.RT_SK: 38230 out of 38230 Blocks done Rowid Range Scan: APPU.RT_SK: 238934 out of 238934 Blocks done Rowid Range Scan: APPU.RT_SK: 50518 out of 50518 Blocks done Rowid Range Scan: APPU.RT_SK: 99670 out of 99670 Blocks done Rowid Range Scan: APPU.RT_SK: 111958 out of 111958 Blocks done SELECT MESSAGE FROM V$SESSION_LONGOPS WHERE SID IN (SELECT SID FROM V$SESSION WHERE USERNAME='SYS' AND STATUS='ACTIVE') ORDER BY START_TIME During a multi-threaded index rebuild, separate threads are assigned the external merging of each. The actual number of threads created will not exceed the number of index groups in an area if this value is smaller than the maximum. If not specified, the maximum number of threads created will equal the systems number of CPUs. You can specify the maximum number of threads created using the -threadnum n parameter. It was launched using the PARTITION modifier, so that various processes were created in the instance: For Enterprise database licenses, index rebuild is multi-threaded by default. The following example shows the progress of the reconstruction of a partition of an index. In the case of DBA, we know exactly which user is rebuilding the index, so we can simplify it into a single query. We can even come to think that is doing nothing.įor the progress of a long operation we can query the view V$SESSION_LONGOPS, first obtaining the process ID from V$SESSION. When we launch a long operation, such as a RMAN backup or rebuild of a large index, we can come to despair of not having an estimate of the time it may take.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |