Re: what is statspack 'CPU Time' event

Hello Gino,

  Can you please post full statspack report. At this point the only known information is that database is burning CPU.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Gino" <tommy.yan_at_hp.com> wrote in message news:8230d425.0402100057.cdfa861_at_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/control 02.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 - 10:54:42 CST