how to find the startup time of database

[Former Member]

hai sap guru's,

how to find the startup time of database

can u tell me the procedure ?

thanks & regards

sathish

[fidel_vales]

If you use Oracle, you can see the startup time on the transaction st04, it is on the top right. It also appears in ST04N and DBACockpit.

[Former Member]

Hi,

use following query

SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time"

FROM sys.v_$instance;

regards,

kaushal

[Former Member]

hai sap guru's'

where can i use that query.

thanks & regards

sathish

[Former Member]

Hi,

if you use oracel DB

connect oracle DB with sqlplus and execute this query

this query is not work with sql server

you can use sqlserver log for find the start db time

or

the tempdb is created at very startup of the SQL Server service you can check the information by running

sp_helpdb tempdb

regards,

kaushal

Edited by: kaushal malavia on Jan 18, 2008 5:14 PM