Part I) First of all you must configure the following parameters related to database archiving: You have two main options for define archive log destinations: 1) Flash Recovery Area (recommended) In this part, first of[...]
In Oracle 9i and up, you can generate CPU cost information during a workload with a procedure of the dbms_stats package. The dbms_stats.gather_system_stats packaged procedure can be used during a certain interval to meas[...]
You are trying to delete a record, but one or more child records were found, preventing the delete. A (parent / child) relationship between 2 tables are defined by a foreign key constraint. eg: CREATE TABLE PARENT ( ID [...]
How to Safely Remove a Data Guard Broker Configuration Doc ID: 261336.1 Type: REFERENCE Modified Date: 20-MAY-2009 Status: PUBLISHED PURPOSE ——- How to safely remove a Data Guard Broker conf[...]
Imagine, there are a few tables in your schema and you want to find a specific value in all columns within these tables. Ideally, there would be an sql function like select * from * where any(column) = 'value'; Unfort[...]
This page is an introduction to my blog, which is dedicated to Oracle data base performance management.
I found over the years sharing knowledge to be an invaluable tool in assisting me in my various consulting assignments. Spending most of my time in capacity planning, tuning, application sizing and performance management, I thought it might be [...]
dba Ask TEM Dba
(0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5)