Object tables are used to implement an object-relational model in Oracle. A single object table will create many physical database…

Oracle provides two types of temporary tables: global and private. Either type of temporary table can be useful in an…

Setting PCTFREE is sometimes overlooked. On the one hand, you need to use it to avoid too many rows from…

Here is where the “virtually a table for every row” comes into play. In the SELECT predicate shown earlier, it…

We have already seen some of the storage of the nested table structure. In this section, we’ll take an in-depth…

The gathering and use of global temporary table statistics is listed next: •\ By default, session-level statistics are generated when…

One of the drawbacks of a temporary table in any database is the fact that the optimizer has no real…

I do not use nested tables as a permanent storage mechanism myself, for the following reasons: •\ The unnecessary storage…

Nested tables are part of the object-relational extensions to Oracle. A nested table, one of the two collection types in…

In general, the PCTFREE parameter tells Oracle how much space should be reserved on a block for future updates. By…