Posts Categorized: Pythian

How to Tune Using v$mystat

When reviewing the performance of some queries, it is sometimes useful to review the sessions statistics for each execution of the query. I had a situation that required to look at these stats so I could see why one query would run fast and sometimes much slower. I wrote a simple wrapper ksh shell script for the query. It saves the session statistics in a table before and after the execution of the query and then prints out the statistics in a pivot report. This turned out to be very handy to me and therefore I chose to share it with the world :)

Virtual IOUG Collaborate 13 for Only $299

For only $299 you can access Virtual IOUG Collaborate 13 individually or setup a conference room at your company for the whole team. There will be two tracks broadcasted so if you have demand for both tracks, it make sense to purchase two access passes and setup two tracks broadcasted in parallel in your office so that members of your team can choose individually what to attend.

Big Data is the Commercial Supercomputing in the Age of Datafication

Modern commercial supercomputing in the age of Datafication is what we today call Big Data. I think a better term for it would be Data Supercomputing but the industry has already spoken so Big Data it is. The architecture shifted from environments that required massively-parallel compute-intensive number crunching to massively-parallel data-volume-intensive processing.

A (Oracle) Pirate Looks At: Extending OEM 12c with Oracle Application Management Pack for E-Business Suite

Mother, mother Oracle. I have heard you call… Wanted to sail upon your cloud (control) since 7.3.4… You’ve seen it all, you’ve seen it all… (Paraphrased from Jimmy Buffett’s, “A Pirate Looks at 40”) For a while now, Oracle Enterprise Manager (OEM) has had an application management component for E-Business Suite (EBS). However, it wasn’t…

Page 22 of 194« First...10...2021222324...304050...Last »