Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

   
 

Your Source for
Oracle News

 

Upcoming News
These are works in progress and may not be released to the public






=====

   Conducting a Database Administrator Background Check - Oracle News by Don Burleson

 

  FUN NEWS - Why America Has No Field Marshalls- Oracle News by Don Burleson

======

 


Place link below this line 

Display Oracle background processes in Windows  May 12, 2010

AMM vs. manual RAM allocation tips  May 11, 2010

FUN NEWS - The Original Space Cadets  May 7, 2010

Index Leaf Block contention Tuning - May 5, 2010

Disaster Recovery using RMAN-May 4, 2010


 Tricks for super-fast batch updates with CTAS- May 3, 2010

Rewriting SQL for faster performance - March 29, 2010

Learn Oracle at Sea: Join the 2010 BC Oracle Training Cruise  

Information Technology (IT) speaker - September 3, 2009

Information Technology (IT) professional management organizations - September 3, 2009

Hardware advances and changes in Oracle technology - September 3, 2009

tnsnames.ora tips - August 30, 2009

Oracle business intelligence Tips - August 29, 2009

How to save your job from an Oracle layoff - August 29, 2009

Hardware advances and changes in Oracle technology - August 29, 2009

Oracle Utilities Tips - August 29, 2009

Hypercharging SQL by restructuring complex queries using intermediate results - August 29, 2009

Benchmark showing the difference in performance of complex SQL subqueries rewritten with intermediate tables - August 29, 2009

Oracle 11g changes to "order by" and "group by" performance - August 18, 2009

Oracle database products - August 16, 2009

Best practices for security policies for accessing production data - August 16, 2009

The force_matching_signature column - August 15, 2009

remote_os_authent tips - August 15, 2009

Best practices for scaling Oracle VLDB systems - August 14, 2009

Oracle wallet manager tips - August 13, 2009

Inside Oracle 2020 - August 13, 2009

Troubleshooting a hung Oracle database - August 12, 2009

dbms_stats.set_table_prefs tips - August 12, 2009

Equivalent of UNIX mtime for Windows - August 12, 2009

Oracle RAC SGA sizing - August 11, 2009

Oracle: lower table high water mark tips - August 11, 2009

Scheduling oracle index rebuilding - August 9, 2009

v$session_longops tips - August 4, 2009

ORA-16401: archivelog rejected by RFS tips - August 4, 2009

Oracle disaster recovery details - August 3, 2009

Oracle: Counting the number of table changes - August 3, 2009

Costs of SQL Server vs. Oracle - August 3, 2009

Updating tables with Oracle 11g compression - July 31, 2009

Swapping SQL Profiles - July 30, 2009

Inserts become slow as table grows - July 29, 2009

Oracle row_number analytic function - July 28, 2009

Oracle index hint syntax - July 28, 2009

Steps for Oracle performance tuning - July 28, 2009

Oracle redo log corruption - July 27, 2009

Oracle SQL Tuning tricks - July 26, 2009

Oracle hikes tuning pack prices - July 26, 2009

Oracle Windows listener error: System error 3 has occurred - July 25, 2009

Reuters says Oracle hacking will become easier - July 24, 2009

Tuning SQL with "rownum=1" - July 24, 2009

Oracle cross platform replication - July 24, 2009

Escaping special characters in PL/SQL - July 24, 2009

Oracle documentation best practices - July 22, 2009

Rewrite exists subquery using rank and partition analytics - July 21, 2009

Oracle patch set update (PSU) tips - July 20, 2009

SQL tuning and execution statistics - July 19, 2009

CNN reports DBA jobs in high demand in 2010 - July 18, 2009

ORA-04031: unable to allocate bytes of shared memory tips - July 17, 2009

Statistics and function-based indexes - July 12, 2009

DBA's arrested for stealing millions - July 10, 2009

Oracle derived parameters - July 9, 2009

Oracle processes parameter tips - July 9, 2009

SQL GROUP BY for time periods - July 9, 2009

Oracle on Google Chrome OS tips - July 8, 2009

dbms_space.object_growth_trend tips - July 8, 2009

Formatting numbers in Oracle SQL - July 8, 2009

Formatting numbers in Oracle SQL - July 8, 2009

Windows PowerShell for Oracle - July 7, 2009

The effect of optimizer_mode on SQL execution plans - July 6, 2009

