Advertising and Web Hosting on Woodwind.Org!

Klarinet Archive - Posting 000800.txt from 2000/04

Subj: [kl] Profiling tools on DSD
Date: Wed, 19 Apr 2000 10:45:54 -0400

I just talked with Kelly Petersen and it appears as if DSD will be our "testbed" for performance changes, profiling, etc. (not baseline testing - that'll be DSP). Could you or Tina execute the system packages required so we can use the new PL/SQL profiling tools available in 8i? I'm changing some of the SOP code to use bulk bindings and other explicit optimizations and need to see if I'm going in the right direction, especially since my next step will be re-writing the SQL for parallel execution and the Middleware server for true multi-threaded execution instead of its current queueing method.

Mark Charette, Performance Team Lead

>From the on-line manual: DBMS_PROFILER must be installed as SYS. Use the PROFLOAD.SQL script to load the PL/SQL Profiler packages

Unsubscribe from Klarinet, e-mail:
Subscribe to the Digest:
Additional commands:
Other problems:

     Copyright © Woodwind.Org, Inc. All Rights Reserved    Privacy Policy    Contact