HOW TO time the performance of a standard query to get CPU performanceThis is a featured page

Platform: Oracle App:
Tool:
DB Ver: 9.2 App Ver:
Tool Ver:
Revision Date: 21-Oct-2006 Keywords: HOWTO, PERFORMANCE CPU TEST

Goal
To time the performance of a standard query to get CPU performance

Facts


Solution
This query was created originally by Jonathan Lewis, and can be used as a benchmark for all Oracle DBs.



Machine Description Run Time
HP Pavillion CPU: 2 x 1.66GHz Mem: 1GB
Only one of the CPUs ran at full tilt, the other idled. 		23.782 secs
CPU: 2 x 1.66GHz Mem: 1GB
Only one of the CPUs ran at full tilt, the other idled. 		1 minute 23 secs

The test query script is:

drop table kill_cpu
/

create table kill_cpu (n, primary key(n))
organization index as
select rownum n from all_objects
where rownum <= 23
/

set timing on

select count(*)
from kill_cpu
connect by n > prior n
start with n = 1
/



consultium
consultium 		Latest page update: made by consultium , Oct 7 2009, 3:40 AM EDT (about this update About This Update consultium Edited by consultium


view changes
- complete history)
Keyword tags: HOWTO PERFORMANCE CPU TEST
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.