CPU idle is 8 ,lower than 20

[former_member670967]

cpu idle is 0 ,lower than 20

14889 35.7 1519480 1483640 orashp 08:01:05 oracleSHP (DESCRIPTION=(LOCAL=NO)(SDU=32768))

14878 27.2 1516224 1485264 orashp 08:00:29 oracleSHP (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

18467 1.5 1525744 1476680 orashp Aug_23 ora_lgwr_SHP

14875 1.1 67616 56072 orashp 08:00:10 brconnect -u / -jid STATS20080904080000 -c -f stats -t ALL

3 0.3 0 0 root Apr_30 fsflush

14933 0.3 4152 2976 root 08:04:37 /usr/local/sbin/sshd -R

[fidel_vales]

Hi,

Please, express yourself providing much more information.

You know, I have lost my magic ball

I assume that you mean that in your database server cpu is being used at 100%.

I'm I correct.

and the bunch of numbers that you paste without any kind of explanation have a meaning and even could be that some of those numbers have something to do with the CPU (sorry, but right now I'm not in the mood to search for the documentation of a unix ps to see what are the columns that you have pasted)

So, if they have something to do with CPU and if they are sorted from top CPU usage, then I see that the second one is a local connection ((DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

So, first thing to do is to find who is connected directly to your oracle (via sqlplus) and causing the second highest CPU consumption?

second thing is check to which SAP workprocess is the first one connected to and find out what that is doing

third thing is to check your oracle parameters and your expensive statements sorted by buffer gets.

[former_member670967]

Hi Fidel,

SAP run program RSDBAJOB this time.

Follow is our oracle parameters:

*._b_tree_bitmap_plans=FALSE

*._optimizer_or_expansion='depth'

*._push_join_predicate=FALSE

*.aq_tm_processes=1

*.background_dump_dest='/oracle/SHP/saptrace/background'

*.compatible='9.2.0.0.0'

*.control_file_record_keep_time=30

*.control_files='/oracle/SHP/sapdata/cntrl/cntrlSHP01.ctl','/oracle/SHP/sapdata/cntrl/cntrlSHP02.ctl','/oracle/SHP/sapdata/cntrl/cntrlSHP03.ctl'

*.core_dump_dest='/oracle/SHP/saptrace/background'

*.db_block_size=8192

*.db_cache_size=838860800

*.DB_DOMAIN='WORLD'

*.db_file_multiblock_read_count=8

*.db_files=1024

*.db_name='SHP'

*.dml_locks=6250

*.enqueue_resources=8000

*.event='10028 trace name context forever, level 1','10027 trace name context forever, level 1','10183 trace name context forever, level 1','10191 trace name context forever, level 1','38068 trace name context forever, level 100'

*.fal_client='SHP_std'

*.fast_start_mttr_target=300

*.hash_join_enabled=false

*.instance_name='SHP'

*.java_pool_size=0

*.job_queue_processes=10

*.large_pool_size=20971520

*.log_archive_dest_1='location=/oracle/SHP/saparch'

*.log_archive_dest_2='service=SHP_std optional reopen=60 max_failure=10 delay=1440'

*.log_archive_format='SHP_%s.arc'

*.log_archive_start=TRUE

*.log_buffer=8192000

*.log_checkpoints_to_alert=true

*.open_cursors=800

*.optimizer_features_enable='9.2.0'

*.optimizer_index_cost_adj=10

*.pga_aggregate_target=419430400

*.processes=150

*.query_rewrite_enabled='FALSE'

*.remote_os_authent=true

*.replication_dependency_tracking=false

*.shared_pool_size=524288000

*.sort_area_size=2097152

*.star_transformation_enabled='FALSE'

*.timed_statistics=TRUE

*.transaction_auditing=false

*.undo_management='AUTO'

*.undo_retention=10800

*.undo_tablespace='PSAPROLL'

*.user_dump_dest='/oracle/SHP/saptrace/usertrace'

*.utl_file_dir='/oracle/SHP/saptrace/usertrace'

Thanks!

Lily