| Soumya |
Posted: Oct 09, 2007 09:29:45 AM |
Total Post: 56
Joined: Mar, 2006
|
Hi,
Can someone please give me few good oracle dba interview questions ?
It will be greate if some performance & tuning questions are also there.
Thanx
|
|
|
 Mohammed Taj |
| Posted: Oct 09, 2007 01:01:43 PM |  |
|
Total Post: 694
Joined: Jul, 2007
|
Hi,
Performance tunning.
1. How tune you sga size properly according your database workload.
2. how to generate statspack report and how to analyze it.
3. If any user complain sql statment ( report) taking too much time to show result. then where you start to findout bottleneck.
4. why CPU used % show 100% most of time.
5. how to use TKPROF and analyze trace output file.
there are some common question comes in mind when we are talking about performance.
|
|
|
|
|
| parthokonar |
| Posted: Oct 11, 2007 10:48:04 AM | |
|
Total Post: 27
Joined: Sep, 2007
|
You can get lot many question on dba on the google. some good links are--
1. http://www.databasejournal.com/features/oracle/article.php/3085171
2. http://www.databaseanswers.org/dba_interview_questions.htm
Thanks
Partho Konar
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
