Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New 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

                              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 databases 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 partner with Rampant TechPress, a leading publisher of Oracle books.  If you want to publish an article or book, please call or e-mail BC today.

Oracle Article Index:

 

Test Article Page - 26 August 2019

v$archived_log applied - 3 May 2017

v$archived_log applied - 3 May 2017

v$archived_log applied - 3 May 2017

shrink UNDO logs - 28 May 2017

approx_count_distinct - 25 May 2017

filesystem_like_logging - 22 May 2017

v$archived_log applied - 3 May 2017

allow_group_access_to_sga - 3 May 2017

ORA-19698 - 2 May 2017

RAC master node - 25 Apr 2017

ORA-00259 - 25 Apr 2017

Oracle maximum sessionse - 25 Apr 2017

LOB retention clause - 10 Apr 2017

reclaim space after LOB deleted/updated - 7 Apr 2017

sqlplus histpry command - 4 Apr 2017

nls_characterset - 04 Apr 2017

Drop partition based on date - 28 Mar 2017

Copy clone Oracle software - 19 Jan 2017

ORA-01804 failure timezone dat - 20 March 2017

12.2. band join - 10 March 2017

_rowsource_execution_statistics -

Testing Oracle passwords - 27 Jan 2017

v$_lgwrio_outlier -19 Jan 2017

Open PDF stored in Oracle file column - 19 Jan 2017

Create index with small temp tablespace - 24 Dec 2016

ORA-01018 - 20 Dec 2016

display high water marks - 10 June 2016

execute SQL from PL/SQL using host crediential - 7 January 2017

when Oracle user password was changed - 7 January 2017

compare CPU processing speed - 29 July 2016

global enququque services - 6 Nov 2016

alter table add column default value - 30 September 2016

RAM bound server - 30 August 2016

back and forth server failover - 6 August 2016

compare CPU processing speed - 29 July 2016

get AWR report during peak CPU - 27 July 2016

Get server excess capacity - 27 July 2016

alternatives to Oracle WebLogic - 26 July 2016

Oracle licensing and virtualization - 24 July 2016

AWR vs. STATSPACK - 7 July 2016

ORA-48210 - 28 June 2016

real application testing (RAT) features - 24 June 2016

Oracle diagnostic pack features - 24 June 2016

Oracle Tuning Pack Components - 24 June 2016

deploy ebusiness suite plugin - 19 June 2016

install application management suite - 19 June 2016

install EM CLI - 19 June 2016

download application management suite - 19 June 2016

cpu_count and number of cores - 16 June 2016

display 12c features used - 16 June 2016

display SQL Tuning Pack - 14 June 2016

detect spatial installed - 14 June 2016

detect data mining used - 14 June 2016

detect OLAP used and installed - 14 June 2016

detect partitioning used and installed - 14 June 2016

detect function-based indexes - 14 June 2016

display MTS shared servers - 10 June 2016

display high water marks - 10 June 2016

detect RAM used - 9 June 2016

detect RAM and CPU - 9 June 2016

survey unknown database - 9 June 2016

detect flashback used - 9 June 2016

detect AWR used - 9 June 2016

detect bitmap index used - 9 June 2016

detect data mining used - 9 June 2016

detect OLAP used - 8 June 2016

drop and re-create AWR tables - 7 June 2016

ORA-13509 - 7 June 2016

FRA full with ORA-12154 - 7 June 2016

manually create pdb - 7 June 2016

Create pdb ORA-01927 - 7 June 2016 _

manualy create cdb - 7 June 2016

SQL Tuning Advisor using command line - 5 June 2016

existsnode - 5 June 2016

install cloud control virtualbox - 5 June 2016

updatexml - 5 June 2016

deletexml - 5 June 2016

appendchildxml - 5 June 2016

xmltable - 5 June 2016

check redo log writing - 5 June 2016

log_file_name_convert - 4 June 2016

v$filespace_usage - 3 June 2016

PLS-00337 - 2 June 2016

xmlconcat - 1 June 2016

xmlagg - 1 June 2016

ORA-01006 - 1 June 2016

_smu_debug_mode - 31 May 2016

log_archive_min_succeed_dest - 31 May 2016

mirror archived redo log files - 31 May 2016

xmlforest - 31 May 2016

no more data to read from socket - 29 May 2016

powermultiset_by_cardinality - 29 May 2016

script to find EE features - 29 May 2016

xmlattribute - 29 May 2016

mgmt_targets mgmt_collections - 29 May 2016

utl_raw cast_to_raw - 28 May 2016

sql*loader 28 error - 28 May 2016

data load testing - 27 May 2016

low downtime recovery - 26 May 2016

XMLELEMENT - 26 May 2016

XMLTYPE - 26 May 2016

XML programming - 26 May 2016

find fragmented tables - 26 May 2016

ORA-16664 - 26 May 2016

_gc_policy_time - 25 May 2016

DIA-48447 - 25 May 2016

regexp_replace - 25 May 2016

regexp_substr - 25 May 2016

regexp_instr - 25 May 2016

inline hint - 25 May 2016

ORA-06564 - 24 May 2016

global_temp_table_stats - 24 May 2016

AWR report DB Tme - 24 May 2016

store emoticonas in table - 24 May 2016

ORA-04023 - 23 May 2016

display first weekday of month - 22 May 2016

qb_name hint - 22 May 2016

ORA-04072 - 22 May 2016

RMAN-06617 - 22 May 2016

Oracle CTE - 21 May 2016

enq: ko - fast object checkpoint - 21 May 2016

dbms_metadata_diff - 20 May 2016

nls_length_semantics - 20 May 2016

_adaptive_scalable_log_writer parms - 20 May 2016

ORA-56901 - 19 May 2016

sqlplus null value - 19 May 2016

RMAN backup report - 19 May 2016

deferrable constraints - 18 May 2016

13c create assertion - 18 May 2016

ORA-54013 - 18 May 2016

the no_nlj_batching hint - 17 May 2016

RMAN tablespace restore - 15 May 2016

recover single table using RMAN - 17 May 2016

dispay high impact DML activity tables - 17 May 2016

RMAN-20260 - 17 May 2016

ORA-03137 - 16 May 2016

check data type - 15 May 2016

ORA-24130 - 16 May 2016

ORA-30009 - 16 May 2016

ORA-15124 - 16 May 2016

display triggers for a table - 15 May 2016

get_dependent_ddl - 15 May 2016

display all foreign keys for tables - 15 May 2016

OS error OS 33 - 15 May 2016

listener_networks - 15 May 2016

find table in many databases - 15 May 2016

ORA-28544 - 14 May 2016

monitor archived redo log directory - 14 May 2016

PLS-00382 - 13 May 2016

ORA-32034 - 13 May 2016

 


   

Click here for Burleson reader comments.

 


 

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 Oracle Press (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.

 

 

 

 

   

   Supplemental links

  

 
Burleson Oracle Consulting also has a vast network of Oracle consulting contacts and we can supply Oracle professionals for all Oracle projects, from short Oracle engagements to large-scale Oracle projects. BC only employs consultants with extensive experience and knowledge.DO NOT CHANGE ANYTHING BELOW HERE

 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

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

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

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

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

 

trezor app ensures the safety and efficiency of your crypto journey, providing a reliable platform for managing digital wealth.