Topic: Database Administration >> Help me plz
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| |
Posted: Feb 20, 2008 01:07:25 AM |
Total Post: 43
Joined: Sep, 2007
|
1.if my Database Size = 180GB and and oracle server Physical RAM=4GB then what should be the max size of SGA?
what is the best ans of this question?
2.if i have 180 GB size of datafile then how many REDOLOG file and Control file should keep.
but in system i keep only 3 control file and 3 RedoLog file?is it OK or sholud i increse these Control file and RedoLOg file?
plz ans me as soon as possible.
Thnks & Regrads
Dwaipayan Das |
|
|
 Mohammed Taj |
| Posted: Feb 20, 2008 02:35:55 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
1.if my Database Size = 180GB and and oracle server Physical RAM=4GB then what should be the max size of SGA?
what is the best ans of this question?
best answer: SGA size is not depands on DATABASE SIZE, sga depands on database activity , database type, database load.
2.if i have 180 GB size of datafile then how many REDOLOG file and Control file should keep.
best answer: oracle recommeneded mutliplex controlfile or redolog file.
and also recommeneded use "two controlfile" or "two redolog file" for any production database.
but in system i keep only 3 control file and 3 RedoLog file?is it OK or sholud i increse these Control file and RedoLOg file?
It is ok.
|
|
|
|
|
| |
| Posted: Feb 20, 2008 03:38:18 AM | |
|
Total Post: 43
Joined: Sep, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
