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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Migration from HP Unix to Linux
Next Topic: ora-00354
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 12:38:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.