Tag Archives: ORCL

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.U1 executes this command:SQL> CREATE TABLE t1 AS(SELECT object_name, sharing, createdFROM dba_objects);U1 complains that the command is taking too long to execute.In the alert log, the database administrator (DBA) finds this:2017/3/6 14:45:17statement in resumable session ‘User U1(136), Session… Read More »

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.U1 executes this command:SQL> CREATE TABLE t1 AS(SELECT object_name, sharing, createdFROM dba_objects);U1 complains that the command is taking too long to execute.In the alert log, the database administrator (DBA) finds this:2017-03-06T12:15:17.183438+05:30statement in resumable session ‘User U1(136), Session 1,… Read More »

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties: 1. A size of 100

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:1. A size of 100 MB2. AUTOEXTEND is off3. UNDO_RETENTION is set to 15 minutes4. It has RETENTION GUARANTEEUNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.What will happen when the next update is attempted by any transaction? A. It succeeds and the generated… Read More »