Have you ever met resistance to using Oracle SQL Trace because the perceived performance penalty is too great? Most of us have heard people express that fear. Is it true? Well, not really. Find out more at the following article. #oracle #pythian #tracing pythian.com/blog/oracle-sql-…

Check out my latest article: A Linux One Liner for Interface statistics linkedin.com/pulse/linux-one… via @LinkedIn

Some oracle F/S files were slow and erratic. I needed something outside the database to show the issues. Less than a benchmark, but sufficient for showing the issue outside the db. github.com/jkstill/disk-test

Here is something I learned about a couple years ago involving the oraaccess.xml file. Control fetch size with oraaccess.xml pythian.com/blog/technical-t…

Check out my latest article: A Geeky post for Friday linkedin.com/pulse/geeky-pos… via @LinkedIn

Just got notice that my Oracle ATP DB was paused due to inactivity. #oracle me: '@uptime' UPTIME ---------------------------------------- 01:15am up 41 days, 1:15, 1 users 1 row selected.

Create a map of file and directory permissions found in oracle homes. It didn't seem important to map log, trc, trm and aud extensions. # cd /u01/app # find app oradata | grep -vE '\.log$|\.aud$|\.tr[mc]$' | xargs stat -c '%n:%a:%U:%G:%F' | tee perm-map.log #oracle

Can someone explain the use of sqlplus options-static amd -dynamic?

Good interactive explanation of B+ indexing

one liner fun:  get all error messages from an oracle alert log, and send to oerr grep -oE '(TNS|ORA)-[[:digit:]]+' alert_ORCL.log| sort -u | perl -p -e '$_=lc($_); s/-/ /' | xargs -n 2 oerr

A fascinating paper on techniques used to achieve maximum IO from NVMe SSDs

Adventures with Oracle's Client Result Cache. My suggestion is to first scroll to the bottom and read a couple of errata in the comments. @Pythian #Oracle pythian.com/blog/mitigating-…