Sfaturi Oracle / Tips and tricks OracleDBA: februarie 2013

2013-02-21

http://www.desprevoi.ro/ai-un-job-esti-platit-bine-esti-prost/

2013-02-20

kernel time sync enabled 4001

Add burst iburst options to your ntp server

http://www.novell.com/coolsolutions/feature/15345.html

how to see the active resource plan manager

select * from v$rsrc_plan;

CPU Quantum

High "Resmgr:Cpu Quantum" Wait Events In 11g Even When Resource Manager Is Disabled [ID 949033.1]

how to collect statistics on subpartitions

granularity => 'ALL' for DBMS_STATS

grid control agent problem in OEL

emdctl: error while loading shared libraries: ... libnnz11.so: cannot restore segment prot after reloc: Permission denied

Solution : disable selinux http://sanjayabalasuriya.wordpress.com/2010/07/16/libnnz11-so-cannot-restore-segment-prot-after-reloc-permission-denied-error-while-running-oracle-clinet-on-rhel-5/

2013-02-18

how to see the temperature for a FUSION IO flash card

fio-status -F iom.temp_internal_deg_c /dev/fioX ( where X can be a,b,c ... )

2013-02-15

exadata secret sauce

http://blog.tanelpoder.com/files/Tanel_Poder_Drilling_Deep_Into_Exadata_Performance.pdf

Exadata’s “secret sauce” for diﬀerent workloads
“DW / Reporing”
• Long running SQL statements
• Executed less frequently
• Secret Sauce: Smart Scans + Oﬄoading + Storage Indexes
• SQL statements should use full table scans + hash joins

“OLTP”
• Short SQL statements
• Executed very frequently
• Secret Sauce: Flash Cache
• SQL & performance tuning is the same as usual!