what is statspack 'CPU Time' event

From: Gino <tommy.yan_at_hp.com>
Date: 10 Feb 2004 00:57:02 -0800
Message-ID: <8230d425.0402100057.cdfa861@posting.google.com>

Hi ,

Here's running application on oracle9i hpux. This application does sequential reads and writes to database. The system is HP Itanium2 hpux11.23 with 16cpu&32G memory. It's strange that I saw a 'CPU time' evnet from stapspack top events. What does it mean and how can I get rid of it?

Top 5 Timed Events

---

% Total

Event                                               Waits    Time (s)

Ela Time

-------------------------------------------- ------------ -----------
--------
CPU time                                                          199 
  44.93
db file sequential read                            85,452         173 
  39.02
SQL*Net more data to client                        69,617          23 
   5.19
db file scattered read                              6,578          21 
   4.81
direct path read                                    6,443          14 

   3.06

Here's init.ora.

*._kgl_latch_count=64
*._lgwr_async_io=true
*._lgwr_io_slaves=4
*._log_simultaneous_copies=64
*.log_checkpoint_timeout=999999999
*.log_checkpoint_interval=999999999
*.background_dump_dest='/oracle/admin/ora/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/oracle/admin/ora/control01.ctl','/oracle/admin/ora/control02.ctl','/oracle/admin/ora/control0

3.ctl'

*.core_dump_dest='/oracle/admin/ora/cdump'
*.cursor_sharing='force'
*.cursor_space_for_time=true
*.db_block_size=4096
*.db_cache_size=2G
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_name='ora'
*.db_writer_processes=8
*.disk_asynch_io=true
*.fast_start_mttr_target=6000
*.hash_join_enabled=TRUE
*.hpux_sched_noage=178
*.instance_name='ora'
*.java_pool_size=0
*.large_pool_size=8388608
*.log_buffer=126720000
*.log_parallelism=4
*.open_cursors=2000
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=1G
*.sort_area_size=5242880
*.star_transformation_enabled='FALSE'
*.undo_management='AUTO'
*.undo_retention=1
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/admin/ora/udump'
Received on Tue Feb 10 2004 - 02:57:02 CST