Oracle alter system check datafile tips - July 6, 2009

Rewriting SQL for faster performance - July 5, 2009

Oracle SQL execution plan is incorrect - July 5, 2009

The NetApp Snap Manager for Oracle - July 4, 2009

Oracle SQL query chooses wrong index - July 3, 2009

 Tuning Oracle dictionary SQL - July 2, 2009

Tuning Oracle SQL that has views - July 2, 2009

oracle optimizer costing equations - July 2, 2009

Tablespace size & initial extent size - June 18, 2009

SQL coalesce function tips - June 17, 2009

utl_file umask permission tips - June 15, 2009

Oracle Advanced Queuing tips - June 15, 2009

db_block_checking tips - June 15, 2009

Sequence of steps in oracle SQL explain plan - June 15, 2009

Hide Oracle password for SQL*Plus - June 12, 2009

Location of Oracle shutdown script - June 12, 2009

Oracle software license compliance consulting support

Debugging dbms_scheduler jobs - June 9, 2009

Oracle: Tracking failed logon attempts - June 9, 2009

See Oracle SQL execution details over time - June 8, 2009

Viewing SQL execution details over time - June 8, 2009

Oracle SR tips- June 3, 2009 -

Forcing partition pruning on a distributed query using a db-link - June 7, 2009

Default database writer processes tips - June 7, 2009

Performance of multiple schemas in a single instance - June 6, 2009

ORA-01450: maximum key length (string) exceeded tips - June 6, 2009

Advanced Oracle troubleshooting - June 5, 2009

Oracle Exadata benchmark uses bizarre initialization parameters - June 5, 2009

Understanding direct path read waits - June 5, 2009

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view tips - June 4, 2009

Mapping Oracle data file extents to segments - June 3, 2009

Why is Oracle SQL query not using an index? - June 3, 2009

Convert SQL Server T-SQL to Oracle PL/SQL - June 3, 2009

database worst practices -  June 2, 2009

alter system start rolling upgrade tips - June 2, 2009

Low downtime Oracle upgrade secrets - June 2, 2009

Tracking Oracle blocking sessions - June 2, 2009

Don Burleson as a cult hero! - June 2, 2009

The role of the OS oracle user - June 2, 2009

dba_scheduler_job_log tips - June 1, 2009

Using v$sys_optimizer_env and v$sess_optimizer_env - June 1, 2009

Using dbms_shared_pool.purge to remove a single task from the library cache - June 1, 2009

Visualizing Oracle performance data to spot trend changes - June 1, 2009

Oracle to desupport RAW data files - May 30, 2009

Oracle ACE warns about optimizer bug - May 29, 2009

FRM-40510: ORACLE error: unable to DELETE record. - May 29, 2009

Oracle index performance - May 29, 2009

Tracking & auditing changes to your init.ora parameters - May 29, 2009

Create your own multidimensional interface for Oracle - May 29, 2009

Oracle Windows DOS script to detect and remove all trace files that are over 30 days old - May 28, 2009

Managing multiple Oracle instances -  May 27, 2009

Microsoft issues bizarre Oracle workaround - May 26, 2009

v$sysaux_occupants Tips - May 26, 2009

dbms_space.create_index_cost tips - May 26, 2009

Find Oracle blocking sessions - May 26, 2009

Oracle RAC blocking sessions - May 26, 2009

Oracle colored command line backgrounds - May 20, 2009

Oracle indexes tips - May 20, 2009

Automatic Database Diagnostic Monitor (ADDM) in Oracle Database 10g - May 19, 2009

Oracle redo log sizing advisor - May 19, 2009

ORA-39802: ADT not allowed in direct path mode tips - May 18, 2009

Real application testing tips - May 17, 2009

Oracle SR tips - May 17, 2009

dbms_stats.gather_table_stats tips - May 17, 2009

v$sql_feature tips - May 15, 2009

Oracle acquires Virtual Iron - May 14, 2009

Display all Oracle schemas - May 13, 2009

enq: TX - allocate ITL entry tips - May 13, 2009

Oracle Windows script to check alert log messages - May 13, 2009

Oracle OFA for Windows tips - May 13, 2009

Monitor index usage - May 12, 2009

ORA-24550: unhandled signal received tips - May 12, 2009

Oracle flashback database tips - May 11, 2009

ORA-14074 tips - May 11, 2009

