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 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 »

Rename Oracle database username

No, this is not available till now in Oracle and has been noted down as a enhancement request. Still here is a workaround way of doing that: Do a user-level export of user A create new user B import system/manager from user=A to user=B drop user A

Scroll to Top