Jared Still @PerlDBA

Beaverton Oregon, USA Joined December 2012

Tweets

1K
Followers

987
Following

121
Likes

2K

Jared Still @PerlDBA

3 months ago

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

0 1 2 103 0

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-t…

0 1 4 109 1

Jared Still @PerlDBA

4 months ago

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…

0 2 7 524 0

Jared Still @PerlDBA

5 months ago

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

0 3 5 153 0

Jared Still @PerlDBA

9 months ago

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.

2 0 3 123 0

Jared Still @PerlDBA

10 months ago

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

0 2 3 128 0

Jared Still @PerlDBA

11 months ago

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

0 0 4 117 0

Jared Still @PerlDBA

11 months ago

Good interactive explanation of B+ indexing

SQL Daily @sqldaily

11 months ago

Good interactive explanation of B+ indexing

0 15 41 2K 35

0 0 3 133 0

Jared Still @PerlDBA

a year ago

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

0 1 5 134 0

Jared Still @PerlDBA

a year ago

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

PVLDB @pvldb

a year ago

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

0 19 146 11K 146

Download Image

1 0 4 176 0

Jared Still @PerlDBA

2 years ago

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/mitigatin…