Home » RDBMS Server » Server Administration » find out oracle startup timestamp
find out oracle startup timestamp [message #244049] Mon, 11 June 2007 08:19 Go to next message
moschen
Messages: 25
Registered: April 2007
Junior Member
Hi,

does anyone know if it is possible to receive something like a timestamp when a certain oracle database was started up for the last time? Or is it possible to have oracle execute a certain procedure when it is started up?

I am using oracle 10g as a database.

Best regards,
Moschen
Re: find out oracle startup timestamp [message #244056 is a reply to message #244049] Mon, 11 June 2007 08:39 Go to previous message
moschen
Messages: 25
Registered: April 2007
Junior Member
Ups, sorry, just found it myself:

SELECT INSTANCE_NAME "Instance Name",
HOST_NAME "Host Name",
VERSION "Version",
STARTUP_TIME "Startup Time",
STATUS "Status"
FROM V$INSTANCE;

Best regards,
Moschen
Previous Topic: Migration from HP Unix to Linux
Next Topic: ora-00354
Goto Forum:
  


Current Time: Sun Dec 04 06:48:59 CST 2016

Total time taken to generate the page: 0.11643 seconds