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 It was launched using the PARTITION modifier, so that various processes were created in the instance: 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 |