Dbms_xplan by Granville Bonyata
I am extremly busy these days and do not have any time to blog.That’s why my friend Granville Bonyate decided to write few small posts.Here is the first on in series. Having worked with Oracle for many (twenty!) years, I sometimes find new features released several years ago that I didn’t catch at the … Read more
OEM 11g Grid Control Release 1
Oracle is releasing OEM 11g on April 22nd.However OEM 11g R 1 is available to download from Oracle E-Delivery site ( 3 files total 4.2 Gb – Linux x86-64 ) http://edelivery.oracle.com Also you can register for Webcast to watch this live event: http://www.oracle.com/enterprisemanager11g/index.html http://www.oracle.com/webapps/events/EventsDetail.jsp?p_eventId=110011&src=6773871&src=6773871&Act=45 Oracle originally had OEM 11g R1 documentation available online but it’s removed .It … Read more
ORION (Oracle I/O Calibration Tool) included in 11g R2
Apparently Oracle included this tool into 11g release 2 database.Orion binary is located under $ORACLE_HOME/bin . Quick run with help command will give very detail explanation how to use this tool.Also Kevin Closson’s Oracle blog got post about Orion: http://kevinclosson.wordpress.com/2006/12/11/a-tip-about-the-orion-io-generator-tool/ -bash-3.2$ orion -help ORION: ORacle IO Numbers — Version 11.2.0.1.0 ORION runs IO performance tests … Read more
Direct path reads and serial table scans in 11g
To answer comment by Frits about Doug Burns observation of using full table scans that resulted in direct path reads. Here is explanation from Oracle itself: There have been changes in 11g in the heuristics to choose between direct path reads or reads through buffer cache for serial table scans. In 10g, serial table scans … Read more
Run away from GUI DBA part 2.Script to report user locks for RAC
Very usefull script to list all user locks in RAC database. SELECT o.name object_name, u.name owner, lid.* FROM (SELECT s.inst_id, s.SID, s.serial#, p.spid,NVL (s.sql_id, 0), s.sql_hash_value, DECODE (l.TYPE, ‘TM’, l.id1, ‘TX’, DECODE (l.request, 0, NVL (lo.object_id, -1), s.row_wait_obj# ), -1 ) AS object_id, l.TYPE lock_type, … Read more