ORA-16009: remote archive log destination must be a STANDBY database tips - May 10, 2009

Oracle recover standby database until cancel tips - May 10, 2009

Oracle Windows TNS error: No Listener found - May 9, 2009

What are Oracle statistics - May 9, 2009

How to create a duplicate database in Oracle - May 9, 2009

Script to query multiple Oracle servers & instances - May 9, 2009

Oracle standby database tips - May 8, 2009

Oracle recover standby database until cancel tips - May 8, 2009

Oracle interval partitioning tips - April 31, 2009

Difference between chained and migrated rows - April 31, 2009

Advanced scheduling of STATSPACK snapshots - April 30, 2009

_cursor_features_enabled tips - April 30, 2009

Monitor Oracle I/O with PL/SQL and gv$sysstat - April 29, 2009

Oracle nologging tips - April 28, 2009

Oracle row count for all tables in schema - April 28, 2009

Grant access to Oracle trace and dump files - April 28, 2009

Learning Oracle in plain English - April 27, 2009

Oracle transportable database tips - April 27, 2009

How to extract a jpg image from Oracle - April 27, 2009

Oracle system and session _fix_control tips - April 26, 2009

Oracle driving table tips - April 26, 2009

Oracle timed_statistics tips - April 26, 2009

The importance of communications skills for the Oracle DBA - April 25, 2009

Oracle monitoring with the vmstat wa column - April 25, 2009

Oracle Database: SQL Certified Expert - April 25, 2009

ORA-04045: errors during recompilation/revalidation - April 24, 2009

Oracle on Nehalem - April 22, 2009

String parsing in Oracle - April 22, 2009

Invoking FTP from PL/SQL - April 22, 2009

Using dba_hist_log - April 21, 2009

Oracle acquires Sun Microsystems for $7.4b - April 20, 2009

Oracle vs. DB2 UDB - April 20, 2009

Plotting Oracle CPU Utilization percentage - April 20, 2009

PL/SQL script to shut down Oracle Windows server - April 20, 2009

Avoiding bad Oracle advice on the web - April 20, 2009

_ash_size and ASH data buffer size - April 19, 2009

Buffer cache size factors into Oracle optimizer execution plans - April 19, 2009

Display Oracle session volume per minute - April 18, 2009

Oracle Text: Map Linux to Windows path - April 16, 2009

DBA fer rednecks - April 14, 2009 - WIP DO NOT SCHEDULE

The best Oracle blogs - April 13, 2009

2008 Oracle DBA salary survey - April 12, 2009

Fast data transfer between instances - April 11, 2009

Fix error ORA-39097: Data Pump job encountered unexpected error - April 11, 2009

Inside Oracle 11g fully automated SQL tuning - April 9, 2009

Days to previous day of the week in SQL - April 7, 2009

Display OS variables with dbms_system.get_env - April 6, 2009

Oracle 11g hidden undocumented parameters - April 5, 2009

Using v$sql_hint - April 5, 2009

Placing a date in a data pump export file name - April 1, 2009

Find historical SQL by date - March 27, 2009

Oracle memory leak troubleshooting - March 27, 2009

Alert log x$dbgalertext tips - March 26, 2009

What's the value of a professional DBA? - March 25, 2009

How to Display Oracle CLOB columns - March 6, 2009

Execute a shell script from a PL/SQL procedure - March 4, 2009

How to get more out of Oracle support -  March 2, 2009

Over-allocation of Oracle resources -  March 2, 2009 WIP - DO NOT SCHEDULE

Restore a single table in RMAN -  March 1, 2009

Oracle SQL execution steps -  February 25, 2009

Remove spaces and special characters from Linux file names - February 24, 2009

How to extract a timestamp date from a LOB - February 24, 2009

Information Systems college major tips -  February 23, 2009

Find RAC waiting sessions - February 23, 2009

OEM Oracle Grid Control Requires Extra Cost Packs - February 9, 2009

t_rman_insufficient_privileges.htm - February 7, 2009

Fix Oracle Hanging - February 4, 2009

Oracle Windows XP Tips - February 3, 2009

Oracle versioning tips - February 1, 2009

Disabling Automatic Memory Management and execution plan changes - January 31, 2009

parallel_adaptive_multi_user tips - January 31, 2009

Find an Oracle table column size -  January 22, 2009

