 Related Questions In Circumstances, all of the data for a row in a table may not be able to fit in the same data block. When this occurs , the data for the row is stored in a chain of data block (one or more) reserved for Latest Answer : If a row is too large to fit into a single database block row chaining happens. For example, if you use a 4KB blocksize for your database, and you need to insert a row of 8KB into it, Oracle will use 3 blocks and store the row in pieces. Some conditions ... A segment is a set of extents allocated for a certain logical structure. Latest Answer : A segment is a set of extents that contains all the data for a specific logical storage structure within a tablespace. For example, for each table, Oracle allocates one or more extents to form that table's data segment; for each index, Oracle allocates ... 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. ... Rollback Segments are used :To generate read-consistent database information during database recovery to rollback uncommitted transactions for users. Latest Answer : Rollback Segment Stores Undo Information and are used for the following purposes.1. To undo the previous command2. For read consistency and3. For crash recovery. ... Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the Latest Answer : temporary segments are basically used for sort operations in oracle,,when the user tries to execute the query through order by clause. so system needs an space for an sort operation, and system will use temporary segments for this query. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
