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 [...]
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)