Each time we use sqlplus – we usually need check dataguard status, database role, and collect details on our system. This help us to be more proactive and collect data to leave the database in same status we started to work. A good approach is to get all details automatically without getting trash for our screen output. Same examples are below – I have been using this a couple of years and is very helpful in my day by day.<\/p>\n\n\n
glogin.sql – update the file under $ORACLE_HOME\/sqlplus\/admin<\/strong><\/p>\n\n\n Each time we use sqlplus – we usually need check dataguard status, database role, and collect details on our system. This help us to be more proactive and collect data to leave the database in same status we started to … Continue lendo set linesize 200\ndefine _editor=vi\nset serveroutput on size 1000000\nset pagesize 9999\ncolumn plan_plus_exp format a80\ncolumn global_name new_value gname\nset termout off\ndefine gname=idle\ncolumn global_name new_value gname\nselect lower(user)||'@'||instance_name||'('||host_name||')' global_name from v$instance;\n--set sqlprompt '&gname> '\nset termout on\ncolumn db_unique_name format a16\ncolumn database_role format a16\ncolumn db_version format a10\ncolumn db_status format a8\ncolumn db_compatible format a10\ncolumn db_version heading VERSION\ncolumn db_status heading STATUS\ncolumn db_compatible heading COMPATIBLE\nselect d.db_unique_name, d.database_role, d.open_mode, v.version db_version,\np.value db_compatible, v.status db_status\nfrom gv$database d, gv$instance v, gv$parameter p\nwhere p.name = 'compatible'\nand d.inst_id=v.inst_id and v.inst_id = p.inst_id\n;\ncol logins format a8\ncolumn instance_name format A14\ncolumn status format A8\ncolumn CONNECTED format A12\ncolumn host_name format A34\nselect host_name,instance_name,\nstatus, to_char(startup_time,\n'DD-MON-YYYY HH24:MI ') \"Startup time\",logins,\ndecode(instance_name,(select instance_name from v$instance) ,'CURRENT','NOT CURRENT') CONNECTED\nfrom gv$instance\n\/<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"