Fragmentation in a tablespace is thought to be a performance killer. This has been proven to be a myth. Fragmentation by itself does not cause performance problems in a multi-user Oracle database. Wha...
This topic documents the initialization parameters used to configure the multi-threaded server (MTS). Only the currently recommended parameters are described here. Parameters that were made obsolete w...
The DBMS_JOB package is actually an API into an Oracle subsystem known as the job queue. The Oracle job queue allows for the scheduling and execution of PL/SQL routines (jobs) at predefined times and/...
Oracle V11.1 Description Example >>──CREATE─┬──────────────────┬─TABLE──schema.──table──┬─relational_table─┬─> └─GLOBAL TEMPORARY─┘ ├─object_table─────┤ ...
There are two possible states for archive logging, either off or on. If archive logging is on there are two possible states, either automatic or manual. These are controlled via the initialization par...
We know there are 500+ features introduced with Oracle 12c and Multitenant, Indeed there are few new features with RMAN and in this article we are going to see how the 12c RMAN new features are going ...
A frequent question that I have received from many DBAs is: my undo tablespace is almost full, how can I be sure that the space will be reused? Well, First you have to know that there are two kind of...
In this article I will show you how undo retention time is set when we have an Undo tablespace with autoextend enabled and also disabled. I will give you rules in order to remember this easily: Rule-...
If you want to find the minimum salary among all employees, you may issue a SQL statement like this: select min(emp_salary) from employee Plan 3 SELECT STATEMENT 2 SORT AGGREGATE ...
In this article series, we are discussing Oracle Real User Experience Insight (RUEI). Part IV was here. This is the fifth and final article in this series. We were talking about the RUEI Application ...
This article is focused on Monitoring and Troubleshooting of Data Guard configuration using the GUI method i.e. Enterprise manager 12c(cloud control), Here we will go through with Data Guard Administr...
In this article series, we are discussing Oracle Real User Experience Insight. Part III was here. This is the fourth article in the series. In the previous article, we had drilled down to Enterpris...
