Hi,This article will discuss some PL/SQL performance tuning tips as well as make reference to a variety of good coding practices. There are several things you can do to get your PL/SQL code to run op...
The Schema Browser is an interface that allows us to work with various objects in the database. To learn about this interface, we first open Toad and connect to a database schema. For this example, w...
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...
