oracle

Oracle server uptime

The following query works well with Oracle 9i. i’ve no clue whether this works with others too or not. SELECT TO_CHAR (startup_time, ‘DD-MON-YYYY HH24:MI:SS’) “DB Startup Time” FROM SYS.v_$instance; even there is possiblity to find the startup time by quering logon_time from sys.v_$session view.

Oracle server uptime Read More »

Oracle Hidden Parameters

Oracle initialization or INIT.ORA parameters with an underscore in front are hidden or unsupported parameters. One can get a list of all hidden parameters by executing this query: SELECT * FROM SYS.x$ksppi WHERE SUBSTR (ksppinm, 1, 1) = ‘_’; The following query displays parameter names with their current value: SELECT a.ksppinm “Parameter”, b.ksppstvl “Session Value”,

Oracle Hidden Parameters Read More »

Scroll to Top