Call now: 252-767-6166  
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 


 

 

 


 

 

 

 

 Oracle Articles

           By Burleson Consulting

Burleson Consulting is an altruistic company and we believe in sharing our Oracle extensive knowledge through publishing Oracle books and Oracle articles, video Oracle training, and one-on-one Oracle education courses.  BC pledges to help the Oracle community by publishing our tips, tricks and techniques and we hope that you find our tips informative.

Hot Oracle Articles & Content

 

BC Training Catalog
Consulting Prices
Oracle Grant Security
Oracle Stored Procedures
BC Oracle Tuning Book
Oracle SQL Tuning Tips
Tuning SQL with dbms_stats
 
Oracle Articles and RSS Feeds

 

   DBA Oracle Blog RSS Feed
    Oracle News RSS Feed/font>

                              Register for weekly Oracle Tips

                              BC Oracle Webcasts
                              Oracle Articles Archive
                              Oracle Tips Archives
                              Oracle Quick Tips

 

 

 

 

Our staff has unprecedented opportunity to see real-world Oracle database in-action and we share our experiences on this page of Oracle articles. 

Publish articles with BC

BC is a leading publisher of Oracle articles and we are affiliated with Rampant TechPress, the leading publisher of Oracle books.  If you want to publish an article or book, please call or e-mail BC today.

Oracle Article Index:

 

&n 


   

Click here for Burleson reader comments.font>

 


 


  Burleson Humor & Opinion Articles:
       

  For more opinionated nonsense, see the Don Burleson Blog!

 

 

 

  Burleson IMHO Articles:
           "Because you have the right to my opinion"

  For more opinionated nonsense, see the Don Burleson Blog!

                
 

 


Sports Tips

 

   

   Burleson Consulting Oracle Articles

       BC Oracle articles dating from 1999

 


 

   

   Oracle Articles by BC consultants

      

The following articles are published by the BC team of top-notch Oracle experts.

Oracle articles quoting Donald Burleson

 John Garmany Articles

Articles by Robert Freeman

Articles by Steve Karam, OCM, Oracle ACE

Articles by Kent Crotty, OCP

Articles by Mike Ault

Articles Quoting Mike Ault

Oracle error tips:

 

 

 

   

   Oracle Articles by Mark Rittman

      

 

   

   Oracle Application Server Articles

        OracleAS, Oracle 10gAS & Oracle9iAS

      

 

 

   

   Oracle Articles tip Archive

        Oracle articles from the major portals      

 

 

Freeman Oracle Tips Archive

 

   

   Oracle Articles & quick tips

             

Donald K. Burleson holds a BA degree in Psychology and a Masters Degree in Business Administration with a concentration in Information Technology from the University of New Mexico.  Burleson has published numerous articles in academic journals including “Information and Management” and has authored more than 30 books on database technology with McGraw-Hill, Wiley Publishing, CRC Press, O’Reilly and Rampant TechPress.  Burleson is considered an expert in information systems architecture and database management and has published more than 100 articles in major IT trade publications and periodicals.

 

·         "host" command Tips - 21 February 2014

·         _adaptive_direct_read tips - 7 June 2013

·         _awr_flush_threshold_metrics tips -  21 November 2012

·         _close_cached_open_cursors tips - 20 February 2014

·         _convert_set_to_join tips - 8 April 2014

·         _db_block_cache_protect tips -  21 November 2012

·         _index_prefetch_factor Tips -  11 March 2014

·         _optimizer_better_inlist_costing Tips - 19 July 2013

·         _optimizer_cost_based_transformation tips - October 26, 2007

·         _optimizer_extend_jppd_view_types tips -  27 January 2013

·         _optimizer_group_by_placement tips -  27 January 2013

·         _serial_direct_read tips - 7 June 2013

·         _sys_logon_delay tips - 3 March 2014

·         _very_large_object_threshold tips - 7 June 2013

·         10g new features

·         11g Cube-organized Materialized View tips -   November 14, 2007

·         11g extended optimizer statistics - December 13, 2007

·         11g new features peek

·         11g SQL execution plan management tips - December 13, 2007

·         11g SQL Plan baseline tips - January 16, 2008

·         2007 trends in Oracle web security management - December 10, 2007

·         A brief history of database disk storage - October 28, 2007

·         A brief history of database RAM storage - October 28, 2007

·         A Top Linux command book

·         Access alert log with SQL

·         Access Violation in ora80-5.dll from SQL*Forms 6i

·         access.sql script to see execution plan details

·         Accessing Trace Records

·         Activate Oracle Client Caching for OCI Applications - 9 August 2013

·         Add a bucket to a frequency histogram - 14 May 2012

·         Add Constraint Oracle

·         Add space to Oracle tablespace - 29 April 2013

·         Add Streams replication to new server node - 11 January 2013

·         Adding animated pictures to PowerPoint Presentations

·         Adjusting STATSPACK Collection levels

·         Aegis Oracle Tips

·         afiedt.buf Tips - 21 February 2014

·         After Oracle 10g - What comes next?

·         Ahmed Baraks's summary of oracle 10g features

·         AIX: 32-bit or 64-bit? - November 12, 2007

·         Alert log shows no standby redo logfiles tips

·         alert log tips - 3 March 2014

·         All Oracle 8i hidden parameters

·         alter database move datafile <number> tips - 4 January 2013

·         Alter Oracle for autoextend on

·         Alter table column from LONG to CLOB Tips -  11 November 2012

·         alter table monitoring Tips -  7 March 2014

·         Alter Tablespace Add Datafile

·         Alter User Oracle

·         alter_database_tab_monitoring

·         alter_schema_tab_monitoring

·         Alteration of Databases

·         Altering Oracle sequences

·         AMM resize scripts - 26  October 2013

·         and-equal data access method

·      Anonymous Block Tips

·         ApEx (HTML-DB) release 3 new features

·         Application Page to use a JavaScript multi-level menu list

·         aq_tm_processes Tips -  15 March 2014

·         Archiving Oracle Data in easily restorable non-Oracle structures

·         Archiving Oracle table audit data with partitioned tablespaces

·         Are Podcasting and RSS considered Broadcasting?

·         Array, TAF & load/unload features of DBI/DBD::Oracle

·         ASM add volume command -  28 May 2012

·         ASM Template Tips -  29 January 2013

·         ASM vs filesystems   - 13 November 2012

·         asmcmd tips

·         Assigning Oracle user security roles

·         Assigning weights for a multi-column Oracle text index - January 18, 2008

·         ASSM, freelists and PCTFREE

·         AU size and stripe size tips - 21 December 2012

·         audit_file_dest adump tips - 14 February 2014

·         Audit_trail parameter tips - 21 May 2012

·         auditing concepts webcast

·         Auditing Oracle eBusiness Suite Financials

·         Ault & Burleson to give Predictive Modeling Seminar

·         authid & definer rights tips - 5 January 2013

·         authid & invoker rights - 5 January 2013

·         Automated Storage Management ASM configuration

·         Automatic speech/voice recognition software for the Oracle professional - January 19, 2008

·         Automating Oracle Data cleansing approaches

·         Autonomous Transaction

·         AWR and SQL Tuning

·         AWR Report CPU Analysis - 20 February 2013

·         AWR report for RAC Tips - 17 December 2012

·         AWR Top 5 foreground events script - 10 November 2013

·         Backup Oracle tips - 26 March 2014

·         Backup VLDB tips - 26 March 2014

·         bash .profile for Oracle  - 28 April 2013

·         BC Oracle cruise

·         BC Oracle data security policy

·         Becoming an Oracle expert

·         Best Oracle Security Book

·         best webserver hardware configuration tips

·         Beware of Oracle's ease of use! -  November 13, 2007

·         Beware of profiteer database users groups

·         Bi-directional Streams replication

·         Bigfile and Smallfile Performance - 3 October 2013

·         bind_aware hint tips - 12 February 2013

·         Biometric fingerprint scanners planned for credit card authentication

·         Bizgres tips

·         Black Arabian Stallion

·         Blocking Oracle access by IP Addresses

·         blockrecover command tips  -  10 July 2013

·         British Bloggers face journalist standards when web publishing

·         Buffer busy waits and I/O contention

·         buffer pins Tips - 14 March 2014

·         Burleson scuba divers

·         caching dual table

·         Calculating Oracle average row length

·         Camera interfaces with Oracle

·         Can Discoverer "Drake" Replace Discoverer Desktop?

·         Can you do Oracle data warehousing on Standard Edition?

·         Cannot allocate new log - Private strand flush not complete - October 19, 2007

·         catio.sql io_per_object sample_io

·         Cemutlo tips - 20 December 2012

·         Chain together Oracle jobs - 29 April 2013

·         chained rows by session Tips - 21 March 2014

·         Change column order within Oracle table -  23 May 2012

·         change current directory from SQL*Plus - 29 January 2014

·         Change long raw datatype to character column - 14 December 2012

·         Change nls_date_format at login time - 29 January 2014

·         Change Oracle environment in UNIX/Linux - 28 April 2013

·         Change Oracle IP and Domain DNS Tips

·         Change system date on Oracle server Tips -  9 March 2014

·         Change the SQL*Plus Default Display Width

·         Changing hidden characters with UNIX vi

·         Changing remote login passwordfile September 6th, 2007

·         Changing table index maxextents unlimited

·         Check & verify Oracle windows services

·         Clandestine Oracle support for OCP's

·         Cleanout job script to remove archived redo logs trace & dump files

·         clonedb utility Tips - WIP

·         Cloning a large terabyte RAC database

·         Cloning an Oracle user

·         Cloning ORACLE_HOME Tips - 21 March 2013

·         coe_xfr_sql_profile.sql tips - 23 March 2014

·         ColdFusion Oracle PL/SQL in cfset tag

·         Command to count Oracle databases on a server

·         Common Linux command line alias settings for Oracle

·         Common Oracle performance problems

·         Communications skills for Oracle professionals

·         Compare Oracle Database Tips - 4 November 2012

·         Composite partitioning tips - 17 February 2014

·         Composite partitioning tips - 17 February 2014

·         Compress Oracle tablespaces - 26 March 2013

·         Compressing Oracle backups and data files

·         Compute Oracle index statistics

·         Computer book authors agencies and computer book agents

·         Computing Oracle percent (%) used for tablespaces

·         Concepts and goals of Oracle data scrubbing

·         concsub utility tips - 3 March 2014

·         Concurrent manager job scheduling utility

·         Configuring oracle network

·         Connect Oracle to SQL Server

·         Connecting to a hung database with the -prelim option - 29 March 2014

·         Connecting to Oracle with the Perl DBI

·         Consolidation of Oracle Audit Data sources

·         control_management_pack_access Tips  - 12 March 2014

·         Convert BLOB to CLOB script - 21 November 2012

·         Convert excel files into Oracle Tables - 8 May 2012

·         Convert Oracle BLOB to XML Type -  7 March 2014

·         Convert Oracle dmp file -  23 March 2013

