Jared Still

[Jared Still @PerlDBA]

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

https://t.co/CepQWew6oz

[Jared Still @PerlDBA]

@ESPNF1 Looks like you folks got the F out of Spa

[Jared Still @PerlDBA]

Check out my latest article: A Linux One Liner for Interface statistics https://t.co/O4t8VXfakM via @LinkedIn

[Jared Still @PerlDBA]

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.

https://t.co/I1ksPC0OH5

[Jared Still @PerlDBA]

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

Control fetch size with oraaccess.xml

https://t.co/Ummwteyo7l

[Jared Still @PerlDBA]

Check out my latest article: A Geeky post for Friday https://t.co/mmM0L0Uu4o via @LinkedIn

[Jared Still @PerlDBA]

@connor_mc_d Looks like someone has made a real hash of it.

[Jared Still @PerlDBA]

@NotTravisNewman @itsfoss 🤣

[Jared Still @PerlDBA]

@oraclebase Indeed. I raised on a couple years ago about a sqlplus issue. There is a bug, no action in some time.
And it is one that should be an easy fix.

[Jared Still @PerlDBA]

@GithubProjects https://t.co/WETya3P2EC

[Jared Still @PerlDBA]

@Cmdr_Hadfield @JLOracle A 10x Carrington event would pretty much end civilization as we know it.

[Jared Still @PerlDBA]

@laurentsch Not sure just how you're using this, but 'grep -Bn' does come to mind.

[Jared Still @PerlDBA]

@chessMan786 @fritshoogland one of the reasons for hugepages

[Jared Still @PerlDBA]

@whiteboardcoder if there are ever spaces in the file names:
add -print0 to find
add -0 to xargs

sort by date, though this can be trickier than it appears
... | xargs ls -ldtar

sort by size, descending, get top 10
... | xargs ls -ldtS | head -10

[Jared Still @PerlDBA]

@Python_Dv more aliases
o: load a set of directories into an array
g: goto to a directory in the array
add-time: alias for adding time to my journal
mrskew: oracle tool for profiling trace files.

[Jared Still @PerlDBA]

@Python_Dv ...5570 o
5305 find
4794 echo
4440 less
4248 get-time
3878 ls
3544 perl
3467 rm
3382 cp
3193 mrskew
2588 ofind

[Jared Still @PerlDBA]

@JonathanGennick That looks quite interesting. Usually my use of Python with outliers is to remove them, as outliers obliterate charts.
Some of these outliers are interesting and worth investigation, but time does not suggest permit

[Jared Still @PerlDBA]

@itsfoss It ain't Windoze

[Jared Still @PerlDBA]

@TanelPoder I recall using blkparse, and feeling it was insufficient. The problem with tools like this for many folks is they are not used frequently enough to recall just what to look for.
If I have need of it again, I may look at developing something more user-friendly.