Re: How to benchmark SQL and PL/SQL scripts??

Z. Martinez wrote:
>
> Does anybody know how do benchmarking on SQL and PL/SQL scripts?
>
> I want to know how much load the scripts put on the system.
> I'm mainly concerned about CPU and DISK I/O scores.

  You can do it by the one of the following options in general:

1. Run utlbstat.sql and utlestat.sql to collect the statistics.
2. You can query V$SYSSTAT.
3. You can use Server Manager GUI to collect the information.

  Of course, if you are interested in particular area, you can query different dynamic performance tables. For instance, you want to query about the file I/ O. You can query the v$filestat.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841