·         Convert VARCHAR2 to CLOB Tips - 8 May 2012

·         Converting Oracle rows to columns

·         copy Oracle table into MySQL database

·         copy Oracle tables between schemas - 6 June 2013

·         Corporate e-mail spam rules

·         Corporate Information Technology (IT) budget planning

·         Count all SQL accessing a schema - 14 June 2013

·         count trace files - 14 July 2013

·         counterintelligence-scope CI polygraph

·         Counting Oracle tables

·         CQL tips - 30 June 2013

·         Create Database Link Oracle

·         Create index Performance Speed Tips -  8 March 2014

·         Create or Replace Procedure

·         Create Schema

·         create table using CTAS tips - 31 March 2014

·         Creating an Oracle Data Cleansing Architecture

·         Criminals offer shilling bidding service for eBay

·         crsctl modify resource tips  - 16 February 2014

·         CTAS table reorg

·         ctx_indexes tips - 8 July 2013

·         current trace file Tips - 17 November 2012

·         current_schema Tips - 5 May 2013

·         cursor: pin S wait on X Tips - 1 May 2013

·         Custom SQL*Plus prompt tips - 17 March 2014

·         Data buffer hit ratio for multiple data buffer pools - 7 November 2012

·         Data Dictionary catalog scripts

·         Data format validation with Oracle regular expressions

·         Data Guard FastSync Tips - 15 March 2014

·         Data guard switchover with dgmgrl

·         Data Guard: archive log target fix

·         Data Masking Pack tips - 31 March 2014

·         Data Pump "where" clause Tips - 7 October 2013

·         Data Pump Import/export parallel tips - 17 December 2012

·         data pump transform tips - 21 August 2013

·         Data Pump version option tips - 3 April 2014

·        
Data redaction tips

·         Data Unification & Cleansing with Oracle

·         data warehouse features by release

·         Database benchmarking tips

·         Database Consultant

·         Database Consultants

·         Database link from Oracle to SQL Server

·         database security auditing

·         Database size by day tips - 21 December 2012

·         Database size by month tips - 21 December 2012

·         Database sizing for Oracle tips - 2 March 2014

·         database_trace_enable tips - 22 February 2014

·         dateline adoption scams fraud

·         db_cache_size

·         db_file_multiblock_read_count

·         db_file_noncontig_mblock_read_count Tips -  11 March 2014

·         db_writer_processes Tips -  25 April 2013

·         DBA job title hierarchy tips - 12 February 2014

·         dba_advisor_findings procedure

·         dba_autotask_client tips - 13 September 2013

·         dba_dml_locks Tips - 10 December 2012

·         dba_editioning_views tips - 4 April 2014

·         dba_extents scripts tips - 7 July 2013

·         dba_hist_resource_limit Tips - 7 December 2012

·         dba_hist_service_wait_class Tips - 7 November 2012

·         dba_hist_sysstat tips - 14 July 2013

·         dba_hist_wr_control tips -  17 March 2014

·         dba_tab_subpartitions tips - 3 April 2014

·         DBCA database name display Tips - 3 January 2013

·         DBGSQL Tips - 4 February 2013

·         DBI and Oracle

·         dbms_aqadm.create_queue example - 24 March 2014

·         dbms_aqadm.create_queue_table example - 24 March 2014

·         dbms_auto_task_admin tips

·         dbms_backup_restore tips - November 6, 2007

·         dbms_datapump name_expr tips - 24 February 2014

·         dbms_datapump name_list tips - 23 February 2014

·         dbms_ijob Tips - 21 March 2014

·         dbms_job vs. dbms_scheduler

·         dbms_job.broken tips

·         dbms_job.remove tips

·         dbms_job.submit Tips - 10 November 2012

·         dbms_lob.converttoclob Tips -  7 March 2014

·         dbms_lob.writeappend to join BLOB columns

·         dbms_metadata tips

·         dbms_mtune

·         dbms_outfut.put_line

·         dbms_parallel_execute tips - 11 February 2014

·         DBMS_QOPATCH Tips - 16 March 2014

·         dbms_scheduler replaces cron for shell scripts

·         dbms_shared_pool.keep

·         dbms_shared_pool.markhot tips - 24 March 2014

·         dbms_stats collection frequency scripts - 22 September 2013

·         dbms_stats.gather_fixed_objects_stats tips

·         dbms_stats.gather_system_stats and SQL optimizer behavior

·         dbms_stats.report_stats_operations tips - 21 August 2013

·         dbms_stats.set_system_stats -  7 March 2014

·         dbms_sys_sql Tips - 21 March 2014

·         dbms_warning usage tips

·         dbms_xmlquery vs. dbms_xmlgen

·         dbnewid tips - 13 February 2014

·         DBWR Tuning Tips

·         DDL over a db link tips - 5 November 2012

·         Decompiling Oracle Java decompiler

·         Decreasing log file sync waits

·         Dedicating CPU processors - Oracle affinity

·         default ORACLE_HOME location on Windows - 21 March 2013

·         Defending against web content theft

·         Definition: Ya Boo Sucks to you

·         Delete archived redo logs scripts - 26 March 2014

·         Delete duplicate rows - Deletion from Oracle tables

·         Delete multiple duplicate rows - 8 February 2014

·         descending index tips - 25 March 2014

·         Designing object-oriented type hierarchies in Oracle tables

·         Detecting duplicate Oracle indexes

·         Diagnosing the ORA-12537: TNS: connection closed error

·         Dictionary queries have very poor performance

·         Dictionary query to display function-based index function

·         Difference between Oracle Applications 11i and 12

·         Difference between Oracle DBA and Oracle Apps DBA - 31 December 2012

·         Difference between Oracle DBA and Oracle Apps DBA -  29 December 2012

·         Difference between rman and Oracle Secure Backup -  29 January 2013

·         Difficulty with Host Credentials in Linux September 10th, 2007

·         Dimensionless Star Schema (Bitmap Star)

·         direct export to remote database tips - 4 August 2013

·         disable Oracle 10g statistics collection

·         Disable Oracle Dynamic Sampling

·         Disable Oracle job Tips -  26 May 2012

·         disable table lock tips - 7 April 2014

·         Disabling AWR data purging - 25 March 2013

·         Disabling hash joins - 21 February 2014

·         Disabling sort merge and hash joins tips - 8 April 2014

·         Discoverer "Not all rows have been retrieved. Data may be inaccurate" tips

·         Discoverer: The server is running low on virtual memory tips

·         Disk Average Failure Rate (AFR)

·         Disk to LUN I/O performance on SAN and NAS

·         display composite indexes Tips - 8 November 2012

·         Display current directory from SQL*Plus - 29 January 2014

·         Display database links tips -  3 February 2014

·         Display Oracle concurrent manager processes

·         Display Oracle locks - locked rows for a user

·         Display Oracle SQL output rows on one single line

·         Display ORACLE_HOME tips - 30 June 2013

·         Display RAC Interconnect Details

·         Display similar SQL tips  - 2 February 2014

·         Display SQL plan outline - 23 March 2014

·         Display SQL Server database waits

·         Display SQL Server log errors

·         Display SQL Server RAM memory buffer cache

·         Display SQL Server session hogs

·         Display SQL Server storage filegroups script

·         Display SQL Server table I/O

·         Display tables in other schemas

·         Displaying RAM usage for SQL execution plan steps

·         Don Burleson speaks on 11g gotchas - October 15, 2007

·         Donald K. Burleson expert systems, decision support systems and AI experience

·         Downgrading Oracle - Downgrade tips

·         Dropping and deleting Oracle histograms - 22  October 2013

·         Dumping ASH Data to a Flat File tips -  7 April 2014

·         dupgdiag.sql Tips -  15 March 2014

·         duty security model tips - 16 March 2014

·         Eastern Caribbean Oracle Users Group 2007 Speakers

·         Easy formatting of Oracle SQL

·         Easy Oracle web searching

·         eBay and illegal ebook/software downloads

·         eBay fights States who enforce auctioneer license requirements

·         edit spfile tips - 20 March 2014

·         Elite Oracle Tips

·         Enable trigger tips - 2 July 2013

·         enable_ddl_logging Tips - 6 February 2014

·         Enabling AMM in 10g

·         Encrypt BFILE column Tips -  26 November 2012

·         encryption_pwd_prompt - 21 August 2013

·         endian format Tips - 4 May 2013

·         enqueue memory scripts - 13 July 2013

·         Entity Relation Diagram (ERD) tools for Oracle databases

·         Equivalent of exp consistent=y in expdp - 19 February 2014

·         ERROR 45 Initializing SQL*PLUS Internal Error

·         Error: dbconsole java.lang.exception: no such metric September 11th, 2007

·         Estimate Oracle Index Size

·         Estimate Space used by an Oracle Index

·         Estimating SGA size tips

·         Estimating the costs of Oracle data exposure

·         etc/group tips - 25 February 2014

·         ETL with pipelined table functions & external tables

·         Excel Database tips

·         Excluding Tables from Full Exports September 12th, 2007

·         execute immediate causes insufficient privileges over a database link   - 8 May 2012

·         Execute Immediate on Large Insert Strings

·         Execute operating system commands in Oracle

·         Executing SQL with the Oracle Perl DBI

·         exp imp tables

·         EXP: ORA-01036:illegal variable name/number

·         EXP-00002 tips - December 19, 2007

·         EXP-00008: ORACLE error 1455 encountered Tips  - 13 December 2012

·         EXP-00008: ORACLE error 904 encountered tips

·         EXP-00056: ORACLE error 942 encountered database link

·         EXP-00091 Exporting questionable statistics tips

·         expdp data pump compression_algorithm - 21 August 2013

·         expdp data pump disable_archive_logging - 21 August 2013

·         expdp dmp file location - 9 September 2013

·         expdp encrypted export tips -   18 March 2014

·         expdp encryption_mode tips -  18 March 2014

·         expdp exclude tips - 25 February 2014

·         expdp flashback_time tips - 20 February 2014

·         Expdp Impdp Network_Link Tips - 5 November 2012

·         expdp include tips - 25 February 2014

·         expdp view_as_tables Tips - 3 January 2013

·         Export a view Tips  - 12 March 2014

·         export import from Solaris to Linux - 13 November 2012

·         Export in excel format tips - 2 March 2014

·         Export table and index definitions only - 16 November 2012

·         Export table to csv Tips- 21 December 2012

·         Export to csv file Tips - 12 December 2012

·         Export with VPD Tips   - 12 March 2014

·         Extended cursor_sharing tips - 12 February 2013

·         extproc for Oracle tips - 10 April 2014

·         Extract SQL from AWR tips - 25 February 2014

·         Extract SQL from Oracle - 14 January 2013

·         ezconnect Tips - 22 March 2013

·         Far Sync Data Guard Tips -  23 July 2013

·         FAS 48 and income statements for publicly held corporations

·         Fast copying of Oracle table data Tips - 23 March 2014

