Database


Database Notes

  • RAC and DB Support Tools Bundle (Doc ID 1594347.1) Oracle's centre of expertise has been busy building tools to automatically monitor Oracle Databases that runs on the host.Many customers have put together their own collections of disparate ...
    Posted 19 Mar 2015, 06:52 by Alan Nolan-Davies
  • Memory Resizing select START_TIME, component, oper_type, oper_mode, initial_size/1024/1024 "INITIAL", FINAL_SIZE/1024/1024 "FINAL", END_TIME from v$sga_resize_ops where component in ('DEFAULT buffer ...
    Posted 21 May 2014, 04:15 by Alan Nolan-Davies
  • KGH: NO ACCESS select * from v$sgastat where pool = 'shared pool' and (name in ('free memory', 'sql area', 'library cache', 'miscellaneous', 'row cache', 'KGH: NO ACCESS') ); 
    Posted 21 May 2014, 04:12 by Alan Nolan-Davies
  • Active Sessions with Command SELECT vs.inst_id, vs.username, vs.sid, vs.serial#,          TO_CHAR(vs.logon_time,'DD-MON-YY hh24:mi:ss') CONNECTED, vs.status,         CASE               when vs.command = 0 then ...
    Posted 21 May 2014, 03:39 by Alan Nolan-Davies
  • Online Redo Log Members SELECT group#        ,  thread#             ,  sequence#           ,  (bytes/1024)/1024 MB,  members             ,  status              ,  first_change#       ,  TO_CHAR(first_time,'DD-MON-YY HH24:MI SS') FIRST_TIMEfrom v$log
    Posted 20 May 2014, 08:37 by Alan Nolan-Davies
Showing posts 1 - 5 of 13. View more »


Subpages (1): database notes
Comments