A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

asrblogger

close up of open book 3 min read

Computer memory is managed in blocks of storage known as pages, which have a predetermined size that depends on the...

white paper 1 min read

SELECT to_char(begin_interval_time,’YY-MM-DD HH24′) snap_time, dhso.object_name, sum(db_block_changes_delta) BLOCK_CHANGED FROM dba_hist_seg_stat dhss, dba_hist_seg_stat_obj dhso, dba_hist_snapshot dhs WHERE dhs.snap_id = dhss.snap_id AND dhs.instance_number...

light road red yellow 3 min read

Traditional startup/shutdown command prior to 12c. Shutdown Command SHUTDOWN NORMAL SHUTDOWN IMMEDIATE SHUTDOWN ABORT Startup Command STARTUP STARTUP NOMOUNT STARTUP...

square gap in beige wall 1 min read

Archivelog gap set pagesize 320 set linesize 200 set wrap off select thread#, sequence#, applied,to_char(first_time,’mm/dd/yy hh24:mi:ss’) first,to_char(next_time, ‘mm/dd/yy hh24:mi:ss’) next,to_char(completion_time,...

person holding apple magic mouse 4 min read

Private SQL area holds information about a parsed SQL statement and other session specific information for processing. When a server...