·         fatal ni connect error 12170 Tips - 7 November 2012

·         final_blocking_session & final_blocking_instance Tips - 23 March 2014

·         Find all Oracle instances on a server - 3 March 2014

·         Find all Oracle listeners on a server - 3 March 2014

·         Find corrupt blocks in Oracle - 28 February 2014

·         Find disk constrained Oracle instance - 5 July 2013

·         Find gaps in Oracle sequences - October 26, 2007

·         Find Location of Oracle redo logs on Windows - 10 December 2012

·         Find long running SQL queries - 16 February 2014

·         Find max file size in partitioned table tips - 9 April 2014

·         Find movie show times fast

·         Find objects inside block tips - 12 July 2013

·         find oracle corruption - 15 November 2012

·         Find Oracle locked users -  6 March 2014

·         Find Oracle RAC Locks

·         Find ORACLE_HOME - 8 September 2013

·         Find ORACLE_SID - 8 September 2013

·         Find partition for a row tips - 19 September 2013

·         Find recently executed SQL - 5 November 2012

·         Find SQL with most updates -  29 May 2012

·         Find SQL*Plus file path  - 7 February 2013

·         Find tables referenced inside PL/SQL stored procedures

·         Find tables that do not belong in the SYSTEM tablespace - 22 January 2013

·         Find the Last Accessed Date for an Oracle Discoverer Workbook

·         Find the length of a CLOB - 14 March 2014

·         Find the threshold for large tables and small tables

·         Find the threshold for large tables and small tables - November 14, 2007

·         Find top indexes by size tips  - 1 March 2014

·         Find top tables by size tips - 1 March 2014

·         Find top tables tips - 1 March 2014

·         Find trace file in Oracle tips - 10 November 2013

·         Find unused columns with dba_unused_col_tabs

·         Finding Oracle business intelligence experts

·         Finding oracle locked objects -  9 March 2014

·         Finding Oracle materialized view opportunities

·         Finding Oracle Tuning experts

·         fingerprints as tables primary keys

·         fired for web surfing

·         First_rows tips - 19 February 2013

·         Fix high "cache buffer chain" waits

·         Fix Oracle mutating table errors

·         Fix Oracle swapping on AIX

·         Fix shared pool latch contention - 9 February 2013

·         Fix SQL*Loader date format errors

·         fixing Oracle broken jobs

·         Fixing slow connection problems in 10g

·         Fixing unexpected performance degradation caused by sub-optimal optimizer statistics

·         Flashback Data Archive (FDA) tips - 19 February 2014

·         fnd_request.submit_request tips - 3 March 2014

·         Forecasting Oracle Performance

·         Formatting PL/SQL stored procedure output - January 16, 2008

·         Freelist Tips - 6 February 2014

·         FRM-10221 September 17th, 2007

·         FRM-41839: Disk I/O error on temporary record buffer file September 26th, 2007

·         full hint Tips - 22 July 2013

·         full transportable data pump Tips - 15 March 2014

·         Fun News!

·         Get 10g SQL plans - 28 April 2013

·         Get AWR report on two time periods - 17 December 2012

·         Get AWR report on windows - 17 December 2012

·         Get DDL for Materialized View Script - 5 November 2012

·         Get ORACLE_SID from inside PL/SQL - 10 February 2013

·         ggs_ddl_trace.log Tips -  23 July 2013

·         Global temporary table tips - 22 February 2014

·         global temporary table troubleshooting tips - 26 March 2014

·         GoldenGate Data Pump tips -  5 March 2014

·         GoldenGate for Oracle Replication

·         Government Data Security Malfeasance

·         GPA LSAT GMAT test score matrix grid

·         Graphing Oracle SQL output - October 26, 2007

·         Grid Control Post Installation Tips - October 3, 2007

·         Gross State Domestic Product

·         Hacking Oracle from the Web

·         Handling NULL sets within the SQL CASE statement - November 7, 2007

·         Harvard & MIT extension schools have lower standards

·         hash join hint Tips - 14 March 2014

·         hash partition tips - 17 February 2014

·         hash_area_size

·         Hawaii Oracle Users Group meeting

·         Heterogeneous Database connections - Oracle to SQL Server

·         hidden characters in Oracle table names - Tony Jambu

·         Hidden Oracle8i log parameters

·         Hide passwords in oracle shell scripts - 20 February 2014

·         High speed Oracle data extract and reload

·         History of Postgres releases & features

·         Homeland Security says outsourcing increases risk of cyberattacks

·         How does STATSPACK collect "Top SQL"?

·         How much is a college degree worth?

·         How often to reanalyze statistics Tips - 20 November 2012

·         How to become an Oracle Applications DBA

·         How to cancel a concurrent manager request - 28 February 2013

·         How to change an Oracle table owner - October 24, 2007

·         How to compare two tables - 21 February 2014

·         How to create a word document from Oracle - December 27, 2007

·         How to create an Oracle database link - January 17, 2008

·         How to delete from VARRAY tips - 21 February 2014

·         How to detect a leap year with Oracle  -  January 15, 2008

·         How to display the execution plan for a finished SQL - 8 November 2012

·         How to do switching between oracle databases

·         How to enable automatic statistics collection in 11g r2 - 22 January 2013

·         How to enforce a minimum password length - November 8, 2007

·         How to force an execution plan -  25 November 2012

·         How to Format Oracle output with HTML/XML - January 15, 2008

·         How to generate a csv of a oracle table Tips - 21 December 2012

·         How to handle percent (%) underscore (_) and quotes within SQL LIKE queries

·         How to install Oracle RAC on Windows - November 2, 2007

·         How to invoke and execute a script from OEM

·         How to kill an Oracle process on Windows - October 20, 2007

·         How to learn Oracle

·         How to load Excel spreadsheet data into Oracle tables - December 27, 2007

·         How to monitor Data Pump sessions - 7 May 2013 

·         How to read an AWR report - 16 May 2012

·         How to read an Export expdp dmp file - 19 November 2012

·         How to retrieve oracle passwords

·         How to see if I am licensed to use AWR -  6 May 2013

·         How to select rows for a specific month - January 8, 2008

·         How to send a fax from Oracle

·         How to store an MS Word doc in Oracle - December 28, 2007

·         How to switch between multiple databases releases on Windows - 9 May 2012

·         How to tell when a scheduled job is running -   13 March 2014

·         How to tell when partition pruning is used - 27 November 2012

·         How to validate that a SQL*Plus script executed successfully - 7 May 2013

·         HTML-DB Administration

·         HTML-DB and JavaScript

·         HTML-DB and table default values

·         HTML-DB check boxes in reports regions

·         HTML-DB JavaScript Directory Hierarchy on the HTTP Server

·         HTML-DB JavaScript static file repository

·         HTML-DB with JavaScript cascading menus

·         HTMLDB: Adding JavaScript to an HTML-DB Application Page

·         HTML-DB: Calling JavaScript on Page Loading

·         HTML-DB: Creating an HTMLDB Button to Call JavaScript

·         HTML-DB: Highlighting Calendar Values

·         HTMLDB: Managing HTML-DB JavaScript Source Code

·         htmldb_mail message management

·         Hyperion vs. Cognos vs. Business Objects?

·         identify migrated/chained rows

·         identify sparse tables

·         Identity theft protection book

·         idle_time Tips -  6 March 2014

·         IE 7 Review

·         IMP-00010: not a valid export file tips -  January 14, 2008

·         impdp import with ORA-04020 error - 9 November 2012

·         impdp like exclude filtering - 5 June 2013

·         impdp specific column tips - 1 May 2013

·         impdp tips - 21 May 2012

·         impdp transform=segment_attributes - 27 February 2014

·         Import a view Tips - 12 March 2014

·         Import nls_lang not compatible - 3 November 2012

·         Import selected rows

·         import transform=disable_archive_logging - 29 January 2014

·         Important bug: Oracle SQL gives wrong result - October 26, 2007

·         Important changes in 10g statistics collection

·         Important notes for global SQL optimization - October 14, 2007

·         IN vs. EXISTS SQL

·         Inadvertent disclosure of Oracle database secrets

·         Index tablespace moved after issuing the "split partition" command - November 12, 2007

·         index_rs_asc hint tips -   25 March 2013

·         Informix to Oracle migration tips

·         Ingres tips

·         init.ora file

·         Initialization Parameters in Oracle 10g

·         inmemory_size tips - 7   November 2013

·         insert hyperlink into SQL output - 10 November 2013

·         Insert into long raw column Tips - 13 December 2012

·         Insert Nested Table tips - 14 May 2012

·         Inside Auction "sellers regret"

·         Inside cyberstalking

·         Inside Oracle 11g Database replay - October 31, 2007

·         Inside Oracle 11g ILM - Information lifecycle management

·         Inside Oracle execution plans

·         Inside Oracle LRU latches

·         Inside Oracle supplemental logging

·         Inside Oracle 10g Automatic Memory Management

·         Inside The Trace File

·         Installation of AWR - 25 January 2013

·         Installation of Oracle

·         installing Oracle STATSPACK

·         Installing RAC for an Oracle data warehouse

·         Integrating Streams Replication and Standby Databases

·         Interactive PL/SQL to accept input

·         Interfacing Oracle with Windows scripts

·         Intermittent Explosive Disorder?

·         Internet Copyright infringement & web page cloaking

·         Internet identity theft protection

·         Internet Oracle deployment of public data over the web

·         Internet Phishing scams book

·         Internet Predators book

·         Internet scams protection book

·         Interpreting Oracle RAC STATSPACK/AWR performance reports

·         Introduction to Bind calls with the Oracle Perl DBI

·         Introduction to Java Debugging

·         invalid nibble errors

·         Invisible data columns Tips - 5 January 2013

·         IOUG 2006 Top Session attendance results

·         IOUG Collaborate 2010

·         Is my Oracle 32-bit or 64-bit?

·         Java ORA-01461 solution - 13 November 2012

·         Java Testing Principles

·         job_queue_interval

·         joins in oracle

·         Jon Emmons on Oracle Linux & UNIX shell scripting

·         Justifying a migration upgrade to Oracle 10g

·         KEEP pool data buffer hit ratio - 7 November 2012

·         kewastUnPackStats(): bad magic 1 tips

·         killing oracle instance tips - 29 March 2014

·         killing oracle sessions

·         ksh .profile for Oracle - 28 April 2013

·         ku$_dblink_view tips - 3 March 2014

·         laptop notebook computers with biometrics and cameras

·         Large Oracle Blocksizes

·         last successful login time scripts - 19 September 2013

·         last_call_et in v$session tips - 31 January 2014

·         Law school admissions UPGA and LSAT

·         Learning Applied Artificial Intelligence with Oracle

·         Learning by Analogy - Oracle

·         Learning ODM

·         Learning SQL*Forms tips

·         Legality, privacy and verifying a college degree  - October 15, 2007

·         lengthb Tips - 14 March 2014

·         Let's roll - The true story of an Oracle hero

