Ask TEM Dba

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

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

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

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

The GENERATE_STMT procedure of this UTILITY package needs four parameters i.e. TABLE NAME, WHERE CLAUSE, PATH WHERE Developer WANT FILE TO BE GENERATED and FILE NAME. WHERE CLAUSE value must be passed in the form of q[...]

create or replace procedure getXML(newContext_qry varchar2, rowSettag varchar2, rowTag varchar2,filename varchar2)  is -- Input query string -- Input rowsetTag , the root tag -- Input row level tag -- Inp[...]