Joined December 2012
- Tweets 1,494
- Following 119
- Followers 969
- Likes 2,035
54 Photos and videos
Pinned Tweet
7 Nov 2023
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-…
2
7
26
1,669
9 Jul 2025
Check out my latest article: A Linux One Liner for Interface statistics linkedin.com/pulse/linux-one… via @LinkedIn
1
2
113
29 May 2025
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
1
4
110
21 May 2025
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…
2
7
527
2 May 2025
Check out my latest article: A Geeky post for Friday linkedin.com/pulse/geeky-pos… via @LinkedIn
3
5
224
4 Jan 2025
Just got notice that my Oracle ATP DB was paused due to inactivity.
me:
@uptime
UPTIME
----------------------------------------
01:15am up 41 days, 1:15, 1 users
1 row selected.
1
3
155
4 Jan 2025
X was having issues when I first tried to post this. I guess the double post was a bonus.
4
90
3 Dec 2024
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
2
3
136
17 Nov 2024
Can someone explain the use of sqlplus options-static amd -dynamic?
4
118
25 Oct 2024
Good interactive explanation of B indexing
B-trees are one of the most common database index structures
But how do they work?
@BenjDicken has built an interactive tool to show you how databases use these to
Add new values
Search for values
Try it out at
planetscale.com/blog/btrees-…
3
135
21 Oct 2024
John Beresniewicz ASHViz Blogs
This is a great series on ASH visualization by @JBeresniewicz
linkedin.com/pulse/ashviz-vi…
1
7
335
21 Oct 2024
1
1
55
21 Oct 2024
1
50
14 Aug 2024
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
1
5
135
5 Aug 2024
A fascinating paper on techniques used to achieve maximum IO from NVMe SSDs
Vol:17 No:3 → The Art of Latency Hiding in Modern Database Engines vldb.org/pvldb/vol17/p577-hu…
1
4
178
8 Jan 2024
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-…
5
9
333