·         Lewis speaks on lower-cost Oracle tools

·         Libelous bloggers cost company $100m

·         Limitations of Oracle Streams?

·         Limitations on Oracle SQL processing?

·         Linux command to change all values within files in an Oracle directory?

·         Linux command to change database environment ORACLE_SID

·         Linux Error: 29 : Illegal seek tips

·         Linux Script using UTL_MAIL from SQL* PLUS - 28 December 2012

·         Linux threaded_execution tips

·         List AWR Snapshots - 17 December 2012

·         List Installed Components - 26 September 2013

·         List Oracle patches  -  8 March 2014

·         list partition tips - 16 February 2014

·         list ROWIDs per block - 25 June 2013

·         Listener log file location Tips - 16 July 2013

·         Listener log full tips - 15 July 2013

·         Load XLS file into SQL*Forms tips - 15 February 2014

·         Loading and Analyzing the 10046 Event

·         Loading CLOB data with sqlldr (SQL*Loader)

·         Loading LOB (BLOB) data into tables

·         Loading Oracle data from e-mail attachments

·         loadjava

·         LOB CLOB BLOB, undo and PCTVERSION

·         LOB freepools Tips -  8 May 2012

·         LOB Types and REF Cursors with Oracle Perl DBI

·         Locating similar SQL in Oracle

·         Location of DDL files for SQL*Plus- 1 February 2013

·         Location of Windows hostname - 20 March 2014

·         Lock Down Your Server

·         lock out all end user ID's tips - 24 March 2014

·         log_archive_dest_2 Tips - 22 March 2013

·         logging with LOB, BLOB, CLOB

·         Longest Oracle RAC 24x7 continuous availability

·         Lost SYSOPER password in Oracle 10g - October 4, 2007

·         Make a Oracle table column nullable - 27 February 2014

·         Managing Oracle disk I/O in AIX - November 12, 2007

·         Masking/Hiding/Encrypting password column in db_link view

·         Materialized View Fast Refresh Performance Tips

·         Materialized Views and query rewrite

·         Materialized Views in Oracle Warehouse Builder OWB

·         Materialized Views Refresh Performance Tuning

·         Materialized Views Tuning

·         Max partitions in table - 11 February 2013

·         max_sql_string_size Tips - 4 January 2013

·         max_string_size tips

·         Maximizing Value in Oracle Training Budgets

·         Maximum Oracle Limits

·         Measuring index block density for rebuilding

·         Measuring Oracle transactions per second

·         Measuring Success in Oracle Data Cleansing with precision and recall

·         Merge join cartesian tips - December 12, 2007

·         merge join hint Tips -  14 March 2014

·         Migrating Oracle Schema statistics

·         Minimizing downtime for Oracle release upgrades

·         minimizing migrated rows with pctfree and minimize_records_per_block

·         Misleading test cases: willful deception or sloppy work?

·         MMON suspending action tips - 29 March 2014

·         Modeling transitive Data Dependencies

·         Modeling transitive Data Dependencies webcast

·         Modify AWR Automatic Snapshot Settings - 12 December 2012

·         Monitor data pump expdp export script - 11 June 2013

·         Monitor Oracle alert log Tips - 28 November 2012

·         Monitor Oracle Connections Tips -  12 March 2013

·         Monitor Oracle Windows disks

·         Monitor Oracle Windows dump and trace files

·         Monitoring Network Performance Tips -  14 March 2014

·         Monitoring Network Performance with STATSPACK -  14 March 2014

·         Monitoring Oracle SGA & PGA Memory Changes

·         Monitoring Oracle Table Usage

·         Monitoring REDO Log Buffer Tips - 21 February 2014

·         Monitoring REDO Log Tips - 21 February 2014

·         Monitoring SQL*Loader Inserts

·         Monitoring UNDO Tips - 21 February 2014

·         More Random Data

·         Move RAC redo log files in ASM - 17 May 2012

·         MS-Word adding & removing carriage returns

·         multiple block sizes

·         multiple materialized views

·         Multiple Oracle buffer LRU latches?

·         multi-row subqueries in Oracle tips - 13 July 2013

·         narcissistic personality disorders

·         Native Dynamic SQL tips - 26 February 2014

·         Natural vs surrogate keys for Oracle tables - 7 May 2013

·         Net Present Value of undergraduate grades towards law school tuition

·         New Shared Pool Features of Oracle 10gr2 (release 2)

·         newgrp command Tips - 4 November 2012

·         NFB alleges Oracle Human Resources software is not blind-friendly

·         no_merge hint tips -  23 May 2012

·         Non-ORA Errors September 25th, 2007

·         Object type in dba_objects

·         OEM Database Express Tips - 15 March 2014

·         OEM RAC Monitoring

·         OER 7451 in Load Indicator Tips - 5 November 2012

·         Official DMCA Copyright Infringement Removal Request

·         offset fetch first rows only tips - 11 March 2013

·         OLAP Analytic Workspace XML objects

·         old dbms_scheduler job still running at execution time -  13 March 2014

·         On personal integrity and consulting

·         Online data validation format systems characteristics

·         Online DDL Tips - 15 March 2014

·         Online fraud protection

·         Online Systems Development Standards

·         Online wiki web pages suffer from lack of credibility

·         onsite Oracle consulting

·         On-site Oracle consulting

·         oow_getting_regular_with_regular_expressions.pdf

·         oow_oracle_apex_ajax.pdf

·         Open-Xchange tips

·         Optimal data buffer cache hit ratio tips - 20 May 2012

·         Optimal SHMMAX for Oracle -  21 November 2012

·         Optimize count(*) SQL Tips -  8 March 2014

·         Optimize Full table scans tips - 29 March 2014

·         Optimize Oracle import (impdp) speed

·         Optimize Oracle SQL*Loader Performance

·         Optimizer costs don't match SQL execution performance

·         Optimizer plan stability tips - 23 March 2014

·         optimizer_adaptive_features tips - 29 January 2014

·         optimizer_sql_plan_baselines Tips - 3 May 2013

·         Optimizing Linux network TCP/IP kernel parameters

·         Optimizing Oracle INSERT SQL performance

·         Optimizing Oracle performance

·         ORA- 39171 tips -  22 May 2012

·         ora_archive_state Tips  - 2 September 2013

·         ora_dba group tips - 25 February 2014

·         ORA_ROWSCN.... New 10g pseudo Column

·         ORA-00001: unique constraint (string.string) violated tips

