A realm is created on HR schema objects : how to prohibit the access to HR objects to the accounts SYSTEM and SYS without using the Database Vault Administrator GUI tool (dva) ? 1. Realm creation and schema objects sel[...]
Information in this article applies to: Oracle Enterprise Manager 10g Release 1 (10.1) Oracle Enterprise Manager 10g Release 1 (10.2) So: Goal: Provide detailed instructions on how to remove and recreate the DB Control R[...]
Explain the Memory Structures System Global Area (SGA) – The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The[...]
When updated table, found error: ORA-08102: index key not found, obj# 116528, file 96, block 8795 (2) This problem I had resolved by rebuild indexes (ORA-08102 on index objects). But today I can not use this solution: [...]
I temporarily reduced db_recovery_file_dest_size to force the database to free reclaimable space from recovery_file_dest. This reduced disk usage of ASM_ORADATA217 by over 320GB. SYS>show parameter recovery NAME [...]
In 11g there is no segment allocated to the table until you insert, so the EXP utility fails to export empty tables. [oracle@dev-oranode-221 ~]$ sqlplus a/a SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 30 14:38:06 [...]
Oracle have provided many performance gathering and reporting tools over the years. Originally the UTLBSTAT/UTLESTAT scripts were used to monitor performance metrics. Oracle8i introduced the Statspack functionality which[...]
To manually upgrade an Oracle Instance from 10.2.0.3 to 10.2.0.4 is pretty much a strait forward routine if one already have a 10.2.0.4 home on the machine. Simply shutdown the instance and edit the /etc/oratab and the /[...]
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[...]
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)