Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

who know oracle tuning performance step? please tell me ,thanks

hongjing_zhang
Trusted Contributor

who know oracle tuning performance step? please tell me ,thanks

who know oracle tuning performance step? please tell me ,thanks
6 REPLIES
Michael Tully
Honored Contributor

Re: who know oracle tuning performance step? please tell me ,thanks

RAC_1
Honored Contributor

Re: who know oracle tuning performance step? please tell me ,thanks

There are different methods, ways to tune the oracle so as to get best possible performance from it.

1. You can use raw devices/file systems and benchmark to decide which one to use. (Though the file systems are preferred due to ease of management and other advantages. Gurus on this forum can help you a lot in this regard)

2. Kernel tuning.
This one of the most imp. The rightly tuned kernel parameters will boost the oracle performance. There is a list of parameters which you should tune to get good performance from oracle.
maxdsiz, maxdsiz_64bit
maxtsiz, maxtsiz_64bit
maxssiz,maxssiz_64bit
shmmax, max_thread_proc
dbc_max_pct, dbc_min_pct
semmns, semmni
semmap, semume
semmnu, msgmax
msgmnb, msgmni
msgseg, msgtql
maxuproc, nproc

3. Also get DBA involved in this.
There is no substitute to HARDWORK
Steven E. Protter
Exalted Contributor

Re: who know oracle tuning performance step? please tell me ,thanks

This document will help you.

At least it might. It won't open right now. It used to be an intro to performance tuning written by one of HP's Oracle performance gurus.
http://www2.itrc.hp.com/service/cki/search.do?category=c0&docType=Security&docType=Patch&docType=EngineerNotes&docType=BugReports&docType=Hardware&docType=ReferenceMaterials&docType=ThirdParty&searchString=UPERFKBAN00000726&mode=id&admit=-1335382922+1062740769654+28353475&searchCrit=allwords&printable=true

I'm attaching some scripts that will help you collect performance data.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
T G Manikandan
Honored Contributor

Re: who know oracle tuning performance step? please tell me ,thanks

Oracle tuning is a huge area.It involves

check this chapter of tuning and check what you are looking for.

Revert on further help.

there are lot of Oracle tools statspak,sql trace which can be very helpful

http://www.csee.umbc.edu/help/oracle8/server.815/a67775/toc.htm
Jean-Luc Oudart
Honored Contributor

Re: who know oracle tuning performance step? please tell me ,thanks

This is a very large subject. Or Should I say endless !

Check this Web site , have a look at the tuning by layers PPT.

http://www.ixora.com.au/tips/

Rgds,
Jean-Luc
fiat lux
Yogeeraj_1
Honored Contributor

Re: who know oracle tuning performance step? please tell me ,thanks

hi,
-
If you are on Oracle 8.1.7.4 and above, you should try STATSPACK. If you need further assistance, please let us know.
-
Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)