·         ORA-00204: error in reading (block string, # blocks string) of control file tips - October 5, 2007

·         ORA-00257: archiver error. Connect internal only, until freed tips

·         ORA-00310: archived log contains sequence tips

·         ORA-00604: error occurred at recursive SQL level string tips

·         ORA-00823 Tips - 10 December 2012

·         ORA-00900: invalid SQL statement tips

·         ORA-00907: missing right parenthesis tips

·         ORA-00911: invalid character tips

·         ORA-00913: too many values tips

·         ORA-00932 inconsistent datatypes: expected string got string tips

·         ORA-00936: missing expression tips

·         ORA-00937: not a single-group group function tips

·         ORA-00942: table or view does not exist tips

·         ORA-00947: not enough values tips

·         ORA-00959 impdp tips - 3 April 2014

·         ORA-00972: identifier is too long tips

·         ORA-00980: synonym translation is no longer valid tips

·         ORA-01000: maximum open cursors exceeded tips

·         ORA-01031 on create directory - 23 March 2014

·         ORA-01034: ORACLE not available tips

·         ORA-01155 Tips - 15 April 2013

·         ORA-01187 from RMAN copy command tips

·         ORA-01187: cannot read from file nnn because it failed verification tests

·         ORA-01207 tips

·         ORA-01210: data file header is media corrupt Tips - 26 December 2012

·         ORA-01400: cannot insert NULL - 27 February 2014

·         ORA-01401 inserted value too large for column tips

·         ORA-01403: no data found tips

·         ORA-01422: exact fetch returns more than one requested number of rows tips

·         ORA-01442 Tips - 23 March 2014

·         ORA-01489 with listagg - 30 July 2013

·         ORA-01555 in expdp - 14 May 2012

·         ORA-01578 and ORA-26040 tips - December 21, 2007

·         ORA-01652: unable to extend temp segment by string in tablespace string tips

·         ORA-01658: unable to create INITIAL extent for segment in tablespace string tips

·         ORA-01722: invalid number tips

·         ORA-01775 looping chain of synonyms - October 8, 2007

·         ORA-01830 date format picture ends before converting entire input string tips

·         ORA-01917 tips -  4 April 2014

·         ORA-01940 tips

·         ORA-01982 Tips - 5 February 2014

·         ORA-02049: timeout: distributed transaction waiting for lock tips - November 17, 2007

·         ORA-02049: timeout: distributed transaction waiting for lock tips

·         ORA-02064: distributed operation not supported Tips - 12 June 2013

·         ORA-02096: specified initialization parameter: mot modifiable with this option - October 1, 2007

·         ORA-03106: fatal two-task communication protocol error tips

·         ORA-03118: two-task coroutine has invalid state tips - October 2, 2007

·         ORA-03136: inbound connection timed out tips

·         ORA-04031: unable to allocate string bytes of shared memory("string","string","string","string") tips

·         ORA-04068: existing state of packagesstringstringstring has been discarded tips

·         ORA-04098: trigger "string.string" is invalid and failed re-validation tips

·         ORA-12013 Tips - 26 August 2013

·         ORA-12170: TNS: Connect timeout occurred tips

·         ORA-12203: TNS:unable to connect to destination tips

·         ORA-12505: TNS:listener does not currently know of SID given in connect descriptor tips

·         ORA-12518: TNS:listener could not hand off client connection tips

·         ORA-12519: TNS:no appropriate service handler found tips

·         ORA-12523 Tips - 13 August 2013

·         ORA-12528: TNS:listener: all appropriate instances are blocking new connections tips - October 9, 2007

·         ORA-12557: TNS:protocol adapter not loadable - 5 November 2012

·         ORA-12751 tips - 29 March 2014

·         ORA-13516 AWR Tips - 10 August 2013

·         ORA-14407 tips - 5 April 2014

·         ORA-1458: invalid length inside variable character string - October 10, 2007

·         ORA-15029: disk "string" is already mounted by this instance tips - October 22, 2007

·         ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed Tips - 14 December 2012

·         ORA-16025 Tips - 3 May 2013

·         ORA-16139: media recovery required tips - October 23, 2007

·         ORA-16796 tips - 24 September 2013

·         ORA-19554 ORA-27211: Failed to load Media Management Library Tips - 13 December 2012

·         ORA-19625: error identifying file string tips - October 11, 2007

·         ORA-19921: Maximum number of rows exceeded tips - 27 March 2014

·         ORA-20011: Approximate NDV failed: ORA-29913 tips  - 30 March 2014

·         ORA-22905: cannot access rows form a non-nested table item tips - October 25, 2007

·         ORA-22913: table data object string failed to load

·         ORA-23313 error when calling CREATE_MASTER_REPGROUP

·         ORA-23327: imported deferred rpc data does not match string of importing db tips - October 24, 2007

·         ORA-23357: the propagator does not exist tips

·         ORA-24372 tips - 5 April 2014

·         ORA-24756 Tips - 1 February 2013

·         ORA-26713 Streams Apply Tips - 27 March 2013

·         ORA-27085 Tips - 15 February 2013

·         ORA-27101: shared memory realm does not exist tips

·         ORA-28 Tips -  8 March 2014

·         ORA-28000: the account is locked tips

·         ORA-28009:connection as SYS tips

·         ORA-28362: Master key not found tips - 25 March 2014

·         ORA-28545: error diagnosed by Net8 when connecting to an agent

·         ORA-29275: partial multibyte character tips - 13 July 2013

·         ORA-29278: SMTP transient error: string tips - October 12, 2007

·         ORA-29283 with impdp network_link - 11 February 2013

·         ORA-29701: Unable to connect to Cluster Manager Tips - 5 November 2012

·         ORA-29857: domain indexes and/or secondary objects exist in the tablespace tips - October 26, 2007

·         ORA-30036: unable to extend segment by string in undo tablespace "string" tips

·         ORA-30654 missing DEFAULT keyword tips - 14 February 2014

·         ORA-31003 Tips - 16 May 2012

·         ORA-31603: object "string" of type string not found in schema "string" - October 15, 2007

·         ORA-31684 import error Tips - 13 November 2012

·         ORA-31693: table data object string failed to load

·         ORA-32006: %s initialization parameter has been deprecated tips - October 16, 2007

·         ORA-37002: Oracle OLAP failed to initialize tips - October 28, 2007

·         ORA-38136 ORA-04067 on export - 24 December 2012

·         ORA-39152: Table exists Tips - 4 November 2012

·         ORA-39164 tips - 3 April 2014

·         ORA-39700 Tips - 6 August 2013

·         ORA-47400 Command Rule violation Tips  - 15 March 2014

·         ORA-65131 tips - 6 April 2014

·         Oracle - Get IP address

·         Oracle - Slow performance after upgrade

·         Oracle - Tracking constraint dependencies

·         Oracle - UNIX and Oracle parameters

·         Oracle - Using default values

·         Oracle "alter table" add column syntax example

·         Oracle "alter table" constraint syntax examples

·         Oracle "alter table" drop column syntax example

·         Oracle "alter table" modify column Syntax example

·         Oracle "alter table" rename column Syntax example

·         Oracle "Basic" initialization parameters

·         Oracle "connect by" syntax

·         Oracle "file open" wait event tuning

·         Oracle "grant resource" role components

·         Oracle "with admin" vs. "with grant" security privileges

·         Oracle & read ahead cache

·         Oracle _db_writer_flush_imu tips

·         Oracle _log_io_size parameter

·         Oracle _smm_px_max_size Parameter

·         Oracle “with check option” syntax

·          Oracle 10.2 proxy user connect syntax

·         Oracle 100% CPU tips

·         Oracle 10g adaptive threshold monitoring

·         Oracle 10g bug 4243687 wrong count(*)

·         Oracle 10g data mining software tips

·         Oracle 10g fast dual

·         Oracle 10g Materialized Views new features

·         oracle 10g new features

·         Oracle 10g New Features: Changes to dbms_stats

·         Oracle 10g PC Windows and hardware requirements

·         Oracle 10g PL/SQL performance optimization

·         Oracle 10g r2 Data Guard Standby Redo log recovery

·         Oracle 10g RAC installation

·         Oracle 10g release 2 locking changes?

·         Oracle 10g segment advisor Tips

·         Oracle 10g sorted hash clusters

·         Oracle 10g support

·         Oracle 10g tips

·         Oracle 10g tips

·         Oracle 10g v$session_event

·         Oracle 10g XML file formatting

·         Oracle 10g: Find full-table scans with AWR using plan10g.sql

·         Oracle 11g automated SQL Tuning

·         Oracle 11g full hash join - October 25, 2007

·         Oracle 11g fully automated SQL tuning tips - January 17, 2008

·         Oracle 11g Healthchecks service - October 27, 2007

·         Oracle 11g hits the streets

·         Oracle 11g Holistic Tuning Tips - January 17, 2008

·         Oracle 11g memory_target parameter

·         Oracle 11g Real Application Testing (RAT)

·         Oracle 11g release 2 upgrade performance problems - 13 November 2012

·         Oracle 11g SQL performance analyzer concepts - January 16, 2008

·         Oracle 11g SQL tuning transformations - December 16, 2007

·         Oracle 12c adaptive optimization of SQL - 26 February 2013

·         Oracle 12c r1 problems - 12 July 2013

·         Oracle 2008 conference: RMOUG and IOUG Collaborate 2008

·         Oracle 2008 conferences

·         Oracle 8i hidden corruption recovery parameters

·         Oracle 8i hidden database parameters

·         Oracle 8i hidden disable & enable parameters

·         Oracle 8i hidden enqueue parameters

·         Oracle 8i hidden lm parameters

·         Oracle 8i hidden log writer parameters

·         Oracle 8i hidden materialized views parameters

·         Oracle 8i hidden NUMA (non uniform memory access) parameters

·         Oracle 8i hidden real application clusters parameters

·         Oracle 8i hidden recovery parameters

·         Oracle 8i prefetch hidden parameters

·         Oracle 9i Tips

·         Oracle aborted_request_threshold tips

·         Oracle Academy Textbooks

·         Oracle Acquires Sun Microystems for $7.4b

·         Oracle ADF and Java ADF faces

·         Oracle Advanced Analytics (OAA) tips - 1 March 2014

·         Oracle AIX RAC UDP - November 12, 2007

·         Oracle AIX Tuning Optimization

·         Oracle AJAX Consulting Support

·         Oracle AJAX Tips

·         Oracle alert log error notification

·         oracle alert log stored procedure

·         Oracle alter table change column datatype

·         Oracle alter table drop column

·         Oracle alter table shrink space commands

·         Oracle alternative dual table

·         Oracle AMM

·         Oracle Analytic Functions

·         Oracle Analytics 12-5-07

·         Oracle Analyze Index

·         Oracle ANALYZE TABLE

·         Oracle Apex (HTML-DB) best practices certification

·         Oracle Application Server Certification - OCA tips

·         Oracle Application Server Guard

·         Oracle Application Server migration from 9i to 10g

·         Oracle Application Server OracleAS Health Checks

·         Oracle Application Server Tips

·         Oracle Applications - Find installed modules

·         Oracle Applications 11i Health Checks

·         Oracle Applications 11i security tips

·         Oracle Applications Modules

·         Oracle Applications Tips

·         Oracle Applications Tuning

·         Oracle archivelog noarchivelog mode recovery

·         Oracle ASSM

·         Oracle asynchronous change data capture

·         Oracle audit command tips

·         Oracle audit command tips - 19 March 2014

·         Oracle Auditing at the database level

·         Oracle auditing concepts video

·         Oracle auditing for FAS 48

·         Oracle Auditing Misconceptions

·         Oracle Auditing Reliability and Completeness

·         Oracle Auditing traps

·         Oracle auditing: SQL select statements

·         Oracle auditing: SQL select statements

·         Oracle AUM tips

·         Oracle automatic segment space management

·         Oracle Automatic Shared Memory Management (ASMM)

·         Oracle Automatic undo management and transactions_per_rollback_segment

·         Oracle automating script for keep pool caching tables & indexes

·         Oracle autostats_target

·         Oracle Autotrace

·         Oracle AWR report

·         Oracle AWR Retention period

·         Oracle background processes

·         Oracle backup & recovery

·         Oracle backup compression tips

·         Oracle Backward Compatibility Tips

·         Oracle batch shell scripting

·         Oracle BBED Tips

·         Oracle Benchmark Testing

·         Oracle benchmark tips

·         Oracle benchmark tips

·         Oracle benchmarks

·         Oracle best Practices

·         Oracle Bigfile tablespace tips

·         Oracle bind variables

·         Oracle Biometrics Consulting

·         Oracle bitmap freelists

·         Oracle BLOB CLOB storage overhead

·         Oracle BLOB CLOB tips

·         Oracle block change tracking

·         Oracle Block size tips

·         Oracle blocksize

·         Oracle blog tips

·         Oracle Buffer Cache Advisory

·         Oracle Bulk Collect

·         Oracle Business Analytics tips

·         Oracle cardinality hint tips -  December 4, 2007

·         Oracle case insensitive indexes searching

·         Oracle CASE SQL

·         Oracle catalog.sql run twice

·         Oracle CCA Tips - 24 December 2012

·         Oracle certification tips

·         Oracle certification tips

·         Oracle Certifications

·         Oracle certified experts?

·         Oracle Certified Masters

·         Oracle Character Function

·         Oracle classpath

·         Oracle Classroom Training

·         Oracle clustering

·         Oracle Clusters RAC deployment

·         Oracle Coherence: A RAC alternative?

·         Oracle collections

·         Oracle column-oriented data storage

·         Oracle command column within v$session

·         Oracle command column within v$session

·         Oracle compiled PL/SQL

·         Oracle concatenate columns together tips - 25 March 2014

·         Oracle Conference Downloads

·         Oracle Conferences

·         Oracle constraints

·         Oracle Consultant

·         Oracle Consulting Companies

·         Oracle Consulting firms

·         Oracle ContentDB tips - October 24, 2007

·         Oracle Contracting

·         oracle controlfile management

·         Oracle Convert to Number

·         oracle copy

·         Oracle cost based optimizer

·         oracle create database example

·         Oracle CREATE SEQUENCE

·         Oracle create spreadsheet tips

·         Oracle create tablespace & alter tablespace syntax

·         Oracle Create Type

·         Oracle CREATE VIEW

·         Oracle cron crontab examples

·         Oracle cross-platform file writing tips  - 13 February 2014

·         Oracle cube syntax

·         Oracle Current Timestamp

·         Oracle cursor.arraysize tips - December 10, 2007

·         Oracle cursor_sharing

·         Oracle cursor_sharing cached cursors

·         Oracle data access with SOAP

·         Oracle data block segment allocation

·         Oracle Data cleansing anomalies

·         Oracle Data cleansing Decision Support System Team

·         Oracle data extraction for Excel spreadsheets

·         Oracle data file naming tips - 10 February 2014

·         Oracle data file tablespace management FAQ

·         Oracle Data Guard and perlglob

·         Oracle Data Guard licensing guidelines

·         Oracle Data Integrator and OWB

·         Oracle Data Mining Tips

·         Oracle Data Mining tips

·         Oracle data privacy auditing issues

·         Oracle Data Propagation

·         Oracle data pump PCTSPACE tips

·         Oracle data security auditing

·         Oracle Data type

·         Oracle data warehouse configuration

·         Oracle data warehouse date transformation

·         Oracle Data Warehouse DBA

·         Oracle data warehouse design tips

·         Oracle data warehouse development best practices

·         Oracle Data Warehouse Job Roles

·         Oracle data warehouse staffing tips

·         Oracle database growth reports

·         Oracle database privacy and background checks

·         Oracle database sizing estimation

·         Oracle Database Tips

·         Oracle Database Tuning

·         Oracle Datatype

·         Oracle date arithmetic tips - November 15, 2007

·         Oracle date format display

·         Oracle date math manipulation

·         Oracle date to hundredths of a second

·         Oracle dates: group rows into periods

·         Oracle db_files and maxdatafiles parameters

·         Oracle DBA Certification

·         Oracle DBA Code of Ethics

·         Oracle DBA job duties

·         Oracle DBA resume

·         Oracle DBA Screening Service

·         Oracle DBA Tasks

·         Oracle DBA Views

·         Oracle dba_hist_osstat

·         Oracle DBA's threatened by offshoring?

·         Oracle DBCA templates for database creation

·         Oracle dblink

·         Oracle dbms_advanced_rewrite

·         Oracle dbms_alert

·         Oracle dbms_application_info

·         Oracle dbms_aq

·         Oracle dbms_aqadm

·         Oracle dbms_crypto

·         Oracle dbms_ddl

·         Oracle dbms_describe

·         Oracle dbms_expfil

·         Oracle dbms_fga

·         Oracle dbms_file_transfer

·         Oracle dbms_flashback

·         Oracle dbms_job

·         Oracle dbms_job examples

·         Oracle DBMS_LCR

·         Oracle dbms_lob

·         Oracle dbms_lock

·         Oracle dbms_metadata

·         Oracle dbms_metadata

·         Oracle dbms_monitor

·         Oracle dbms_monitor

·         Oracle dbms_mview

·         Oracle dbms_output

·         Oracle dbms_profiler

·         Oracle dbms_random

·         Oracle dbms_rectifier_diff

·         Oracle dbms_redefinition

·         Oracle dbms_refresh

·         oracle dbms_repair

·         Oracle dbms_resource_manager

·         Oracle dbms_resumable

·         Oracle dbms_rls

·         Oracle dbms_rls

·         Oracle dbms_rowid

·         Oracle dbms_scheduler examples

·         Oracle dbms_scheduler for weekday execution

·         Oracle dbms_server_alert

·         Oracle dbms_session

·         Oracle dbms_shared_pool

·         Oracle dbms_sleep

·         Oracle dbms_space

·         Oracle dbms_sql

·         Oracle dbms_sqltune

·         Oracle dbms_stats

·         Oracle dbms_stats validate_stats statistics bugs

·         Oracle dbms_support

·         Oracle dbms_system

·         Oracle dbms_tts

·         Oracle dbms_utility

·         Oracle dbms_workload_repository

·         Oracle dbms_workload_repository

·         Oracle dbms_xpla

·         Oracle dbv database verify Utility

·         Oracle DDL Triggers

·         Oracle deadlock

·         Oracle Debugging

·         Oracle decode

·         Oracle decode function

·         Oracle define table blob lob storage

·         Oracle DELETE Statement

·         Oracle design for performance webcast

·         Oracle Design for performance?

·         Oracle design patterns

·         oracle developer consulting

·         Oracle Developers

·         oracle development

·         Oracle Development

·         Oracle development best practices

·         Oracle diagnostic_tuning_pack_installed - 6 January 2013

·         Oracle dictionary object time created?  - 10 January 2013

·         Oracle Dimensions

·         Oracle Direct Read vs physical read Tips  - 15 November 2012

·         Oracle Directories

·         Oracle directory object tips - 22 December 2012

·         Oracle Disable Constraints

·         Oracle disaster recovery

·         Oracle Discoverer tuning tips - December 28, 2007

·         Oracle disk configuration

·         Oracle disk I/O on Linux Tips

·         Oracle disk I/O throughput speed

·         Oracle DISM Tips   - 5 October 2013

·         Oracle display tablespace contents - 25 March 2013

·         Oracle DML error logging

·         Oracle DML statements

·         Oracle documentation Search

·         Oracle Drop Partition

·         Oracle Drop Synonym

·         Oracle Drop Tablespace

·         Oracle Dual table tips

·         Oracle dynamic memory management tips - December 10, 2007

·         Oracle dynamic PL/SQL procedures

·         Oracle dynamic_sampling hint tips - December 4, 2007

·         Oracle eCommerce RAC usage

·         Oracle e-mail interface for Windows

·         Oracle enable row movement tips

·         Oracle ergonomics for online screens

·         Oracle error ORA-03114 tips

·         ORACLE error: unable to INSERT record tips September 21st, 2007

·         Oracle escape characters

·         Oracle estimate table join cardinality

·         Oracle excel spreadsheet examples

·         Oracle execution plan tips

·         Oracle execution plan tips

·         Oracle exp export syntax example

·         Oracle experts and Oracle professionals

·         Oracle exploit vulnerability allows privilege escalation

·         Oracle export 2 gig files

·         Oracle export performance tuning - December 13, 2008

·         Oracle export script for Windows

·         Oracle export tape tips - 6 January 2013

·         oracle export utility

·         Oracle export with Boolean logic variables

·         Oracle exports from Windows Scripts

·         Oracle extended RAC for geographical disaster recovery

·         Oracle External LOB BFILE Data types

·         Oracle External Table error and ORA-29913

·         Oracle Fail Safe

·         Oracle Fail Safe vs. RAC

·         Oracle features enabled but not licensed

·         Oracle feedback architecture

·         Oracle File Group Repository for versioning

·         Oracle first_rows vs all rows optimization - 31 December 2012

·         Oracle fix_corrupt_blocks - 29 April 2013

·         Oracle Flashback

·         Oracle Flashback Transaction Query

·         Oracle Flashback with "as of timestamp" SQL

·         Oracle Forms 6i DML Insert when button pressed trigger

·         Oracle Forums

·         Oracle function based indexes

·         Oracle Functions

·         Oracle Fundamentals - Ahmed Baraka

·         Oracle fusion - Hot or Not?

·         Oracle get list of tables - 6 October 2013

·         Oracle global temporary tables

·         Oracle Global Temporary Tables

·         Oracle Grid Control Server tips

·         Oracle Group By

·         Oracle hackers horror stories

·         Oracle hanganalyze trace files

·         Oracle hard-parse vs. soft parse

·         Oracle Hardware Scalability Testing

·         Oracle Hardware Upgrade Tips - November 15, 2007

·         oracle hash join

·         Oracle hash partitioned IOT & sub-optimal SQL

·         Oracle Having Clause

·         oracle health check

·         Oracle help screen demo software - screencasting

·         Oracle hidden memory manager PGA advice parameters

·         Oracle hidden olap parameters

·         Oracle hidden optimizer parameters

·         Oracle hidden parallel parameters

·         Oracle hidden sort parameters

·         Oracle hidden SQL subquery parameters

·         Oracle high resource SQL.

·         Oracle high water mark sessions

·         Oracle hints tips - December 4, 2007

·         Oracle Histograms

·         Oracle histograms for join predicates

·         Oracle hot backup scripts

·         Oracle HTML-DB: sending emails from multiple select LOV

·         Oracle I/O optimization on Sun Solaris

·         Oracle I/O Slave Waits dbwr parallel DML

·         Oracle I/O throughput scripts

·         Oracle IBM terabyte RAM benchmark

·         Oracle Idle Event list

·         Oracle ifile tips - 12 February 2014

·         Oracle Implementation

·         oracle import

·         Oracle import completed successfully message

·         Oracle Import Foreign Keys

·         Oracle in a laissez faire economy

·         Oracle Index Organized Tables ( IOT )

·         Oracle index rebuilding: rebuild indexes

·         Oracle Indexes

·         Oracle Initialization Parameters

·         Oracle INITRANS tips

·         oracle inline view

·         Oracle INSERT statement

·         Oracle insert tuning - October 25, 2007

·         Oracle INSTR

·         Oracle Instructors

·         Oracle Instrumentation Tips

·         Oracle Intermedia Install Failed with errors

·         Oracle Internals

·         Oracle interview questions

·         Oracle invalid Objects

·         Oracle Invalid Objects recompile

·         Oracle invalid or unusable indexes

·         Oracle Inventory tips - 12 July 2013

·         Oracle IOT vs. Single-table cluster

·         Oracle IP address history Tips -  11 March 2013

·         Oracle isnumeric test - 5 November 2012

·         Oracle Jargon Generator

·         Oracle Java

·         Oracle Java blob graphics retrieval

·         Oracle Java Methods

·         Oracle Java PL/SQL scripts

·         Oracle java.lang.OutOfMemoryError Tips

·         Oracle JDBC

·         Oracle job interview questions

·         Oracle JSQL, JDBC and JAVA

·         Oracle large object (LOB) support

·         Oracle large or small data files sizes?

·         Oracle leading vs. ordered hints

·         oracle left outer join

·         Oracle licensing Pricing

·         Oracle Linux - Using the "find" command to manage files

·         Oracle Linux DBA Benefits

·         Oracle Linux installation error Unable to load native library

·         Oracle Linux Open Source

·         Oracle Listener Security & passwords

·         Oracle listener.ora parameters tips - 10 February 2014

·         Oracle load balancing Tips -  9 March 2014

·         Oracle locally managed tablespaces

·         Oracle lock_sga parameter tips

·         Oracle Locking scripts

·         Oracle locking strategies - November 9, 2007

·         Oracle log buffer

·         Oracle log buffer sizing

·         Oracle logminer tips

·         oracle lsnrctl listener command

·         Oracle LTOM Lite Onboard Monitor

·         Oracle LTRIM

·         Oracle Magazine list

·         Oracle Materialized View refresh methods

·         Oracle Maximum datatypes Lengths

·         Oracle Memory Configuration

·         Oracle MetaBase Plus

·         Oracle Migration consulting support

·         Oracle Migration from Solaris to Linux

·         Oracle minimum downtime migration error tips - December 28, 2007

·         Oracle misspelled error messages

·         Oracle months_between tips

·         Oracle move datafile - 2 August 2013

·         Oracle MREADTIM and SREADTIM workload statistics - November 22, 2007

·         Oracle MTS - multithreaded shared servers

·         Oracle multiple row subquery tips - 29 January 2014

·         Oracle network service response file - 6 August 2013

·         Oracle next_day tips

·         Oracle NEXTVAL function

·         Oracle nls_lang tips

·         Oracle normalization

·         Oracle nosort index - 28 December 2012

·         Oracle not equals (!=) SQL operator

·         Oracle ntile example - 27 February 2014

·         Oracle num_rows in dba_tables

·         Oracle OAE Training Class

·         Oracle OCA practice tests

·         Oracle OCM certification tips

·         Oracle OCP Tips

·         Oracle ODBC Gateway Tips -  14 March 2014

·         Oracle OLAP dbms_aw_xml

·         Oracle OLAP dimensions & cubes

·         Oracle OLAP Hierarchical Tools

·         Oracle on the Internet

·         Oracle on Windows tips

·         Oracle on Windows Vista

·         Oracle online systems for data scrubbing

·         Oracle online table reorganization

·         Oracle OOAD Database Design Object Oriented

·         Oracle Open World 2004

·         Oracle OpenWorld 2004 top speakers & best sessions

·         Oracle opt_param SQL hint tips

·         Oracle Optimal Flexible Architecture (OFA)

·         Oracle optional features

·         Oracle ora_rowscn and the rowdependencies clause

·         Oracle ora-01031 tips

·         Oracle ORA-07445 exception tips

·         Oracle Orion tool

·         Oracle Outer Join Tips

·         Oracle pagination SQL tips

·         Oracle parallel DML

·         Oracle parallel DML: Deadlock Detected: ORA-00060

·         Oracle parallel query OPQ

·         Oracle parallel upgrade tips - 30 January 2014

·         Oracle parameters tips - 10 February 2014

·         Oracle Parse to Execute Ratio

·         Oracle Partition Key Statistics & tuning

·         Oracle partition SQL queries

·         oracle partitioning

·         Oracle partitioning and tables - partition-wise joins

·         Oracle Password Management - 4 March 2014

·         Oracle password protection tips - November 8, 2007

·         Oracle Password Security

·         Oracle password tips

·         Oracle passwords - changing, expiring and locking users

·         Oracle Peoplesoft Tuning

·         Oracle performance best practices

·         Oracle PHP programming tips

·         Oracle PL/SQL If Statements

·         Oracle PL/SQL select into clause

·         Oracle ports tips

·         Oracle predictions - Correlation vs. Causation

·         Oracle primary keys

·         Oracle processes high disk reads - 4 November 2012

·         Oracle production access control

·         Oracle professionals in high demand for 2008

·         oracle programming

·         Oracle query_rewrite_integrity and query_rewrite_enabled

·         Oracle RAC Architecture

·         Oracle RAC cluster fencing tips

·         Oracle RAC clusters for personal computers

·         Oracle RAC Configuration

·         Oracle RAC course

·         Oracle RAC Extended Distance Clusters

·         Oracle RAC File I/O Monitoring Scripts

·         Oracle RAC GCS Monitoring

·         Oracle RAC Hardware Compatibility - 26 August 2013

·         Oracle RAC Health Checks

·         Oracle RAC installation

·         Oracle RAC load balancing tips

·         Oracle RAC Monitoring

·         Oracle RAC on a Linux PC tips - December 29, 2007

·         Oracle RAC partitioning

·         Oracle RAC performance in STATSPACK & AWR reports

·         Oracle RAC review by Microsoft SQL Server

·         Oracle RAID

·         Oracle RAM shared memory errors

·         Oracle RBO and CBO for OLTP

·         Oracle RBO and CBO for OLTP2

·         Oracle reactive monitoring tools

·         Oracle read-only table tips - December 15, 2007

·         Oracle recovering dropped table DDL

·         Oracle recursive SQL and STATSPACK

·         Oracle Recycle Bin

·         Oracle redo allocation latch misses

·         Oracle refcursor tips

·         Oracle regression testing tips

·         Oracle regular expressions

·         Oracle Regular Expressions

·         Oracle Regular Expressions for date address and telephone number formats

·         Oracle Regular expressions indexes as a tuning tool

·         Oracle Regular Expressions with regexp_like parsing

·         Oracle releases and platforms

·         Oracle rename data file tips

·         Oracle rename table syntax

·         Oracle rename tablespace tips

·         Oracle Replication Conflict Resolution

·         Oracle Replication Tips - October 21, 2007

·         Oracle replication: ORA-23318: a DDL failure has occurred

·         Oracle resource profile tips

·         Oracle Results Sets   12-1-07

·         Oracle Resumable Space Allocation - November 1, 2007

·         Oracle Ring of Fire Conference

·         Oracle rman

·         Oracle RMAN backup strategies for very large databases - November 25, 2007

·         Oracle rman backups from Windows Script

·         Oracle RMAN Tips

·         Oracle RMAN vs. Export

·         Oracle Rollback Segments Min Extents

·         Oracle rolling upgrades

·         Oracle rootkits

·         Oracle round date function tips

·         Oracle row locks and row level locking

·         Oracle Row Re-sequencing

·         Oracle Ruby on Rails

·         Oracle Salary Compensation

·         Oracle SAVEPOINT

·         Oracle Schedule Automatic STATSPACK Data Collection

·         Oracle schema

·         Oracle schema change control

·         Oracle Schema Components

·         Oracle schema definition Tips - 9 November 2012

·         Oracle Schema Documentation

·         Oracle scripts for Windows

·         Oracle Secure Backup Utility

·         Oracle segmentation fault tips - November 17, 2007

·         oracle select from replication queue?

·         Oracle Select Statement

·         Oracle selective export with where clause exp expdp

·         Oracle sequence as default tips - 29 January 2014

·         Oracle sequence caching & performance

·         Oracle Sequences

·         Oracle server configuration

·         Oracle service_name tips - 25 February 2014

·         Oracle Sessions

·         Oracle SGA Sizing

·         Oracle shared memory parameters for UNIX/Linux

·         Oracle shared pool scripts

·         Oracle Shell Scripting Best Practices - December 26, 2007

·         oracle shutdown steps

·         Oracle Siebel Tuning

·         Oracle smart scan tips - 17 May 2012

·         Oracle Solaris parameters

·         Oracle Solid-State Disk RAM SAN

·         Oracle spends 1.8 billion on research & development in 2006

·         Oracle spfile

·         oracle spfile example

·         Oracle SQL - Find max values within a range of selected values

·         Oracle SQL - Find the current day of the week

·         Oracle SQL - Find the first day of a month

·         Oracle SQL "contains" clause tips

·         Oracle SQL "like clause" and index access

·         Oracle SQL causing high CPU tips - 29 January 2014

·         Oracle SQL cost-based optimizer parameter _like_with_bind_as_equality

·         Oracle SQL counting rows tips - 30 March 2014

·         Oracle SQL Developer

·         Oracle SQL execution statistics with SQL*Plus autotrace command

·         Oracle SQL Hints Tuning

·         Oracle SQL Injections Attacks

·         oracle SQL materialize undocumented hint

·         Oracle SQL Optimizer parameters

·         Oracle SQL performance with database links - dblink

·         oracle sql predicate

·         Oracle SQL Query - Rollup Analytical Function

·         Oracle SQL query rewriting with temporary tables

·         Oracle SQL subquery unnesting

·         Oracle SQL tips

·         Oracle SQL with multiple versions in the library cache

·         Oracle SQL*Loader commit point tips - October 27, 2007

·         Oracle SQL*Loader sqlldr Control File

·         Oracle SQL: displaying multiple columns per row

·         Oracle SQL99 WITH Clause

·         Oracle SQLERRM

·         Oracle standby database license requirements

·         Oracle standby reporting database

·         Oracle startup trigger tips - 24 March 2014

·         Oracle Statistics

·         oracle stats$sql_summary Table

·         Oracle Statspack Analyzer

·         Oracle STATSPACK Tips

·         Oracle Stored Procedures

·         Oracle Streams Benchmark Testing

·         Oracle Streams conflict resolution

·         Oracle Streams Replication Sequence Number Verification

·         Oracle Streams Schema replication

·         Oracle Sun Solaris Hardware

·         Oracle support for daylight savings time emergencies

·         Oracle Support Services

·         Oracle Synonyms

·         Oracle sys and system dictionary schemas

·         Oracle SYSDATE and Linux/UNIX date?

·         Oracle SYSDATE examples

·         Oracle System Events

·         Oracle System triggers

·         Oracle table dropped date tips - 31 January 2014

·         Oracle table hash clusters

·         Oracle Table I/O and buffer efficiency monitoring

·         Oracle table in SYSTEM tablespace tips - 10 February 2014

·         Oracle table last modified tips -  8 July 2013

·         Oracle table monitoring

·         Oracle table object wait statistics - v$segment_statistics

·         Oracle tablespace exports

·         Oracle tablespace Growth scripts - 4 November 2012

·         Oracle tablespace migrate from dictionary to local managed

·         Oracle tablespace script

·         Oracle tablespace uniform size extents

·         Oracle temporary tablespace groups

·         Oracle testing

·         Oracle testing to destruction

·         Oracle text index tips - 18 February 2014

·         Oracle third-party tuning tools

·         Oracle Times Ten data caching

·         Oracle Timestamp Elapsed Math

·         Oracle tkprof utility

·         Oracle TNS-12541 tips

·         Oracle tnsnames.ora parameters tips - 10 February 2014

·         Oracle tnsping command example

·         Oracle to_char SQL

·         Oracle to_date

·         Oracle tools tips

·         Oracle TPC Benchmarks QphH

·         Oracle Tracing of SQL*Net round trips

·         Oracle Training Cruises 2008

·         Oracle trending forecasting Signature Analysis

·         Oracle trunc tips

·         Oracle TRUNCATE

·         Oracle tuning as a life-or-death endeavor - October 29, 2007

·         Oracle tuning best practices

·         Oracle Tuning Consulting

·         Oracle tuning scripts

·         Oracle University Instructors

·         Oracle UNIX pipe command

·         Oracle UNIX split command export file 32-bit

·         Oracle UNIX to Linux Migration

·         Oracle Unrecoverable Datafile Tips

·         Oracle update optimal performance best practices

·         Oracle Update Statement Syntax

·         Oracle upgrade from 10.0.2 to 10.0.3

·         Oracle upgrade performance consulting

·         Oracle use with Solaris, Linux, AIX, HP/UX and Windows - October 22, 2007

·         Oracle User Group Sessions

·         Oracle user groups presentation - Ace your Oracle Job Interview

·         Oracle user groups presentation - Beyond Oracle10g – A look at the future of Oracle in the 21st Century

·         Oracle user groups presentation - Creating a self-tuning Oracle10g Database

·         Oracle user groups presentation - Ergonomics best practices for Oracle Developers

·         Oracle user groups presentation - Exception Reporting with the Oracle 10g Enterprise Manager

·         Oracle user groups presentation - Extending the Power of the Oracle 10g Automated Workload Repository

·         Oracle user groups presentation - For Managers Only – Secrets for hiring the best Oracle Professional

·         Oracle user groups presentation - Inside the Oracle 10g cost based SQL Optimizer

·         Oracle user groups presentation - Inside the Oracle10g Automatic Database Diagnostic Monitor

·         Oracle user groups presentation - Insider tips for Oracle Application Express (Apex HTML-DB)

·         Oracle user groups presentation - Is Oracle an Art, craft or a Science?

·         Oracle user groups presentation - Oracle DBA predictive modeling

·         Oracle user groups presentation - Oracle Quality Assurance Techniques

·         Oracle user groups presentation - Oracle SQL Tuning Secrets

·         Oracle user groups presentation - Oracle10g Privacy Security Auditing Techniques

·         Oracle user groups presentation - Oracle10g Wait Event Tuning with the Automated Session History Tables

·         Oracle user groups presentation - Predicting the benefit from an Oracle maintenance activity

·         Oracle user groups presentation - Scaling Oracle Application Express for large systems projects

·         Oracle user groups presentation - The Changing role of the Oracle Professional of the 21st Century

·         Oracle user groups presentation - Tuning Tips for Oracle Application Server 10g

·         Oracle user groups presentation - Understanding Interpersonal Relations in Oracle Technology

·         Oracle user script

·         Oracle utl_file Package

·         Oracle utl_smtp utility

·         oracle v$log_history

·         Oracle v$session user connections

·         Oracle validate structure command - 29 April 2013

·         Oracle Validated Configurations

·         oracle varray

·         Oracle Varrays

·         Oracle Veritas vxfs filesystem optimization

·         Oracle version control & change control tips

·         Oracle version control and change control?

·         Oracle version control tips

·         Oracle Virtual Private Databases VPD multiple policy values

·         Oracle vmware tips -  November 13, 2007

·         Oracle wait event scripts - 23 March 2014

·         Oracle waiting SQL -   27 April 2013

·         Oracle Warehouse Builder (OWB) vs. Manual data loading

·         Oracle webcast on Oracle Windows 64-bit

·         Oracle webcast on server consolidation

·         Oracle WHERE clause

·         Oracle Windows - changing the font in SQL*Plus

·         Oracle Windows alert log script

·         Oracle Windows external user authentication

·         Oracle Windows installer failure tips

·         Oracle Windows job scheduler tips -  30 April 2013

·         Oracle Windows Monitoring tips

·         Oracle Windows tips - October 21, 2007

·         Oracle Windows with multiple ORACLE_HOME registry values

·         Oracle WITH clause

·         Oracle with SAN NAS disks

·         Oracle workload analysis tips

·         Oracle Workspace Manager

·         Oracle Worst Practices

·         Oracle Wrap Utility

·         Oracle x$ tables

·         Oracle x$ksmlru and x$ksmsp for shared pool monitoring

·         Oracle XE Features - January 17, 2008

·         Oracle XLS Upload approaches

·         Oracle XML Schema Definition XSD

·         Oracle zombie process Tips - 10 January 2013

·         Oracle: bitmap conversion to rowid

·         Oracle: Coalesce vs. deallocate unused space

·         Oracle: convert BLOB to VARCHAR datatype - September 28, 2007

·         Oracle: disable flashback - October 27, 2007

·         Oracle: export procedures & triggers

·         Oracle: move tablespace datafile between filesystems

·         Oracle: restart OEM agent

·         oracle_10g_new_features  - Ahmed Baraka

·         oracle_maintained Tips -  23 July 2013

·         Oracle10g Release 2 10g Case insensitive searches

·         Oracle10g SQL*Trace Changes

·         Oracle8i hidden trace parameters

·         Oracle9i desupport date set for July 2007

·         oraclr_connection_data tips -  23 May 2012

·         oradim

·         orakill

·         OraVSSW.exe VSS tips -  28 March 2014

·         ordered Predicates hint Tips- 22 July 2013

·         Organizing Oracle Not-for-profit Functions

·         OS Busy script tips - 3 February 2014

·         OS commands for RAC

·         OUI-10151 During Install tips - October 17, 2007

·         overview of STATSPACK install scripts

·         Parallel query error ORA-12801

·         parallel_degree_level Tips - 20 July 2013

·         parallel_degree_limit_absolute Tips -  14 March 2014

·         Parallel_max_servers tips - 25 January 2013

·         parallel_min_time_threshold Tips  - 19 April 2013

·         Parsing with regular expressions regexp_like

·         Partitioning an Oracle table

·         Passing Parameters to PL/SQL Cursors - 13 July 2013

·         password_life_time tips - 4 March 2014

·         password_versions tips - 14 February 2014

·         Peoplesoft Configuration & Oracle Consulting

·         Personality assessment for business professionals

·         pga_aggregate_limit Tips

·         pga_aggregate_target

·         pivoting one row of several columns into one column of several rows

·         PL/SQL - Passing Large Data Structures with NOCOPY

·         PL/SQL accessible by - 1  November 2013

·         PL/SQL best practice Standards

·         PL/SQL best practice Standards

·         PL/SQL Capitalization Best Practices Standards

·         PL/SQL code alignment standards

·         PL/SQL Exception Tips - 8 November 2012

·         PL/SQL features by release

·         PL/SQL IF Statement syntax example

·         PL/SQL Indentation Standards

·         PL/SQL Named Notation Tips

·         PL/SQL NOCOPY Tips

·         PL/SQL NULL operator Tips -  23 May 2012

·         PL/SQL ORA-01008 : Not all variables bound

·         PL/SQL Package naming standards

·         PL/SQL parallel processing

·         PL/SQL Performance tips - October 18, 2007

·         PL/SQL Programming Design Standards

·         PL/SQL recursive calls: recursion in Oracle

·         PL/SQL ref cursor tips

·         PL/SQL Spacing Standards

·         PL/SQL Statements Per Line

·         PL/SQL Trigger naming standards

·         PL/SQL variable naming standards

·         plan_table is old version fix -  23 May 2012

·         plan9i.sql script

·         PLS-00201: identifier ‘DBSNMP.BSLN_INTERNAL’ must be declared - 5 November 2012

·         PLS-00310 Tips - 22 April 2013

·         PLS-00903 tips - 4 April 2014

·         plsql_optimize_level

·         Pluggable databases Backup and Recovery Tips - 15 March 2014

·         Poor Oracle performance after 64-bit server migration

·         Poor Quality, Diploma Mill MBA Schools

·         Port number of OEM? -  3 February 2013

·         Praetoriate Oracle Tips

·         Pragma serially_reusable

·         Predict table and index full-scan activity

·         Preliminaries – Before You Enable the 10046 Event

·         Preventing table DDL

·         Privacy concerns with Oracle Configuration Manager - October 27, 2007

·         Privileges granted to a directory tips  - 2 February 2014

·         processor_group_name - 26 June 2013

·         professional golf etiquette for IT professionals

·         Public Synonyms Tips- 5 May 2013

·         Purge Oracle Recyclebin

·         Purging AWR statistics from Oracle  - 15 January 2013

·         Pursuing a career in Oracle Medical Informatics

·         Query level change notification Tips - 16 April 2013

·         RAC and Oracle data warehouse

·         RAC clusters for laptop computers

·         RAC GES Monitoring

·         RAC hardware requirements - 29 January 2014

·         RAC on Windows Tips - 28 February 2014

·         RAID5 acceptable for Oracle databases

·         RAISE_APPLICATION_ERROR tips - 4 March 2014

·         RAM used by Oracle user - 7 November 2012

·         RAM used by session Tips - 7 November 2012

·         RAM used by SQL Query Tips - 7 November 2012

·         Read Excel file from PL/SQL - 27 March 2014

·         read file tips - 30 June 2013

·         read only oracle database tips - 24 March 2014

·         Reading a STATSPACK report

·         Reading SQL 10053 trace files

·         Reading the XML alert log -  23 April 2013

·         Read-only OEM Tips - 16 June 2013

·         Real Time SQL Monitoring tips - January 8, 2008

·         Real-time web server traffic monitors - Live statistics

·         Reclaiming Oracle disk space

·         Recommended Oracle job scheduling book

·         Recover a dropped table in Oracle

·         Recover Oracle database Tips - 4 November 2012

·         redef_table tips

·         Redo log switching tips - 3 February 2014

·         Reducing undotbs01.dbf tips - October 19, 2007

·         ref cursor tips - 17 February 2014

·         Refresh test database from production schema

·         Refreshing an Oracle Materialized View

·         regr_slope tips - 30 March 2014

·         Regular Expressions and Oracle Performance function based indexes

·         Regular expressions for parsing-out substrings from larger strings

·         Relationship between instance_name, ORACLE_SID and service_name

·         Remote Oracle Support

·         Remove AWR snapshot tips - 17 September 2013

·         remove AWR tips - 15 July 2013

·         Remove Oracle table row lock - 7 May 2013

·         Removing Archive Log files from Enterprise Manager September 18th, 2007

·         removing expensive "merge join cartesian"

·         Removing like breaks from Oracle column data

·         Removing sensitive Oracle data

·         Rename data files on Data Guard Standby - 15 June 2013

·         Rename Oracle index tips - 26 February 2014

·         Renaming files from inside PL/SQL

·         Reorganization with "alter table xxx move" syntax

·         Reorganize a partitioned table tips - 3 April 2014

·         REP-50127: File cannot be written to tips - 3 March 2014

·         Repair Corrupt Blocks in RMAN - 28 February 2014

·         repair corruption with UNDO tablespace

·         report_sql_monitor tips - 6 April 2014

·         Republishing a libel & internet censoring

·         resmgr:cpu quantum Tips - 8 November 2012

·         Resolving host names with DNS for Oracle

·         Resolving ORA-12705: Cannot access NLS data files or invalid environment specified

·         Resolving the ORA-12705 error

·         response time monitoring

·         Restore Oracle Database tips - 10 February 2014

·         reverse key indexes

·         Rewriting Oracle SQL MINUS operator with a NOT IN subquery tips - 8 April 2014

·         Rittman OWB articles

·         RMAN and ORA-12545 -  4 October 2013

·         RMAN backup location tips - 24 March 2014

·         RMAN CATALOG vs. NOCATALOG Mode? - 22 March 2013

·         RMAN causes ORA-01031 tips - 26 March 2014

·         RMAN cold backup tips - 12 February 2014

·         RMAN delete archived redo log files -  30 May 2012

·         RMAN duplexing Tips - 23 March 2014

·         RMAN duplicate database Tips - 5 May 2013

·         RMAN large pool PGA RAM tips

·         RMAN noopen Tips - 16 March 2014

·         RMAN recover table Tips - 16 March 2014

·         RMAN Tablespace Report example  - 17 May 2012

·         RMAN troubleshooting tips - 27 March 2014

·         RMAN tuning Tips - 4 November 2012

·         RMAN vs. EBU Features - 8 November 2012

·         RMAN-03009: failure of backup command

·         RMOUG 2006 Conference speaker evaluations

·         row cache hit ratio Tips - 22 March 2013

·         row resequencing webcast

·         rows per second Oracle throughput Tips -  21 November 2012

·         rules for internet journalists

·         Run Oracle export script from Windows DOS - 28 April 2013

·         Run SQL*Plus script from DOS - 28 April 2013

·         sample login file for Oracle UNIX/Linux - 28 April 2013

·         Sample STATSPACK (AWR) Analysis

·         Sample Table Scans and Oracle Dynamic Sampling

·         SAP Oracle Configuration Consulting

·         SAP Oracle Tuning

·