Data Segment, Index Segment, Rollback Segment and Temporary Segment.
Latest Answer: Data, index , rollback, undo,cluster ...
Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored
Latest Answer: it's you table, index and else ...
Each Index has an Index segment that stores all of its data.
Latest Answer: It's an oracle object as other object like table. It stores index key + rowid for that key. So when you scan index it finds respective rowid and fetch data from that rowid. and it's faster ...
A Database contains one or more Rollback Segments to temporarily store "undo" information.
Latest Answer: It stores your uncommited temporart data. ex. If you do any insert/update/delete and you won't commit it is written in rollback segment. ...
View page << Previous 4 5 6 7 [8]
Go Top