What SQL is included in AWR tables? - January 22, 2009

Remove Oracle Windows registry -  January 22, 2009

Upgrade Oracle 9i to Oracle 11g - January 21, 2009

Upgrade Oracle 8i to Oracle 10g - January 21, 2009

Oracle SQL Plan Regression -  January 20, 2009

Oracle RAM Disk performance Tips - January 19, 2009

Oracle patch tracking & patch management - January 16, 2009

Oracle log switch SQL reports - January 15, 2009

Differences between Data Pump impdp and import utility -  January 3, 2009

Oracle data pump impdp import modes -  January 3, 2009

Oracle Data Pump expdp export modes -  January 3, 2009

Fix ASMCMD slow performance - January 1, 2009

Import: Tablespace does not exist tips - December 30, 2008

Oracle export query option tips - December 29, 2008

How to index on a SQL CASE statement - December 29, 2008

How to remove an expired backupset with RMAN - December 29, 2008

Oracle SQL for padding leading zeros - December 28, 2008

ORA-00845: MEMORY_TARGET not supported on this system tips - December 27, 2008

Understanding a key preserved table - December 27, 2008

Script to identify index fragmentation - December 23, 2008

Oracle Windows tnsnames.ora location - December 26, 2008

ORA-1652: unable to extend temp segment tips - December 23, 2008

Fix hanging SHUTDOWN: waiting for active calls to complete - December 22, 2008

opmnctl gives IP port conflict error - December 19, 2008

Export Import optimizer statistics with dbms_stats - December 19, 2008

BC papers - Collaborate 2009

Origin of nowt so queer as folk

SQL to Display fields of two tables in tabular form - December 18, 2008

Supplementing Oracle technical support - December 17, 2008

Oracle service request support - December 17, 2008

How to reclaim space from a temp segment - December 16, 2008

driving_site hint tips - December 16, 2008

Fix SQL Developer vendor error 17002 - December 15, 2008

How to remove a database instance - December 14, 2008

A script to detect when indexes require rebuilding - December 13, 2008

How to read a text file into an Oracle table - December 13, 2008

Create Oracle listener on a non-standard port number - December 13, 2008

Oracle technical support and archivelog mode - December 13, 2008

A case study in incomplete recovery - December 13, 2008

Handy awk commands - December 13, 2008

Resolving the ORA-02050: transaction string rolled back error - December 3, 2008


******************************
save this for future reference ==> Oracle 2009 cruise is now booking!

save this for future reference ==> Oracle RAC instructor wanted $1K/day

save this for future reference ==> Part-time Oracle experts wanted $1K/day

 

Friday Fun News Articles:

http://dba-oracle.blogspot.com/2007/07/real-life-south-park-kids.html

dba-oracle.blogspot.com/2010/01/confession-of-butt-hole-bandit.html  

dba-oracle.blogspot.com/2010/02/fun-with-google-street-views.html  

http://dba-oracle.blogspot.com/2009/08/squirrelize-your-photos.html  

http://dba-oracle.blogspot.com/2010/02/fun-counterintuitive-facts.html

http://dba-oracle.blogspot.com/2010/02/funny-mis-spelled-tattoos.html

dba-oracle.blogspot.com/2008/11/racism-in-google-keyword-suggestions.html

http://dba-oracle.blogspot.com/2009/05/designing-intelligent-logos-with.html

dba-oracle.blogspot.com/2009/04/what-kind-of-dog-is-that.html

http://dba-oracle.blogspot.com/2010/02/funny-folk-art-examples.html

http://dba-oracle.blogspot.com/2010/02/correlation-between-teat-count-and-milk.html

http://dba-oracle.blogspot.com/2010/02/making-your-dog-look-human_23.html

http://dba-oracle.blogspot.com/2010/02/big-brother-is-watching-you.html

http://dba-oracle.blogspot.com/2010/02/elderly-people-can-be-eaten-by-their.html

http://dba-oracle.blogspot.com/2010/02/2010-sexual-promiscuity-statistics.html

http://dba-oracle.blogspot.com/2010/02/beware-of-military-impostors-in.html

http://dba-oracle.blogspot.com/2010/02/computer-virus-activates-itself-at-200.html

http://dba-oracle.blogspot.com/2010/02/obsolete-archaic-american-exclamation.html

http://dba-oracle.blogspot.com/2010/02/cats-milk-food-products.html

