How to Know the Start Time for an Oracle Database
The "V$DATABASE" log keeps a record of all metadata for an Oracle database. You use this log to view the creation or "start time" for an Oracle database. This view helps you determine when a database was created to determine when you need to create a backup or update the Oracle drivers. It's also useful if you need support from Oracle and the support technician asks for the metadata.
Other People Are Reading
Instructions
-
-
1
Open the Oracle Enterprise Management software on your computer. Log in to the server and database you want to query.
-
2
Open the PL/SQL editor, so you can type the "V$DATABASE" command for the database at which you connected.
-
-
3
Type the following code to display the creation date for the database:
select created from v$datafile;
-
4
Click "Execute" to run the statement. The date displayed is the start date for the Oracle database.
-
1
