Striving for Optimal Performance
  • Blog
    • Archive
    • Categories
    • Search
  • Troubleshooting Oracle Performance
    • Description
    • Structure
    • Table of Contents
    • Forewords
    • Reviews
    • Downloadable Files
    • Addenda and Errata
    • First Edition
  • Public Appearances
    • Past Public Appearances
  • Contact
  • About

TKPROF’s Argument PDBTRACE

21 March 2018 Written by Christian Antognini

If you run TKPROF without arguments, you get a complete list of its arguments with a short description for each of them (here the output generated by version 18.1.0): $ tkprof Usage: tkprof tracefile outputfile [explain= ] [table= ] [print= ] [insert= ] [sys= ] [sort= ] table=schema.tablename Use ‘schema.tablename’ with ‘explain=’ option. explain=user/password Connect […]

Read More 5 Comments

Scripts to Download Oracle Database 18c Documentation

27 February 2018 Written by Christian Antognini

In the past I already shared with you the scripts I use to download the Oracle Database documentation. The aim of this short post is to reference the script I just wrote for 18c. download18.sh Happy downloading as well as happy reading! PS: I also refreshed the scripts for 12.1 and 12.2. Change 2020-02-09: removed […]

Read More 4 Comments

Scripts to Download Oracle Database 12c Release 2 Documentation

1 February 2017 Written by Christian Antognini

In the past (here, here and here) I already shared with you the scripts I use to download the Oracle Database documentation. The aim of this short post is to reference the script I just wrote for the latest version: 12c Release 2. download122.sh Happy downloading as well as happy reading! Update 2018-02-27: new version […]

Read More 4 Comments

Scripts to Download Oracle Database 12c Release 1 Documentation

1 July 2013 Written by Christian Antognini

In the past (here and here) I already shared with you the scripts I used to download the documentation related to Oracle Database. The aim of this short post is to provide the script I just wrote for the latest version: 12c Release 1. download121.sh Happy download as well as happy reading! PS: it is […]

Read More 12 Comments

Scripts to Download Documentation

1 April 2011 Written by Christian Antognini

In this post I pointed out that I like to have a copy of the documentation in PDF format on my notebook. In the same post, and its comments, I also described how I generate the scripts I use to download the files. Recently I updated the scripts and, as a result, I thought to […]

Read More 7 Comments

Script to Download 11gR2 Documentation

9 September 2009 Written by Christian Antognini

I don’t know you, but I like to work with the PDF version of the documentation. The problem is that the PDF files have names that are not very useful (or do you remember that the SQL Reference Guide is named e10592.pdf?). Hence, when I download the documentation, I like to store each PDF with […]

Read More 9 Comments