Striving for Optimal Performance (Christian Antognini)
This blog is a mirror of http://antognini.ch/blog
Nach Ordnungsbegriffen durchsuchen
Alle Ordnungsbegriffe
»
TOP
(
RSS
)
10gR1
10gR2
11gR1
Execution Plan
Query Optimizer
Speaking
SQL Trace
TVD$XTAT
What Are Hints?
22 Dezember 08 08:43
|
Striving for Optimal Performance
Yesterday, while reading a swiss italian dialect tranlation of Le petit prince (entitled Ul principe pinin), I noticed a very interesting discussion between the little prince and the king (the inhabitant of the first planet visited by the little prince…...
Automatic Evolution of SQL Plan Baselines
10 Dezember 08 05:00
|
Striving for Optimal Performance
In the section Evolving SQL Plan Baselines of TOP (pages 299-300) I explain what an evolution is and how to manually do it. What I do not cover is the automatic evolution. In fact, I wrote only the following text about it: “In addition to the manual...
TVD$XTAT 4.0 Beta 8
17 November 08 09:08
|
Striving for Optimal Performance
This is just a short note to point out that I just uploaded under the section Downloadable Files of TOP a new version of TVD$XTAT. The change log since Beta 7 is the following: Improved generation of synthetic cursors (particularly for RPC and XCTEND...
Introduce TVD$XTAT
24 Oktober 08 03:56
|
Striving for Optimal Performance
Trivadis Extended Tracefile Analysis Tool (TVD$XTAT) is a command-line tool. Like TKPROF, its main purpose is to take a raw SQL trace file as input and generate a formatted file as output. Why Is TKPROF Not Enough? In late 1999, I had my first encounter...
TOP on Google Book Search
10 Oktober 08 11:43
|
Striving for Optimal Performance
This is a short note to point out that my book, Troubleshooting Oracle Performance, is available on Google Book Search. To browse through it or to use the search capabilities provided by Google, click here. Even if the preview is limited to certain number...
Book Presentation
23 September 08 11:40
|
Striving for Optimal Performance
I already pointed out in a previous post that Tanel Poder will be speaking in Vienna, Düsseldorf, Munich and Zürich next December. The news is that an additional presentation (followed by an aperitif) will take place at the same locations and dates as...
TOP: Addenda and Errata
06 September 08 03:03
|
Striving for Optimal Performance
This is a short note to inform that the first errata list of Troubleshooting Oracle Performance (TOP) is available here. It goes without saying that I will update the list whenever necessary. You can send additional errors and comments to top@antognini...
TOP: Downloadable Files Are Available
21 August 08 09:05
|
Striving for Optimal Performance
This is a short note to inform that the scripts of TOP are available here. Please, do not hesitate to get in touch with me in case of any problem with them. Happy testing!
TOP: Front Matter and Chapter 1
11 Juli 08 12:00
|
Striving for Optimal Performance
I just noticed that the front matter (i.e. table of contents, forewords, acknowledgments, introduction, …) and chapter 1 of TOP are available as PDF on Apress’s website. The URLs are the following: Front matter Chapter 1 With this information...
TOP Is At Last Available
07 Juli 08 03:13
|
Striving for Optimal Performance
At last my book, Troubleshooting Oracle Performance (TOP), is available! The proof is that today I have received my first printed copies. What a special moment! You will find more information about the book, links to online bookstores and more at http...
Operation CONNECT BY WITH FILTERING
17 Juni 08 11:09
|
Striving for Optimal Performance
It happened to me several times to being asked about the mysterious full table scan in CONNECT BY operations. In this post I would like to share with you some of the information I wrote about it in my book (pages 233 to 236) . The operation CONNECT BY...
Suche
Los
Dieser Blog
Home
Ordnungsbegriffe
10gR1
10gR2
11gR1
9iR2
Execution Plan
Indexes
Object Statistics
PerformaSure
Query Optimizer
Speaking
SQL Trace
TOP
TVD$XTAT
Uncategorized
Navigation
Home
Blogs
Syndikation
RSS
Atom
RSS Kommentare