OpenNetwork.xyz   Placeholder for our stuff related to Telecom, IT, Internet of things (IOT), ESP8266, Raspberry Pi

Oracle Database

 PuTTY doesn't support column greater than 180 approx, What you can do is pipe your output through less with the -S option, which tells it not to wrap long lines, and use the left and right arrow keys to scroll sideways:

your_command | less -S
./queryScript | less -S


Note that this will only work if the command is invoked from a shell, but not from within an SQL client

Login as sysdba
sqlplus / as sysdba

Query to get oracle DATABASE name
select * from v$database;

Query to get database mode
select open_mode from v$database;

Query to get hostname
select host_name from v$instance;

Query to get DATABASE_ROLE (PRIMARY or PHYSICAL STANDBY)
select database_role from v$database;

Find last queries of oracle (This will give you last half day i.e. 12 hours).
SELECT * FROM V$SQL V where to_date(v.FIRST_LOAD_TIME,'YYYY-MM-DD hh24:mi:ss') > (sysdate - 1/2)

© 2019 Suresh Hariramani