Q
Problem solve Get help with specific problems with your technologies, process and projects.

Oracle performance recommendations

This isn't an HP question, but it does involve Oracle. We're a healthcare facility that uses PeopleSoft 7 running Oracle 8.1.7 on AIX 4.3.3 and have been having performance problems. The server is an IBM RS/6000 7026-H50, 3 GB RAM (max), 4 CPUs, and SSA disks. We've tuned ASYNC I/O, used multiple VMTUNE parameters, and enabled Fast Cache on our SSA logical volumes as per IBM's suggestions, but still have user complaints. Would you have any other recommendations to help us better our performance?
Is performance bad across the board, or are certain processes taking a long time? My guess would be that it is a process that is consuming I/O, and CPU. Try taking a look at top or Glance and figure out if a certain process is consuming a lot of CPU, then use a query like this to determine the sql:
select s.sid, s.serial#, s.osuser, s.machine, t.sql_text
from v$session s, v$sqltext t , v$process p
where 
  s.sql_address = t.address
and  s.paddr = p.addr 
and  s.sql_hash_value = t.hash_value
and  p.spid = &&PID
order by s.sid, s.osuser, s.process ,t.piece ;

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close