For most people troubleshooting SQL query performance problems is a necessity rather than a preference. Very often they are using a trial and error strategy to overcome those frustrating situations. U...
Expert Advice Whose advice are you listening to when building your requirements? Sure, your end users think they know what they want, but are they the right people to assist you in designing a solutio...
This article explains how to create service, managing services and close view of service failover to the preferred databases and various other options related to services, The GDS introduction and the...
SAP HANA stands for SAP’s High-Performance Analytic Appliance(HANA); it enables the processing of massive quantities of data in the main memory of the server in real time. SAP is one of the largest...
This article explains how to configure Data Guard between RAC primary and standby alone (Oracle restart) Standby database with easy and all advanced methods to achieve Oracle maximum availability arch...
Overview In typical data warehousing environment existence of huge partitioned tables is very common, gathering statistics on such tables is challenging tasks. For partitioned tables there are two typ...
Why End Users Don't Like Their Solution One of the biggest problems facing your job as a business analyst is unhappy end users. Sometimes it feels like you're more of a therapist than a business analy...
Oracle 12c has introduced the multi-tenant architecture for Oracle database, where a single container database (CDB$ROOT) can have multiple pluggable databases (PDBs). This new architecture is introdu...
I was on the phone with a Toad Data Point customer last week and she said something like (paraphrased) this is the only solution that offered this key benefit and I have tried a lot of products out th...
Introduction We've already seen the introduction, architecture of GDS in a previous article; this article explains how to install Global service managers and deploying GDS to the Data Guard and go thr...
Prior to Oracle 12c we are familiar with the local data services which offers the connectivity to the desired database and managed workload across instances and route the connection to the standby dat...
This video on object alters with recovery script generation is part twelve of an overview of key DBA features in Toad for DB2 z/OS....
