OraFAQ Forum: Performance Tuning » New to tuning

Home » RDBMS Server » Performance Tuning » New to tuning (12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Switch to threaded view of this topic

Create a new topic

Submit Reply

New to tuning [message #681614]

Sun, 09 August 2020 05:07

mdarifdxb20
Messages: 7
Registered: August 2020

Junior Member

i have too many doubts on oracle tuning, basically to understand why the application is slow. when to use Index. i wanted to know what is the learning path for Oracle performance tuning. Do i need to study more on Architechture and then dwell into tuning.Kindly advice. Do i need to be good at infrastructure like networking and hardware.

Report message to a moderator

Send a private message to this user

Re: New to tuning [message #681617 is a reply to message #681614]

Sun, 09 August 2020 05:19

Michel Cadot
Messages: 67887
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can first read:
- OraFAQ Forum Guide, Detailed OraFAQ Forum Guide section, Performance Tuning paragraph
- Performances Tuning sticky
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL Wiki page

You can also have a look at Database Performance Tuning Guide.

You can also buy the books from Stephane Faroult.

[Updated on: Sun, 09 August 2020 05:19]

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

Previous Topic:	DBMS_AUTO_SQLTUNE
Next Topic:	Physical read IO requests higher than total

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 21 21:33:52 CDT 2021