Naming Conventions A naming convention is used when Oracle creates managed database datafiles. The following table shows the naming conventions fo the database datafiles. (Note that these may differ f...
A tablespace is the primary level of logical storage in an Oracle database. All "hard" database objects such as tables, indexes, sequences, and clusters reside in tablespaces. An Oracle database can ...
Improving database writer performance Free buffer or write complete waits can indicate that the database writer process (DBWR) process is experiencing a disk I/O bottleneck. The DBWR is the only pr...
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...
Disks for redo devices When a transaction is committed, the redo log entry in the redo log buffer must be written to disk. The characteristics of the redo log writes are very different from that of...
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 ...
Heavy Lifting Most of time, the workload on business analyst is pretty reasonable; however, sometimes a massive amount of requirements must be gathered in a short amount of time. I've helped many comp...
In SQL Server models you can define Extended Properties to various objects manually. In case you wish to add extended properties to multiple objects at once, download a small macro from here. Extract...
