How to make a native connection to an Oracle database using Toad Data Point
How to make a native connection to an Oracle database using Toad Data Point
Learn how to make a native connection to an Oracle database using Toad Data Point....
100% Correct Cost Estimation Leads to the Best SQL Optimization – 10 Common Misconceptions in SQL Tuning #10
100% Correct Cost Estimation Leads to the Best SQL Optimization – 10 Common Misconceptions in SQL Tuning #10
This blog is the finale in this series about common misconceptions surrounding SQL tuning. I selected this topic as my last one because it is a very common misconception in a DBA or developers mind. I...
Shrinking Database Maintenance Windows With SQL Optimizer
Shrinking Database Maintenance Windows With SQL Optimizer
Many databases have, as part of their daily workload, batch updates or maintenance processes that run during off-hours. For example, a database that supports an accounts receivable function may have a...
Tips and Tricks – Spotlight Connection Sharing
Tips and Tricks – Spotlight Connection Sharing
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 ...
Tips and Tricks – Spotlight on Oracle Calibration
Tips and Tricks – Spotlight on Oracle Calibration
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...
Tips and Tricks – Spotlight Display Modes
Tips and Tricks – Spotlight Display Modes
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...
Hot and Cold Backups – Overview
Hot and Cold Backups – Overview
Normal system backups, referred to as either Hot or Cold backups, are used to protect from media failure. A Cold backup, that is, one done with the database in a shutdown state, provides a complete co...
Oracle RMAN – Using the Flash Recovery Area
Oracle RMAN – Using the Flash Recovery Area
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...
Oracle RMAN – Duplexing Archive Logs
Oracle RMAN – Duplexing Archive Logs
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...
Oracle Configuring and Managing ASM Disks
Oracle Configuring and Managing ASM Disks
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 System Architecture Processes
Oracle System Architecture Processes
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...
Oracle storage_clause Syntax
Oracle storage_clause Syntax
Oracle V11.1 Description v────────────────────────────┐ >──STORAGE─(──┬─INIITAL──size_clause─────┬┴─)──> ├─NEXT──size_clause────────┤ ├─MINEXTENTS──integer──────┤ ...
- Go to the previous page
- 1
- …
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- …
- 48
- Go to the next page