It is critical to know when to use the various types of code instrumentation features, where to place them, and, most importantly, what you are trying to achieve by instrumenting your code. Achievable goals usually target two groups of problems: Inefficient debugging Poor understanding of resource utilization The majority of existing IT system professionals spend […]
Read More
Knowing how to select appropriately between SQL-based and PL/SQL-based solutions is one of the most important skills in Oracle database development. Let’s look at two less common examples of using PL/SQL in actual systems development. The first example illustrates the notion of performance tuning by going outside of the regular solution patterns, while the second […]
Read More
Once you get started with RMAN and become familiar with its three main concepts and the tasks it can perform, you are ready to move onto more advanced concepts. The three concepts are: Backup Making another copy of data in an organized format on disk or tape Restore Getting that copy of data back into a location […]
Read More
Recovery Manager (RMAN) is the tool for backup and recovery of Oracle databases. RMAN is client software that connects to a target database and performs backups or recovery on it. RMAN always stores data about itself and its operations in the database control files as well as a special schema in another database. The best […]
Read More
The challenge of managing data in Oracle Database 12c is one that provides you with options. In this section, you will look at the methods that have been used in the many versions of the database to manage your information. Today’s version of the database provides you with options. The first that we will discuss […]
Read More
A large part of your job as a DBA will be to manage the objects that exist in a database. Let’s look at the objects that you need to concern yourself with and discuss the main management issues that you will have in each of these areas. Control Files It is critical to the database […]
Read More
(Read Part 1 of this article here.) Not everything stored in a database and schema is data. Oracle also manages source modules and supporting structures (such as sequences) that are used to populate new unique and primary key values when inserting data into the database. These objects belong to a schema and are stored in […]
Read More
In this two-part article, you take a look at the Oracle schema and storage infrastructure because these are a large part of what you, as an Oracle DBA, will be required to manage. Schemas An Oracle database can have many schemas contained in it. The schema is a logical structure that contains objects such as […]
Read More
In order to properly perform the role of database administrator, you will need to develop and implement solutions that cover all areas of this discipline. The amazing part of this job is that you may be asked to do many, or perhaps all, of the different aspects of your job on any given day. Your […]
Read More
You get a better sense of the power of the cursor in Oracle by combining it with a loop. The cursor FOR loop is the result of combining the select cursor with a FOR loop (we go into additional detail about this loop in the next section). This allows you to retrieve multiple rows from […]
Read More
How do you get data into your programs? Simple—select it from the database. This is the easiest way to use SQL in your program. Thus, inserting a line like the following will provide you with the capability to access data in the database: Let’s break down the statement and look at what it means to […]
Read More
VARCHAR2 is a variable-length alphanumeric data type. In PL/SQL, it may have a length up to 32,767 bytes. When you define the VARCHAR2 variable in the DECLARE section, remember to terminate the line with a semicolon (;). The following is the form of VARCHAR2 variable declarations: where MAX_LENGTH is a positive integer, as in You […]
Read More