Re: what is statspack 'CPU Time' event

Hi

I'm not sure we even know that. All we can tell is that the system waited on CPU for 199 seconds in *some measurement interval*, obviously if that measurement interval were 9 1/2 weeks noone would much care. If it were gone in 60 seconds on the other hand...

sorry for the puns, feeling frivolous today, even if there is a serious point in there.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Ron" <support_at_dbainfopower.com> wrote in message
news:4-udnd1UD4ralrTdRVn-uA_at_comcast.com...


> 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'

>

>