| susk |
Posted: May 04, 2008 06:55:58 AM |
Total Post: 7
Joined: Jan, 2008
|
Hi friends
plz tell me what is main/imp topics to read in performance & tunning.
DBA point of view to atleast get primary knowledge . Frankly speaking to add up in my resume . I has done OCA in 9i & also hv knwlede of
DB Funda II
Thnx in Advance
|
|
|
 Murtuja |
| Posted: May 04, 2008 07:27:56 AM |  |
|
Total Post: 587
Joined: Jan, 2006
|
Hi,
You can prepare these topics in performance & tunning
Statspack and AWR
Explain Plan
TKPROF
Bind variables
DBMS_STATS Package
|
|
|
|
|
| Mohammed Taj |
| Posted: May 04, 2008 10:57:55 AM | |
|
Total Post: 634
Joined: Jul, 2007
|
Also visit below link
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm
|
|
|
|
|
| Gitesh |
| Posted: May 05, 2008 03:19:26 AM | |
|
Total Post: 157
Joined: May, 2005
|
Cost based optimizer mode,
High resource consuming queries,
explain plan,
Wait events,
resource/latch contentions
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
