awk remove file with filenumber less then

I’m restoring a large amount of oracle archived redo logs into one directory. The archived redolog filenames have the following names ‘1_116133_820730017.dbf’ – ‘1_{log_sequence_number}_820730017.dbf’. The log sequence number is reflected in the filename, it is the second number pair – between the first and the second underscore. So it is like: 1_116133_820730017.dbf is 1_<log_sequence_number>_820730017.dbf # […]

Read More…

Trace you own session using dbms_system / set events

For debugging … Make sure the session has a direct execute grant on dbms_system package. Level 12 makes sure to include the waits and bind data. dbms_system begin for i in (select sid, serial# from v$session where audsid=SYS_CONTEXT(‘USERENV’,’SESSIONID’)) loop sys.dbms_system.set_ev ( si => i.sid, se => i.serial#, ev => 10046, LE => 12, nm => […]

Read More…

SQL query to show tables vs indexes in your tablespaces

SQL query below displays a tables / indexes breakdown of your tablespaces. SELECT tablespaces.tablespace_name, NVL( tables, 0) as tables, NVL( indexes, 0) as indexes FROM dba_tablespaces tablespaces LEFT OUTER JOIN ( SELECT COUNT(*) tables, tablespace_name FROM dba_segments WHERE segment_type = ‘TABLE’ GROUP BY tablespace_name ) tables ON tablespaces.tablespace_name = tables.tablespace_name LEFT OUTER JOIN ( SELECT […]

Read More…

Why Oracle May Really Be Doomed This Time

http://pandodaily.com/2012/02/11/why-oracle-may-really-be-doomed-this-time/ I was laying awake early this morning thinking about Oracle. O my Typically I think big public companies are inept, but I would not count Oracle out. Ellison has long shown he viscerally gets where the stock market, the customer and the technology are going. He may be better at this than anyone leading […]

Read More…