Jared Still @PerlDBA X Profile

Jared Still

@PerlDBA

Followers

985

Following

2K

Media

54

Statuses

1K

Beaverton Oregon, USA

Joined December 2012

Don't wanna be here? Send us removal request.

Jared Still

@PerlDBA

2 years

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.

2

7

26

Jared Still

@PerlDBA

18 days

Check out my latest article: A Linux One Liner for Interface statistics via @LinkedIn.

linkedin.com

Following is a linux one liner that will display counts and percentages for network interface errors and dropped packets. While not technically a one liner, it could be.

0

1

2

Jared Still

@PerlDBA

2 months

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

Some simple tests that use dd to test io on a filesystem or disk. - jkstill/disk-test

0

1

4

Jared Still

@PerlDBA

2 months

Here is something I learned about a couple years ago involving the oraaccess.xml file. Control fetch size with oraaccess.xml.

pythian.com

Optimize Oracle performance by controlling fetch sizes using oraaccess.xml. Learn how to set fetch sizes for various applications and improve network efficiency.

0

2

7

Jared Still

@PerlDBA

3 months

Check out my latest article: A Geeky post for Friday via @LinkedIn.

linkedin.com

I do not see many (any?) geeky posts here, so here is one for your Friday entertainment. This started out as a one liner.

0

3

5

Jared Still

@PerlDBA

7 months

X was having issues when I first tried to post this. I guess the double post was a bonus.

0

3

Jared Still

@PerlDBA

7 months

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

Jared Still

@PerlDBA

7 months

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

0

3

Jared Still

@PerlDBA

8 months

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

Jared Still

@PerlDBA

8 months

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

0

4

Jared Still

@PerlDBA

9 months

Good interactive explanation of B+ indexing.

SQL Daily

@sqldaily

9 months

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.

0

3

Jared Still

@PerlDBA

9 months

linkedin.com

This article extends the discussion of "dark matter" in ASH by exploring a completely new source of data about event latencies that does not suffer from sampling bias toward longer latencies. This...

0

1

Jared Still

@PerlDBA

9 months

linkedin.com

The last ASHviz installment, Densities and dark matter, was a bit of a cognitive burden, but the concepts introduced are fundamental to many of the ASHviz investigations. Here we continue the thread...

1

0

1

Jared Still

@PerlDBA

9 months

linkedin.com

This installment gets into some deeper concepts relative to visualizing event latency distributions as well as using TIME_WAITED to estimate the volume of events by latency from ASH samples. ASH...

1

0

Jared Still

@PerlDBA

9 months

1

0

Jared Still

@PerlDBA

9 months

linkedin.com

Take another look at the plot in header above. This plot aggregates ASH data by STATE_CLASS using SAMPE_TIME as the x-axis aesthetic.

1

0

Jared Still

@PerlDBA

9 months

linkedin.com

This is a short blurb about being sensitive to whether a visualization that works well in a specific case will translate to more general cases. The plot below shows Average Active Sessions aggregated...

1

0

1

Jared Still

@PerlDBA

9 months

John Beresniewicz ASHViz Blogs.This is a great series on ASH visualization by @JBeresniewicz .

linkedin.com

This article begins what I hope will be an interesting series focusing on some data visualization research I have been engaging using dumps of in-memory ASH (Active Session History) for data and R...

1

0

7

Jared Still

@PerlDBA

1 year

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

Jared Still

@PerlDBA

1 year

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

PVLDB

@pvldb

1 year

Vol:17 No:3 → The Art of Latency Hiding in Modern Database Engines

1

0

4

Jared Still

@PerlDBA

2 years

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 .

0

5

9