Oracle Database & Business Intelligence Resources


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

		The log file parallel write Oracle metric indicates the process is waiting for blocks to be written to all online redo log members in one group. LGWR is typically the only process to see this wait event. It will wait until all blocks have been written to all members. Recommendation: NOLOGGING / UNRECOVERABLE operations may be possible for certain operations to reduce the overall rate of redo generation. Use of the /+ APPEND / SQL Hint should be used on all UPDATE/INSERT statements that have transient data. Note: • RAW devices can be faster file system files • RAID5 is not a good candidate for redo log members • Redo log members must be on high speed disks • Redo log members should be on disks with little/no IO activity from other sources (including low activity from other sources against the same disk controller)

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