-
How oracle finds the locatoin of data ?
hi,
Whenever i issue a query like
sql>select * from emp where empno=25;
How does oracle go about in getting the locations
of the datafile, and segment number in order to retrieve the data.
Which all dictionary table does Oracle need to query
to reach to the table data.
In this scenario what are the roles of the dictionary tables
obj$, fet$, tab$ and seg$.
In which order does oracle query these tables to reach the
exact location of the data ?
regards
sonia
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|