The data in the databases always grows, and as the backup is a copy of the data, it grows too. As the size of the backup grows, it takes more space on the disk and it takes more time to back up. When the database becomes large, you still want to back it up faster […]
Read More
SQL Server Resource Governor concepts have been in existence since the SQL Server 2008 versions. With every version, there have been new additions, and it has steadily gotten better and better. It started with CPU throttling and memory throttling; now, with SQL Server 2014, they introduced IO throttling. There are three important concepts related to Resource Governor: Resource […]
Read More
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