This article will discuss the CASE statement. PL/SQL has had the CASE statement since Oracle9 I believe (an eternity for most of today’s coders). I will also illustrate a little-known fact: The CASE...
In this article we are going to learn the three ways in which we can connect to our Oracle database using Toad for Oracle. First of all, in order to work with this tool, we need to have Oracle databa...
Introduction Block corruption is a common topic when we are dealing with any software that stores data. In Oracle Database there are several types of logical structures that are mapped to a physical f...
Database is a key asset for business applications. In the beginning, database technologies were used for storing and managing large amounts of data from single/multiple business applications to effic...
In this article, we will learn how to use the Toad for Oracle Editor Window. This tool provides us with a simple editor for working with SQL queries, PL/SQL code and more! This editor is the main int...
If you find that SYSAUX is growing and its size is too big, besides figuring out why this has happened (bug, some purge job disabled, or some structure problems in objects), you need to find the objec...
Introduction Most of the time I write how-to articles or I am introducing a new feature of Oracle Database. Those articles contain new information that’s good to know and help people fix issues or to ...
In the first 11g release, it is still possible to logon as sysdba as well assysasm. This will definitely be changed with the next coming release, 11gR2. At present, when Oracle 11g is installed a ques...
I need to run capacity planning report in my project. Requirements: Predict db growth for 3 months, 6 months and one year. Display message, if the available free space in each tablespace is less tha...
Exadata Storage expansion Most of us knew the capabilities that Exadata Database Machine delivers. Its known fact that Exadata comes in different fixed rack size capacity: 1/8 rack (2 db nodes, 3 cel...
Business continuity (Disaster Recovery) has become a very critical factor for every business, especially in the financial sectors. Most of the banks are tending to have their regular DR test to meet t...
Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. Notice that all the ASM processes begin with asm, whereas ...
