I'm trying to calculate the elapsed time of Oracle Database
startup command. The view
V$INSTANCE contains the
STARTUP_TIME column which tells at what time the database is started. But, i need way to find the time elapsed from the time we enter
startup till the database is opened.
Since, we can't query
SYSTIMESTAMP when the database is not open, im finding it difficult to come up with a logic.
Is there any other way we can get the elapsed time for