http://dba-oracle.blogspot.com/2010/02/funny-hidden-messages-in-korean.html

http://dba-oracle.blogspot.com/2010/02/weird-african-movie-posters.html

http://dba-oracle.blogspot.com/2010/02/why-america-has-no-field-marshalls.html

http://dba-oracle.blogspot.com/2010/02/using-tachistoscopic-episcotister.html

http://dba-oracle.blogspot.com/2010/01/superimposing-old-photos-onto-modern.html

http://dba-oracle.blogspot.com/2010/01/veterans-widow-benefits-help-widowers.html

http://dba-oracle.blogspot.com/2010/01/prank-ask-celebrity-to-sign-someone.html

http://dba-oracle.blogspot.com/2006/10/are-you-man-of-year.html

http://dba-oracle.blogspot.com/2010/01/original-space-cadets.html

http://dba-oracle.blogspot.com/2010/01/good-samaritans-sued-by-un-dead-man.html

http://dba-oracle.blogspot.com/2010/01/five-gender-computer-systems.html

http://dba-oracle.blogspot.com/2010/01/credit-card-purchase-history-and.html

http://dba-oracle.blogspot.com/2010/01/eating-extinct-meats-endangered-species.html

http://dba-oracle.blogspot.com/2009/12/being-eaten-alive.html

 

Harry - New research:

Creative STATSPACK and AWR scripts

Oracle bloom filter hashing

Oracle: set threshold alerts

Storing video files in Oracle

Managing the Oracle alert log file

Oracle bind variable peeking tips

SQL Profiles to replace stored outlines



Parallel transaction recovery, undo and CPU performance - June 13, 2008

SQL to compare two date ranges - June 13, 2008

Oracle tuning Guru achieves 20x performance improvement - June 14, 2008

Recommended 2008-2009 regional Oracle user group conferences

Distributing RMAN backups across multiple disks - June 17, 2008

Oracle performance testing tips - June 18, 2008

dbms_xplan.display_awr tips - June 21, 2008

export with complex query filtering - June 29, 2008

Oracle RAC Service Settings tips - July 1, 2008

Oracle CMAN address tips - July 4, 2008

Oracle Windows Utilities list - July 5, 2008

Oracle UNIX/Linux Utilities list - July 5, 2008

Online redo logs and RAID tips - July 7, 2008

RAC Database cloning with HOT Backup - July 11, 2008

Oracle Migrations tips - July 17, 2008

 

 


******************************
Use as-needed, changing the link name to a descriptive name

** Add descriptive link names below\


--- - /oracle applications/index.htm
-

--- - /t_error_code_list.htm - Oracle News by Don Burleson

--- - /t_ora_12514_tns_listener_service_name.htm - Oracle News by Don Burleson

--- - /concepts/pl_sql_if_then_else_statements.htm - Oracle News by Don Burleson

--- - /t_pl_sql_if_statement_syntax_example.htm - Oracle News by Don Burleson

--- - /qualifications.htm - Oracle News by Don Burleson

--- - /t_ora_00933_sql_command_ended.htm - Oracle News by Don Burleson

--- - /art_builder_get_schema_syntax.htm - Oracle News by Don Burleson

--- - /t_ora_06502_pl_sql_numeric_value_error.htm - Oracle News by Don Burleson

--- - /t_ora_12705_error.htm - Oracle News by Don Burleson

--- - /t_ora_12162_tns_net_service_name.htm - Oracle News by Don Burleson

--- - /t_make_deer_butt_alien.htm - Oracle News by Don Burleson

--- - /oracle_news/2004_11_10_easy_lookup_error_codes.htm

--- - /t_computer_motivational_posters.htm - Oracle News by Don Burleson

--- - /t_synonyms.htm - Oracle News by Don Burleson

--- - /t_ora_07445_exception_encountered.htm - Oracle News by Don Burleson

--- - /t_ora_02019_connection_description_remote_database.htm - Oracle News by Don Burleson

--- - /art_builder_sqlnet.htm - Oracle News by Don Burleson

--- - New ways to prevent Hippies - Oracle News by Don Burleson

 

Supplemental links:

 

 

 

 
��  
 
 

 
 
 
 
oracle dba poster
 

 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright 1996 -  2014

All rights reserved by Burleson

Oracle is the registered trademark of Oracle Corporation.