This video provides an overview of basic features and user interface in Spotlight on Oracle. You can download a free limited version of Spotlight on Oracle...
One of the challenges that a DBA team encounters is keeping all of the DBAs up-to-date on connection changes. When a new database is created or an existing database has been changed, the DBAs need to ...
In my last couple of blogs for Spotlight on Oracle I have highlighted a couple of features that may not be well known but are very useful. I would like to continue that theme here with another great s...
In this blog, I am going to talk about one of the features of Spotlight on Oracle that may not be very well known or understood – Calibration. One of the reasons that Calibration may not be well known...
One of the great things about Spotlight is that it's easy to take a quick look at the screen and know immediately if there is a problem that needs your attention. I have had a number of Spotlight user...
The flash recovery area, which allows you to centralize storage of all recovery-related files, is new in Oracle 10g. The flash recovery area is an area of disk that is defined for use for recovery-rel...
The log_archive_duplex_dest parameter allows you to define not one but two archived redo log storage locations. You can define it as a can or must succeed operation by setting the log_archive_min_succ...
Adding an ASM Disk Group ASM disk groups are the foundation of ASM. It is where your data will be stored. ASM disk groups can be allocated to raw disk, cooked disk. To add a ASM disk group you first...
Oracle V11.1 Description v────────────────────────────┐ >──STORAGE─(──┬─INIITAL──size_clause─────┬┴─)──> ├─NEXT──size_clause────────┤ ├─MINEXTENTS──integer──────┤ ...
DBWn – Database Writer Note that Oracle changed the naming format of the DBWR process to DBWn as of Oracle8, where n can be a number from 0 through 9. If you use multiple DB writer processes, you shou...
As their name implies, locally managed tablespaces do not manage their free and used extents by the data dictionary but are instead managed at the local tablespace level. This local management is acco...
Shared pool latch contention can occur when the shared pool is sized too large to be effectively managed. Starting with Oracle version 8.1.6, Oracle implemented improved shared pool management archite...
