Oracle Database & Business Intelligence Resources


Welcome to OracleGiants.com!	Oracle 10g DBA & Business Intelligence Resources.

		If you have a home-grown application that does not allow traceability from the application to the database this tip is for you. If your application uses a "gateway/proxy" user to talk to the database the DBA is limited in his/her ability to track back a high-impact SQL to the user or module executing it. Recommendation: Populate additional information into DBA views to allow better traceability of queries in the database back to the user/module that is executing them. DBMS_APPLICATION_INFO provides a way of populating the V$SESSION and V$SQLAREA views with context information about application users. Oracle's eBusiness Suite uses this to allow DBAs to identify what module a user is in, what the current transaction is and what the context is. By using DBMS_APPLICATION_INFO the DBA will have better visibility to queries that are happening in the database and how these relate to application functionality.

Use Xattr CloudFiler™ to dedup, encrypt and move your RMAN backups to the cloud.
Recent Posts _TRACE_FILES_PUBLIC db file sequential read _kks_use_mutex_pin Basics of PGA_AGGREGATE_TARGET Slow Access on Oracle Tablespaces High Cluster Wait events Pin Objects in Shared Pool db_keep_cache_size db_cache_size FilesystemIO_options Initialization Parameter Oracle Desupport for 10g AS (9.0.4) Insufficient Swap Space is configured on Oracle Application Server Oracle Forms Services Web Runtime Pooling 64-bit Oracle Database Oracle Application Server Backup and Recovery Tool FRM-93000 Error Transparent Application Failover Oracle Services & Resource Manager Plans db file parallel write High Av Rd(ms) OPTIMIZER_MODE OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_INDEX_CACHING Oracle partition table basics latch free latch cache buffers chains Log file switch (checkpoint incomplete) How to enable SQLNET.ORA tracing ORA-00060: deadlock detected while waiting for resource Global Temporary Tables Tip Oracle Traceability optimizer_mode read by other session log file parallel write Oracle's Forms and Reports Roadmap Excessive hard parsing Favor Indexes over Full Table Scans SQL*Net message from client table fetch continued row table fetch continued row (Part 2) enq: TX - row lock contention Weather Portlet for Oracle Portal AD to OID Integration Case Insensitive Sorts 10g Recycle Bin Issue Oracle 10g Portal Business Intelligence: Develop a strategy first Oracle 10g DBA: How I became an Oracle 10g DBA Oracle 10g DBA: Day in the life of Oracle 10g Application Server: High Level Overview of Install Oracle 10g Application Server: Multiple Home Installation on SLES Linux Oracle 10g DBA: Oracle 10g & Itanium Business Intelligence Understanding the Power that Comes From Your Database Mapping Software Improves Data Visualization Oracle Network Monitor An Open Source Search Engine TNS-12564 ORA-31696 Database Administrator (DBA) Code of Ethics

OptionalRegion1
This site recommends Burleson Consulting for DBA Support & Consulting.
We are currently paying for accepted Oracle 10g DBA & Business Intelligence articles, scripts, tips & tricks. Send yours to the editor and we will review within three weeks. Learn more Editorial submissions & questions: editor@oraclegiants.com
This site is moderated by an:

Classic Car Online - The #1 spot for classic and muscle car enthusiats

2010 OracleGiants.com