Topic: Database Administration >> Data accessed from Undo Segment OR Buffer Cache
|
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.
|
|
|
|
| Title: Data accessed from Undo Segment OR Buffer Cache |
| Navi |
Posted: Aug 20, 2007 03:52:51 AM |
Total Post: 60
Joined: Jun, 2007
|
Hi,
I have some doubts related to Undo Segment please help me.
I have created a table called Toy and If a user named Raj has increased the toy price from 30$ to 50$ but not commited then the old image wil be stored in undo segment.
Question:-
1) Whether all the users except Raj will be accessing toy price from undo segment directly or that undo segment data is brought to Bufer Cache from Server Process so that all users can access that data from Buffer Cache?
2) Is there any way to know whether data is being accessed from Undo Segment or Buffer Cache?
Regards,
Naveen |
|
|
Ramesh Joyisa |
| Posted: Aug 21, 2007 12:53:21 AM | |
|
Total Post: 226
Joined: Aug, 2007
|
Untill commited, others will be acessing the old value only
|
|
|
|
|
| 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 | 704 |
| Jayanta Sur | 479 |
| positive fanatic | 416 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 231 |
| Ramesh Jois | 226 |
| Bishal Khetan | 196 |
|
|