Topic: Database Administration >> pls anybody solve this problem
|
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: pls anybody solve this problem |
| raj |
Posted: Sep 07, 2007 04:31:04 AM |
Total Post: 15
Joined: Aug, 2007
|
hi
im rajesh im doing dba course i have doubt
1)if i create table in very first time
then it is going to database buffer cache or it will go directly to datafile if it is going ot datafile then which process is going to write that
2)if i want to reterive some data then
it is going fecth that datablocks and put that in database buffer cache or it is going to fecth only the information from datablocks
3)if database buffer cache size is 50m and database buffer cache is free nw im trying to fecth 100m data from at this time wat will happen |
|
|
 nick |
| Posted: Sep 11, 2007 11:25:37 AM |  |
|
Total Post: 30
Joined: Sep, 2007
|
1. As create table command is a DDL command, it will create the table and DBW process put the same into the datafile and will keep the same in database buffer cache.
2. while seraching the data, it will first the check the buffercache and if not found any relevent information, datablocks will be searched and information with be fetched into database buffer cache and will displayed on the screen.
3. in this case the you may see slow response time from the database and u will be provided the compelete fetched details; however, the buffercache retain the latest data with it.
|
|
|
|
|
| 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 | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
