| Kaiz |
Posted: Mar 19, 2008 10:21:14 AM |
Total Post: 104
Joined: Sep, 2007
|
Dear Friends...
1] Which oracle facility is use to access multiple databases of the same company at different location...
2] Where Checkpoint infromation are recorded.
3] Log Switch information is recorded in the which file....
4] When the table has to be large with large type all operation what type index/tablespace should be their.. like for low cardinatiy we use BITMAP....
Thanks & Regards.. |
|
|
 Gitesh |
| Posted: Mar 24, 2008 11:00:10 PM |  |
|
Total Post: 322
Joined: May, 2005
|
1] Which oracle facility is use to access multiple databases of the same company at different location... =>OEM
2] Where Checkpoint infromation are recorded.=> Control file
3] Log Switch information is recorded in the which file....=> Redolog file
4] When the table has to be large with large type all operation what type index/tablespace should be their.. like for low cardinatiy we use BITMAP....
Large table with heavy insert then=> BTREE reverse index
Large table with low insert and low cardinaty then=>BITMAP
|
|
|
|
|
| Chandrasekharan |
| Posted: May 24, 2008 12:30:18 PM | |
|
Total Post: 7
Joined: Mar, 2007
|
The answer to question (3) may be checked.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
