Home » RDBMS Server » Performance Tuning » Regarding CPU utilization
icon5.gif  Regarding CPU utilization [message #127510] Tue, 12 July 2005 00:28 Go to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
hi all,
We have written a procedure which is parsing a xml string maually that is by checking for its tags with instr and substr etc,not by DOM process.so we have to use a lots of case statement.And we are also using pl/sql tables.
But while load testing this procedure,it shoows 100% CPU utilization and at around 8% memory utilization.
Pls sugesst some ways to reduce the CPU Utilization..

Thanks
Dinesh

Report message to a moderator

Re: Regarding CPU utilization [message #127546 is a reply to message #127510] Tue, 12 July 2005 02:49 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Some suggestions:

1. Use Oracle's native XML capabilities (XMLType data type and functions like updateXML, Extract, etc.)

2. Store more data in memory using PL/SQL tables. Use bulk operations to fetch and manipulate the data.

3. Use the PL/SQL Profiler to see what sections of your code are taking too long and rewrite them.

4. Convert the database to use Native PL/SQL Compilation.

Best regards.

Frank

Report message to a moderator

Re: Regarding CPU utilization [message #127549 is a reply to message #127546] Tue, 12 July 2005 03:01 Go to previous messageGo to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Thanks frank again,
What is pl/sql profiler, and how can i use it to see which section of code is using too long.
And for native copilation ,i think there is a init parameter,that i have to set.

Thans and regards
Dinesh

Report message to a moderator

Re: Regarding CPU utilization [message #127588 is a reply to message #127510] Tue, 12 July 2005 07:43 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
You might also be able to increase your array size, so that you not only process things in bulk but do so in a larger bulk amount than normal (test at the 500 - 1000 row level).

dbms_profiler:

http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_profil.htm#996728

Oracle Reference Guide (with all init params):

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/toc.htm

Oracle plsql user guide (with info about both):

http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10807/12_tune.htm#sthref1280

Report message to a moderator

Re: Regarding CPU utilization [message #127600 is a reply to message #127588] Tue, 12 July 2005 08:15 Go to previous message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Thanks smartin,
for your information.

One more concern is as my prg is using pl/sql table so i am using the array(index) concept to get the value stored in it a number of time.
If i will store this value (i.e. array(index)) in a variable at the start and will refer this variable then will it have any performance increase for my prg.


Thanks
Dinesh

Report message to a moderator

Previous Topic: Trace files not getting generated
Next Topic: steps for tuning oracle...!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 06:28:11 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.