| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Some Rahul's questions
Rahul,
Cache segment is a kind of segment of historical interest only. Steve Adams's site has the most definitive information (http://www.ixora.com.au/q+a/dd.htm). It doesn't seem that Winnie Liu's understanding or any intuitive guess is correct. I can't see any connection of it to cache buffer or operating system disk cache. That OCP question does not make any sense.
The only automatic transaction isolation level available before Oracle 7.3 is read committed. Serializable isolation mode is suitable for large databases and short transactions that update only a few rows.
Other people have answered other questions. Rahul, I appreciate you asking questions more suitable for this list such as some about Oracle internals. If you can't find answers to OCP questions, I suggest you install documentation on your local PC. From the %ORACLE_HOME%\doc directory, run a Find text including subdirectories (equivalent to find doc | xargs grep "some string" in UNIX). I guarantee you'll find all answers, unless the OCP question makes no sense.
Regards,
Yong Huang
yong321_at_yahoo.com
 |
 |