| performance tuning novice [message #64943] |
Sun, 14 March 2004 19:13  |
Avi
Messages: 23
Registered: January 2002
|
Junior Member |
|
|
Hi Guys,
I have worked a lot around sql,pl/sql but now I want to delve into Performance tuning from the sractch. I looked at Tom Kye website, and a couple of other sources..but everybody is giving a very scattered knowledge..of performance stuff.I want it from the very basics so I have a string foundation. To start with the database structure I have books on OCP track of DBA -I fundamentals. From where shud I start the performance tuning that starts from the basics.
Two weeks from now I will be actively on Performance tuning track. and expectations from me are of very basic nature. So help.
and at the same time..CAn anybody tell me what r the tools that r used for Performance tuning. I have heard of DB Profiler but don't know much abt it.
Regards
Avi
|
|
|
|
| Re: performance tuning novice [message #64949 is a reply to message #64943] |
Tue, 16 March 2004 10:29  |
ilver
Messages: 50
Registered: January 2004
|
Member |
|
|
Hi Avi,
Start to get familar with the Cost Based Optimizer, CBO. A lot of info is available on OTN.
Even it's a tuff one to get to know, I think it can help you understand why storage layout, database parameter setting and so forth are essential and actually interesting.
- Good luck on your journey ;-)
/ilver
|
|
|
|
| Re: performance tuning novice [message #64966 is a reply to message #64943] |
Thu, 18 March 2004 05:30 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
tools for Performance tuning :
i) sqlplus
ii) autotrace,sql_trace
iii) explain plan
iv) tkprof
v) v$ views
vi) statspack
vii) OS utilities like top
....
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
