Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CREATED column in dba_objects view

KunwarApr 23 2013 — edited Apr 29 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2013
Added on Apr 23 2013
7 comments
686 views