Oracle Certification

By -Porshica Hibbler

Table Partitioning Schemes-Partitioning

Posted on 20/06/2024
Posted in Certifications of Oracle, Data Warehouse Systems, Extended Datatypes, Internal LOBs, INTERVAL DAY TO SECOND, Reduced Administrative Burden

There are currently nine methods by which you can partition tables in Oracle: •\ Range partitioning: You may specify ranges of data that should be stored together. For example, everything that has a timestamp within the month of Jan-2014 will be stored in partition 1, everything with a timestamp within Feb-2014 in partition 2, and

By -Porshica Hibbler

Data Warehouse Systems-Partitioning

Posted on 05/05/2024
Posted in Certifications of Oracle, Data Warehouse Systems

In a data warehouse/decision support system, partitioning is not only a great administrative tool but something that will speed up processing. For example, you may have a large table on which you need to perform an ad hoc query. You always do the ad hoc query by sales quarter, as each sales quarter contains hundreds

By -Porshica Hibbler

Enhanced Statement Performance-Partitioning

Posted on 21/04/2024
Posted in Certifications of Oracle, Extended Datatypes

The third general (potential) benefit of partitioning is in the area of enhanced statement (SELECT, INSERT, UPDATE, DELETE, MERGE) performance. We’ll take a look at two classes of statements—those that modify information and those that just read information—and discuss what benefits we might expect from partitioning in each case. Parallel DML Statements that modify data

By -Porshica Hibbler

Reduced Administrative Burden-Partitioning-2

Posted on 07/03/2024
Posted in Certifications of Oracle, Internal LOBs

This fails—we need sufficient free space in tablespace BIG1 to hold an entire copy of BIG_TABLE1 at the same time as the old copy is there—in short, we need about two times the storage for a short period (maybe more, maybe less—it depends on the resulting size of the rebuilt table). We now attempt the

By -Porshica Hibbler

Reduced Administrative Burden-Partitioning-1

Posted on 05/03/2024
Posted in Certifications of Oracle, INTERVAL DAY TO SECOND

The administrative burden relief is derived from the fact that performing operations on small objects is inherently easier, faster, and less resource intensive than performing the same operation on a large object. For example, say you have a 10GB index in your database. If you need to rebuild this index and it is not partitioned,

By -Porshica Hibbler

Partitioning Overview-Partitioning

Posted on 02/02/2024
Posted in Certifications of Oracle, Reduced Administrative Burden

Partitioning facilitates the management of very large tables and indexes using divide and conquer logic. Partitioning introduces the concept of a partition key that is used to segregate data based on a certain range value, a list of specific values, or the value of a hash function. If I were to put the benefits of

By -Porshica Hibbler

JSON Type-Datatypes

Posted on 29/01/2024
Posted in Certifications of Oracle, Data Warehouse Systems, Extended Datatypes

New in 21c, Oracle introduces the JSON datatype. This datatype allows you to store JSON data natively in binary format in the database. It is an optimized binary storage that uses the OSON format. The OSON format is Oracle’s optimized binary JSON format. Using this format, query performance is greatly enhanced because textual JSON data

By -Porshica Hibbler

ROWID/UROWID Types-Datatypes

Posted on 20/12/2023
Posted in Certifications of Oracle, Data Warehouse Systems, Internal LOBs

The last datatypes to discuss are the ROWID and UROWID types. A ROWID is the address of a row in a table (remember from Chapter 10 that it takes a ROWID plus a table name to uniquely identify a row in a database). Sufficient information is encoded in the ROWID to locate the row on

By -Porshica Hibbler

SecureFiles RETENTION-Datatypes

Posted on 01/11/2023
Posted in Certifications of Oracle, Data Warehouse Systems, INTERVAL DAY TO SECOND

SecureFiles use RETENTION to control read consistency (just like BasicFiles). In the CREATE TABLE output of DBMS_METADATA for the SecureFiles LOB, there is no RETENTION clause. This is because the default RETENTION is set to AUTO, which instructs Oracle to retain undo long enough for read-consistent purposes. If you want to alter the default RETENTION

By -Porshica Hibbler

CHUNK Clause-Datatypes

Posted on 08/10/2023
Posted in Certifications of Oracle, Data Warehouse Systems, Reduced Administrative Burden

LOBs are stored in chunks; the index that points to the LOB data points to individual chunks of data. Chunks are logically contiguous sets of blocks and are the smallest unit of allocation for LOBs, whereas normally a block is the smallest unit of allocation.The CHUNK size must be an integer multiple of your Oracle