Home » RDBMS Server » Performance Tuning » New to tuning (12c)
New to tuning [message #681614] Sun, 09 August 2020 05:07 Go to next message
mdarifdxb20
Messages: 5
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.
Re: New to tuning [message #681617 is a reply to message #681614] Sun, 09 August 2020 05:19 Go to previous message
Michel Cadot
Messages: 67488
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

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


Current Time: Sat Oct 31 14:49:56 CDT 2020