Hi friends,
What should be the value in created column of dba_objects ? The time when the object creation started or
when the object creation got completed?
I always thought created means when it gets completed not when it started.
I had this strange behaviour today in 11.2.0.2 DB.
SELECT DBMS_SQLTUNE.report_sql_monitor(
sql_id => '&1',
type => 'TEXT',
report_level => 'ALL') AS report
FROM dual;
Global Information
------------------------------
Status : DONE (ERROR)
Instance ID : 1
Session : TEST (512:3031)
SQL ID : 9u0g63m7y8h8c
SQL Execution ID : 16777216
Execution Started : 04/23/2013 04:28:24
First Refresh Time : 04/23/2013 04:28:25
Last Refresh Time : 04/23/2013 07:20:16
Duration : 10312s
Module/Action : SQL*Plus/-
OBJ Object Type CREATED
-------------------------------------------------- ------------------- ------------------
BIG_TEST TABLE 23-APR-13 04:28:24
Please confirm if this indeed is the case with your views on why so?
Regds,
Kunwar