 |
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 |
|
|
|
Oracle
Articles and RSS Feeds |
|

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:
 |
Burleson Humor
& Opinion Articles:
For more opinionated nonsense,
see the
Don Burleson Blog! |
|
-
Fake Indian pan
flute bands invade America & Europe! - October 20, 2008
-
Trapping wild
Coyotes - January 12, 2008
-
Dangerous Dilettantes Destroy
Databases - September 28, 2007
-
Evaluating personal history for moral turpitude
- September
29, 2007
-
Government licenses for computer professionals? -
September
30, 2007
-
Inside Oracle Sorting
-
October 15, 2007
-
Have
decompilers become evil? - July 2007
-
Old
Southern sayings - June 2007
-
Does familiarity breed contempt?
- June 2007
-
Intellectual
Property Rights in a Global Market - June 2007
-
Using Google as a back-end semantic database
- May 6, 2007
-
Inside the human revulsion
instinct - March 17, 2007
-
Google
commands become the most popular Web integration glue
-
Getting Credibility for Wikipedia
- February 2007
-
Tips for finishing your own
rough cut hardwood Oak - February 2007
-
Finishing your own Walnut lumber - November 20, 2007
-
There's no such thing
as a impenetrable question? - January 2007
-
The Billionaire next door -
December 2006
-
Inappropriate
corporate sponsorship of charities - December 2006
-
Are you a "Man of the Year"? - October 2006
-
Executive
Perks for IT Professionals - September 2006
-
Could Google control the
Internet? - August 2006
-
Meteor strikes can kill? - July 2006
-
Are hacker
guides illegal? - July 2006
-
Is Bad Customer Service
Good? - July 2006
-
Burleson Consulting Travel Tips - June 2006
-
DNA testing reveals racial groups
- May 2006
-
Deal or No Deal Probabilities - April
2006
-
Do All Oracle Professional think alike?
- November 2005
-
Christmas shopping on eBay - October 2005
-
Products that I buy for others - May
2005
-
What do you collect? - May 2005
-
Animal Manners - May 2005
-
New Virus detected - April 1, 2004
-
OK, what is this thing, and is it alive? - March 2004
-
Understanding Redneck Theology - March 2004
-
Oracle - What's in a name? - July 2003
-
Don't steal someone's
affection! - December 2006
-
Increased earning income from bachelors, masters and doctoral (PhD) degrees
- December 2006
-
The "Yes Men" and Reburgering - June
2005
-
Freedom of Speech vs. resources
for criminals - June 2005
-
Anthropomorphism in Marketing
- June 2005
-
Fake Military Heroes
plague America - June 2005
-
Business professionals
attend auctioneering school - May 2005
 |
 |
Sports Tips
 |
|
Burleson Consulting Oracle Articles
BC Oracle articles dating from 1999 |
-
Finding
database geniuses - May 1, 2008
-
Don't let script kiddies play with Silver
Bullets! - September 2007
-
Oracle 11g Database Management for Business Intelligence
-
Inside the 11g
SQL Performance Advisor - September 2007
-
Oracle 11g Data Compression Tips for the Database
Administrator
-
Oracle 11g
function-based virtual columns
-
Protecting your Oracle
data against theft - May 2007
-
Becoming an IT consultant
- May 2007
-
How to become an Oracle DBA
- September 2006
-
Oracle Biometrics Security -
December 2005
-
Oracle PGA pga_max_size
undocumented parameter - SearchOracle - August 2005
-
MetaBase
scripting for the Oracle data warehouse DBA - SearchOracle, July 6, 2005
-
How to be a successful
computer professional - May 2005
-
Evaluating Oracle credibility on the web
- SearchOracle - April 2005
-
Oracle10g SQL
Time-series Tuning - DBAZine - February 2005
-
Oracle 10g AWR SQL Tuning -
OraFAQ - February 2005
-
Inside Oracle 10g
dynamic sampling - DBAZine - January 2005
-
Can you have too much cache?
- OraFAQ - December 2004
-
Oracle 10g data
warehousing - DBAZine - November 2004
-
Database Auditing for Risk Management
and Regulatory Compliance - Lumigent - November 2004
-
Oracle features -
Standard vs. enterprise edition - SearchOracle - November 2004
-
Oracle first_rows
optimization improvements - OraFAQ - November 2004
-
Oracle 2020: A Glimpse into the Future of
Database Management, Part 2 - DBAZine - Oct 2004
-
Oracle 2020: A Glimpse into the Future of
Database Management, Part 1 - DBAZine - Oct 2004
-
The new Oracle10g Wait Event Tables
- OraFAQ - Oct 2004
-
Oracle tuning: Blocksize and index tree
structures - SearchOracle - September 2004
-
Extending Oracle10g AWR scripts -
OraFAQ - September 2004
-
Optimizer index caching -
SearchOracle - September 2004
-
Oracle Tuning Fallacies -
SearchOracle - September 2004
-
Busting the Oracle Myth Busters
- DBAZine.com - September 2004
-
成本控制:Oracle 优化器内幕,第 2 部分
-
自动调整 Oracle9i
Database:Oracle SGA
-
STATSPACK을 이용한 오라클 데이타베이스
트랜드 분석
-
STATSPACK을
이용한
오라클
데이타베이스
트렌드
분석
- Oracle 优化器内幕,第
2 部分(续
- Настольная
книга по администрированию
- Автонастройка базы данных Oracle 10g:
- Russian
RAM paging
- Источник: сайт
Дональда Бурлесона, статья
- Основная
таблица хранилища данных для Oracle8i
- 自调整 Oracle9i
Database:Oracle SGA(续)
- I/O 대기 시간 분석을
통한 성능 향상
-
Product Review -
SQL*XL - OraFAQ - August 2004
-
Oracle SQL tuning for
full-table scans - OraFAQ - July 2004
-
Inside the Oracle Buffer
Cache - SearchOracle - July 2004
-
Common Oracle Recovery Mistakes
- OraFAQ - July 2004
-
Always use direct I/O with Oracle
- OraFAQ - June 2004
-
Oracle Database Server
Consolidation - DBAZine - June 2004
-
Improved 10g management with EM - Orafaq -
May 2004
-
New Oracle10g SQL optimizer hints
- Builder.com - April 26, 2004
-
Unconventional Oracle tuning techniques
- OraFAQ - April 1, 2004
-
Measuring Oracle disk I/O speed
- Builder.com - March 1, 2004
-
Optimizing Oracle optimizer
statistics - OraFAQ - March 1, 2004
-
Oracle 911 Emergency Support -
DBAZine - February 26, 2004
-
Database Optimization:
Determine if the 64-bit architecture is right for your database - Builder.com - February 23, 2004
-
Auditing and reporting Oracle user
activity - Builder.com - February 9, 2004
-
Oracle Disk Management
- DBAZine -
February 3, 2004
-
Oracle Optimization - Tuning 3rd party
vendor systems - Builder.com - February 2, 2004
-
Oracle Data Loading Tips -
OraFAQ - February 2004
-
Oracle parameter tuning -
OraFAQ - January 2004
-
Tweaking Oracle SQL Parameters
- Builder.com - Jan 26, 2003
-
Oracle replication tuning
-
Builder.com - January 8, 2004
-
Create a management environment for
developing Oracle SQL - Builder.com - December 29, 2003
-
Optimizing Oracle*Net Configuration
- Builder.com - December 16, 2003
-
Don Burleson's favorite Oracle10g
features - SearchOracle - December 5, 2003
-
Использование средств автоматической
настройки баз данных Oracle9i
-
Oracle Buffer Busy Waits
-
Builder.com - December 9, 2003
-
Use Oracle referential integrity to
enforce business rules - Builder.com - December 2, 2003
-
Inside Oracle indexing
-
DBAZine, December 2003
-
Optimize your Oracle Network Parameters
(sdu tdu mtu) - Builder.com - November 18, 2003
-
Extend STATSPACK for disk I/O
- Builder.com - November 11, 2003
-
Oracle SQL tuning with column
histograms - Builder.com - October 31, 2003
-
Optimize Oracle SQL by
understanding clustering_factor - Builder.com - October 27, 2003
-
What to expect when you migrate to
Oracle9i - Builder.com - October 12, 2003
-
CEO Ellison reveals the Oracle10g vision
of enterprise grid computing - Builder.com - October 10, 2003
-
Oracle Undocumented Parameters - Part
2 - SearchOracle - October 10, 2003
-
Using Hidden Oracle Utilities - Part
1 - SearchOracle - 18 September, 2003
-
Audit design with Oracle
fine-grained auditing - Builder.com - September 22, 2003
-
Ellison's vision of Oracle10g -
DBAZine - September 26, 2003
-
Choose the proper
Oracle design for auditing - Builder.com - September 8, 2003
-
Hoe werkt de bitmap join index -
September 2003
-
Auto-Tuning
Oracle Database 10g: Oracle SGA - OTN - September 6, 2003
-
Track CPU and I/O cost with Oracle9i
-Builder.com - September 2, 2003
-
System Validation & Estimation - From Physical
Database Design
-
Expert offers tips on Oracle
Security - SearchOracle.com - July 15, 2003
-
Establish security policy with Oracle virtual
private database - Builder.com - August 25, 2003
-
虚拟私有数据库
- ZDNet China
-
Achieve faster SQL performance with
dbms_stats - Builder.com - August 19, 2003
-
Is your Oracle system compliant with Federal
Law? - SELECT Journal, 2003
-
Achieve better control with
Oracle's grant execute security model - Builder.com - August 13,2003
-
Get Oracle schema syntax the easy
way - Builder.com - August 5, 2003
-
让我们进一步看看CPU的数量是如何 - ZDNET -
China
-
成本控制:Oracle
优化器内幕,第 2 部分
- OTN - July 2003
-
Cost control - Inside the Oracle Optimizer -
OTN - July 2003
-
Oracle Dynamic Grid computing -
DBAZine.com - July 2003
-
Control Access with Oracle grant Security
- Builder.com - July 28, 2003
-
A four-phase approach to procedural
multimaster replication - DBAZine
-
Oracle Linux vs. Oracle Windows -
July 22, 2003
-
Oracle Design Security from the ground-up
- Builder.com - July 14, 2003
-
Use multiple CPU with Oracle Parallel Query
- Builder.com - July 9, 2003
-
Oracle blocksize and index tree structures
- DBAZine
-
Burleson Webcast -
Introduction to Oracle Tuning - DBAZine - June 10, 2003
-
Book sheds light on performance tuning in Oracle9i - Builder.com - May 2003
-
Analyzing real-time
physical I/O waits - OTN - May 2003
-
Check the efficiency of Oracle caching with
this report (v$bh) - Builder.com - April 22, 2003
-
Oracle9i Data Security Internals -
DBAZine.com - April 2003
-
How to get an Oracle DBA job - searchDatabase.com - April 09, 2003
-
Tweak
Oracle data buffer parameters to cache entire databases - Builder.com -
April 8th,, 2003
-
Three
ways to speed up SQL execution in Oracle - Builder.com - March 25, 2003
-
Introducing Database Area Networks - DBAZine -
March 17, 2003
-
Proactively monitor Oracle9i performance via
scripts and queries - Builder.com - March 11, 2003
-
How Oracle9i supports dynamic reconfiguration
- Builder.com - Feb 25, 2003
-
结论. Oracle materialized
view的引入大大改善了处理复杂SQL - ZDNET China
-
Inside Oracle9i Tablespace Management -
DBAZine - February 20, 2003
-
Boost Oracle Performance with Intelligent
optimizer parameters - Builder.com - Feb 11, 2003
-
An Enterprise Security Primer - DBAZine
- Jan 23, 2003
-
Oracle9i's ASSM
improves segment storage internals - Builder.com - Jan 13, 2003
-
Using Oracle9i to Create Custom Web
Content - DBAZine - January 8th, 2003
-
Space management in Oracle9i - TechProGuild
- Dec 26, 2002
-
Webinar - Oracle Expert Tuning Tips - Searchdatabase.com - Dec 14, 2002
-
Oracle9i index full scans -
Builder.com - Nov 25, 2002
-
Oracle9i parameters reduce downtime -
TechProGuild - Nov 25, 2002
-
Using Oracle9i cache advice -
Builder.com - November 18, 2002
-
Steps you can take to optimizer your Oracle
server - TechProGuild - November 18, 2002
-
How to use Oracle9i bitmap join
indexes - Builder.com - November 12, 2002
-
Optimizing Oracle RAM usage - DBAZine -
November 2002
-
Oracle Web Hacker Tricks - Oracle Internals
-
Auditing Oracle9i security - Oracle Internals
-
Self-tuning in Oracle9i - Searchdatabase Webcast
-
Using Oracle9i RAC and TAF for continuous availability - Searchdatabase
Webcast
-
Oracle9i provides enhanced views into RAM
usage - Builder.com - October 18, 2002
-
Oracle Wait Analysis Techniques - DBAZine
- October 2002
-
Creating tablespaces with multiple blocksizes
- Builder.com - September 23, 2002
-
Lock down database security for web-enabled
apps - Builder.com, September 20, 2002
-
Dynamic adjustment of the Oracle9i SGA -
Builder.com, September 16, 2002
-
Measure Oracle database server performance with
vmstat - Tech Pro Guild - September 16, 2002
-
Tablespace creation is a snap with Oracle Managed
Files - Builder.com - September 5, 2002
-
Extending Oracle for system event
auditing - DBAZine - September 2002
-
Introducing DAN - A New Database Architecture -
Builder.com, August 13, 2002
-
Oracle9i Scalar subqueries simplify complex
SQL - TechRepublic, Aug 13, 2002
-
Database Benchmark Wars: What you need to know
- TechRepublic, Aug 8, 2002
-
Oracle9i Simplifies SQL Syntax -TechRepublic
- Aug 2, 2002
-
Oracle Expert Tuning Secrets - Part
2 - DBAZine, July, 2002
-
Using Spreadsheets as Oracle Tables
- TechRepublic - July 22, 2002
-
Accessing Flat Files with Oracle SQL -
TechRepublic - July 1, 2002
-
Oracle Expert Tuning Secrets -
DBAZine, June, 2002
-
Cleaning house - Tips for firing IT personnel -
May 16, 2002
-
Leveraging your IT skills in a tough job
market - May 16, 2002
-
Becoming an IT Management Superstar - May
16, 2002
-
Costs and Benefits for High Availability
Oracle9i - DBAzine, May, 2002
-
Real 24/7 - Using Oracle9i RAF and TAF to
guarantee availability - Oracle Magazine - May/June 2002
-
Four
questions you should ask a DBA job candidate - TechRepublic, April 30, 2002
-
Oracle9i Data Model Extensions -
TechRepublic - April 24, 2002
-
Oracle认证的专家之见(第二部分)- ZDNet China
-
の検索結果… 売れている順, 価格の高い順,
価格の安い順, 発売日最新順, 商品名昇順, 商品名降順
-
OracleハイパフォーマンスチューニングSQL編
[商品詳細]
-
An insider's guide to Oracle certification -
Part 2
- TechRepublic - April 19, 2002
-
Configuring your Oracle9i database for Materialized
Views - TechRepublic - April 9, 2002
-
Oracle architectural design tips offered - ZDNET - Australia - April 8, 2002
-
Oracle Architectural Design Tips
-
TechRepublic -April 5, 2002
-
Dynamically create
complex objects with Oracle materialized views - TechRepublic - April
2, 2002
-
An insider's guide to Oracle certification
- TechRepublic - March 29, 2002
-
Turbocharge SQL with advanced Oracle9i indexing
- TechRepublic - March 26, 2002
-
Migrating from Windows to UNIX - TechRepublic
- March 25, 2002
-
Using Oracle9i
Real Application Clusters for Continuous Availability
- DBAzine - March 2002
-
Data structure denormalization in Oracle9i
- TechRepublic - March 19, 2002
-
Cost
factors driving highly available systems - TechRepublic - March 2002
-
Techniques for
increasing Oracle scalability - TechRepublic - March 2002
-
Oracle RAC: The answer for continuous availability? -
TechRepublic - March 2002
-
Self Tuning in Oracle9i
- A Webinar by SearchDatabase.com - February 2002
-
Take steps to
Retain your IT Superstars - TechRepublic - February, 2002
-
Using
Multiple Block Sizes in Oracle9i - DBAzine - February, 2002
-
Using the
Dynamic SGA Features of Oracle9i - DBAzine - February, 2002
-
Guard against
performance issues when using Oracle hints and views - TechRepublic -
January, 2002
-
An insiders view of selecting an ERP Vendor
- TechRepublic - September, 2001
-
Four Factors that shape the cost of ERP -
TechRepublic - August, 2001
-
Selecting an ERP System: Build or Buy -
TechRepublic - August, 2001
-
Managing Web Development in Oracle -
TechRepublic - August, 2001
-
Oracle Tuning: Tuning individual SQL statements
- TechRepublic - May 2001
-
Oracle tuning:
Working with individual objects - TechRepublic - April 2001
-
What is your Oracle SQL Optimizer
Philosophy? - TechRepublic - April 2001
-
Remote DBA Offers an attractive outsourcing option
- TechRepublic - April, 2001
-
Using STATSPACK to
monitor Oracle performance - TechRepublic - April, 2001
-
Boost performance by tweaking global instance parameters
- TechRepublic - March, 2001
-
Oracle Tuning - Examining the Oracle
Instance - TechRepublic - March, 2001
-
Oracle Tuning - Monitoring hardware with UNIX tools
- TechRepublic - March, 2001
-
Oracle Tuning - Start by looking at
the big picture
- TechRepublic - February 2001
-
Optimizing e-commerce database
systems using parallel Oracle
- TechRepublic - February 2001
-
Using parallel Oracle for high-speed e-commerce
systems - TechRepublic - February 2002
-
Hierarchical Attribute Design for an Oracle8i
Warehouse - TechRepublic - January 2001
-
Reorganizacja tabel w bazach
danych Oracle w celu przyspieszenia
dyskowych operacji wejscia / wyjscia
- Javasoft.pl, sroda, 7 lutego, 2001
-
Organizing classification attributes for
Oracle8i data warehouses - TechRepublic - January 2001
-
What's new in Oracle9i?
- TechRepublic - December 2000
-
Oracle9i offers some interesting enhancements
- TechRepublic - December 2000
-
Taking Advantage of Object Partitioning in Oracle8i
- TechRepublic - November 2000
-
Oracle Database Trend Analysis Using
STATSPACK - Oracle Magazine - November/December, 2000
-
Mining Gold from the Library
- Oracle
Magazine - November/December, 2000
-
The Object-Relational Features of Oracle8 -
TechRepublic - October, 2000
-
Faster Performance Using Oracle8 Stored
Procedures - SELECT Magazine, October, 2000
-
Setting PCTFREE and PCTUSED based on Average Row
Length - SELECT Magazine, June, 2000
-
Get acquainted with Oracle's Certified Professional
Program - TechRepublic - May, 2000
-
Speed Oracle database queries with parallel features
- TechRepublic - January, 2000
-
Kick it up a notch! Faster Oracle queries using
parallel features - TechRepublic - January, 2000
-
Turning the Tables on Disk I/O -
Oracle
Magazine - January, 2000
-
Tuning Disk I/O in Oracle8 - Oracle
Magazine - November, 1999
-
Automating Oracle Tuning
- Oracle Magazine - July,
1996
-
Tips for Using Oracle Stored Procedures
- Oracle Magazine - May 1996
-
Identifying which Indexes to Rebuild
- Embarcadero - July 1999
-
How Oracle 8 Will Change Your Life - OReview
Magazine - March, 1997
-
Developing Effective Oracle Data Warehouse and OLAP
Applications - OReview Magazine - July, 1996
-
Using SQL*Net in a Distributed Database Environment
- Oreview Magazine - April, 1996
-
Patrol Version 3.0.15 - DBMS Magazine -
April, 1996
-
Object-Oriented Primer: An Oracle8 Preview - Oreview
Magazine - November, 1996
-
Legacy bumps slow trip to
relational - Software Magazine, March 1995
-
Objects, Objects, Everywhere - Computerworld
Magazine - March, 1994
-
Can you cope? - Computerworld Magazine - February,
1994
-
Neophytes - Computerworld Magazine -
February, 1994
-
Design and Implementation of a Decision
Support System for Academic Scheduling - Information & Management -
September 1986
-
Measuring Oracle
Segment I/O - DBAZine - John Weeg
-
Datafile Resizing Tips
- DBAZine - John Weeg
-
Measuring
Data Segment Statistics - DBAZINE - Arup Nanda
-
Optimizing
Oracle Physical Design - DBAZine - Dave Ensor
 |
|
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
|
-
OLAP query equivalence
-
Oracle10g Rewrite_or_Error
Hint
-
SQL Access Advisor
- Bjørn Engsig On Bind Variables, Cursor Sharing
And Oracle 9i - June 2004
- Naeem Hashmi On Embedding Real-Time
Analytics - June 2004
- Richard Byrom's Oracle Applications Blog
- June 2004
-
Integrating Mapping and
Spatial Data
- Oracle ETL with pipelined table
functions
- Using External Tables
- Oracle Merge Command
-
Data Warehouse Builder
-
Web Services, BPEL
And Oracle Data Warehousing
-
OWB 10g Now Available For
Windows
- Using HTMLDB For Oracle Reporting
-
Integrating Web
Services With Oracle BI Beans
-
Having Discoverer Worksheets
Write-Back To The Database
-
Using A Model-Driven Approach
For BI Projects
- Oracle Portal Wins Editor's Choice
Award
-
Jim Dilanni On The Future Of
Oracle Certification - February 2004
-
Twelve Silver Bullets
For Oracle Performance Tuning - February 2004
-
Arup Nanda On Building
Firewalls Using Oracle Net - February 2004
-
Don Burleson's Questions
To Ask Your Applications Vendor - February 2004
-
Online Interview With
Matthew Symonds, Author Of "Softwar" - February 2004
-
Has Anyone Got TOra 1.2.4 On
Linux Working Against Oracle Database 10g? - February 2004
-
Peter Walzer On Ensuring The
Success Of BI Projects - February 2004
-
Inline Views And Outer Joins -
February 2004
-
OWB 9.2.0.4 Patchset Now
Available - February 2004
-
New Oracle Security Alerts
Page - February 2004
-
Oracle 10g, 10gAS Now Available
For Linux, Unix - February 2004
-
Passed My Final Oracle 9i DBA
OCP Exam - February 2004
-
Speaker Details For The UKOUG
Reporting Tools & BIW Special Event - February 2004
-
Rajesh Gadodia On Tactical
Vs. Strategic Data Warehousing - February 2004
-
IT Managers' Journal On
Oracle Licensing & Support - February 2004
-
GFS, OCFS, and GPFS - Which
Filesystem for Oracle? - February 2004
-
Joe Celko On "Thinking In
Aggregates" - February 2004
-
Slashdot On The Squabble
Between Sun And Eclipse - January 2004
-
Oracle News From The KOMTAR,
Penang - February 2004
-
Agile Development
Methodologies For DBAs - February 2004
-
Thoughts on Matthew Symonds
"Softwar" - February 2004
-
Don Burleson On Speeding Up
Oracle Data Loads - February 2004
-
Philip Russom On The Decline Of
The ODS - February 2004
-
New OTN Paper On Oracle
10g Support For SQL 2003 - February 2004
-
Notes On Sizing The Redo
Log Buffer - February 2004
-
Guide To Integrating OWB9.2
And Oracle Workflow - February 2004
-
Using Bulk Binds And
FORALL - January 2004
-
Why Does Discoverer Create Two Dedicated Connections? - January 2004
-
Joe Luedke On BI Barriers For
Small & Medium Size Businesses
- January 2004
-
Improving PL/SQL Performance
By Using Collections -
January 2004
-
Collections, Cursors,
Bulk Binds and FORALL -
January 2004
-
Margy Ross On The Habits
Of Effective Business Sponsors
- January 2004
-
Should Business Intelligence Be
'Real-Time'? - January 2004
-
News On Next Version Of E-Business
Suite - January 2004
-
The Effect Of Eclipse And The JTC On
BI Applications - January
2004
-
Using Oracle 9i Table
Compression For Star Schemas - January 2004
-
Brian Duff's New Orablogs.com Site
- January 2004
-
Using Advanced Security
And OID To Create A Database SSO
Environment - January 2004
-
Thomas Kurian On The
Evolution Of App Server,
Database - January 2004
-
Ralph Kimball's "Data Warehouse Dining
Experience" - January 2004
-
News On Qubeview's "Plugin
Architecture" - January 2004
 |
|
Oracle Application Server
Articles
OracleAS, Oracle 10gAS
& Oracle9iAS
|
-
Free Oracle
Database 10g XE - November 2005
-
Regular
Expressions Everywhere - August 2005
-
Securing Access to a
Linux Server.
- June 2005
-
Putting Your Web Cache To Work: Cache Invalidation using PL/SQL - April 2005
-
Integrating
HTML DB with Oracle AS10g - March 2005
-
Migrating Express
Server Databases To 10g And Discoverer "Drake" - February 2005
-
Compressed Composites
Oracle 10g Compression Explained - February 2005
-
BI Dashboards
Using Discoverer "Drake" And BI Beans - February 2005
-
Taking A
First Look At Application Server 10g Release 2 - Mark Rittman - January 2005
-
Fixing Startup Failures After
A Server Crash - John Garmany - January 2005
-
Application Server
Release 2 - John Garmany - January 2005
-
More Great Presentation
from Oracle Open World - John Garmany - December 2004
-
The Future of Forms -
John Garmany - December 2004
-
Oracle
Open World 2004 - AS 10g Release 2 Announced - John Garmany - December 2004
-
Application Server 10g
Standard Edition One Announced - John Garmany - November 2004
-
Roll Your Own STATSPACK
with DMSTool - John Garmany - November 2004
-
Harness the Power of
Oracle's Web Cache - John Garmany - Oct 20, 2004
-
Supercharge Dispersed Offices with a
Remote Web Cache - John Garmany - Oct 13, 2004
-
Application Server 10g Backup and
Recovery Tool - John Garmany - Oct 6, 2004
-
Windows Service Not Starting
Your Database? - John Garmany - Sept 29, 2004
-
Hosting Multiple Web Sites -
John Garmany - Sept 22, 2004
-
Automating Deployments from
JDeveloper to AS10g - John Garmany - Sept 15, 2004
-
Cookbooks For Oracle On Linux - John
Garmany - Sept 8,2004
-
Security Patch Released -
John Garmany - Sept 1,2004
-
Using a Remote Web Cache with
Application Server 10g - John Garmany - Aug 25,2004
-
Deploying an HTML Web Site on
Application Server 10 - John Garmany - Aug 18,2004
-
Installing the AS 10g and the 10g
Database on Fedora Core 2 - John Garmany - Aug 11,2004
-
34 Oracle Security Flaws Just
Discovered - John Garmany - Aug 4th, 2004
-
Oracle Internet Files
System Desupport Notice - John Garmany - July 28, 2004
-
New Pricing Scheme for Oracle AS10g and
Certification Stalls - John Garmany - July 21, 2004
-
Take the Oracle Web
Development Quiz - John Garmany - July 14th,2004
-
Building OracleAS Portlets
Using Apache Struts - Mark Rittman - July, 2004
-
Placing the Metadata Repository in an
Existing Database - John Garmany - July 7, 2004
-
Alert - Oracle Announces End of
Support Date For 9iAS - John Garmany - June 23, 2004
-
Oracle AS10g Start Failure on Windows - John Garmany - June 16th, 2004
-
Alert -
Serious Oracle Vulnerability Patch - John Garmany - June 9th, 2004
-
Oracle's Support For AMD 64bit Opteron
Processors - John Garmany - June 2nd, 2004
-
Logs, Logs Everywhere - John Garmany -
May 26th, 2004
-
What is an ETL process - John
Garmany - May 21, 2004
-
Oracle Streams and ETL - John
Garmany - May 21, 2004
-
Oracle10g and Data Change
Capture - John Garmany - May 21, 2004
-
Red
Hat Advanced Server Clones - John Garmany - May 12, 2004
-
Free Oracle10g poster released
- April 12, 2004
-
Restarting after
Oracle9iAS application server crash - John Garmany - April 7, 2004
-
Security patch for Oracle web
cache - John Garmany - March 24, 2004
-
Over-installing Oracle
Application Server - John Garmany - March 24, 2004
-
Free Oracle App Server tuning
Webcast - March 17, 2004
-
Setting the UNIX path for app
server - John Garmany
-
Enabling SSO Support For
Discoverer 9iAS - Mark Rittman
-
Oracle Application Server 10g
Features - Mark Rittman
-
Web Services With Oracle BI
- Mark Rittman
-
Securing Data Warehouse with
Advanced Security and OID - Mark Rittman
-
Building Portal Applications
Using Remote Database Links - Mark Rittman
-
Using The OWB Design Browser With The
Standalone OC4J Instance
- Mark Rittman
-
Integrating Discoverer 9iAS SSO Logins With
9i Database Logins
- Mark Rittman
-
Troubleshooting Oracle Portal
- Mark Rittman
-
Tips for installing 9.0.4 on United
Linux - Mark Rittman
-
Authenticating Discoverer 9iAS
Against A Non-Oracle LDAP Server - Mark Rittman
-
Using advanced security and OID to create
SSO database - Mark Rittman
-
Standard UNIX profile for Oracle
App Server users - February 25, 2004
-
Connecting with mod_osso - January
23, 204
-
Overview of Oracle9iAS tuning -
November 25, 2003
-
Oracle9iAS monitoring - December
3, 2003
 |
|
Oracle Articles tip Archive
Oracle articles from
the major portals |
-
Oracle Software saving lives
- January 2006
-
Oracle10g release 2
sorting improvements - 10g sort performance - December 2005
-
Oracle Systems
threatened by Patent Infringement Lawsuits - December 2005
-
Oracle multi-master
replication with Oracle Streams - November 2005
-
Oracle OS watcher OSWatcher utility - November
2005
-
Oracle Worm
may evolve into a threat - November 2005
-
Oracle
10g release 2 load balancing features - August 2005
-
New
sources for Oracle 10g scripts - June
2005
-
Inside Oracle Wait Time Tuning
- June 2005
-
Inside distributed
Oracle Parallel query - October 2005
-
Understand your responsibilities in
technical blogs and forums - June 2005
-
Oracle exposures and Google
Hacking - June 2005
-
Do your indexes suffer
from sparse blocks? - May 2005
-
Beware of using RAC with a data
warehouse - June 2005
-
Hot tip for Oracle cardinality
errors - May 2005
-
Oracle Silver Bullets Book
is now ready - May 2005
-
Clusters and cohort
groups - June 2005
-
Amazing Oracle 10g benchmark with a
terabyte of RAM - September 2005
-
Oracle SQL optimizer cost model
- April 2005
-
All about beer and diapers
- August 2005
-
For Managers Only –
Conducting the Programmer Job Interview - August 2005
-
Undocumented parms for using
CPU-based SQL optimization - August 2005
-
College equivalencies
interview nightmares - March 2005
-
Oracle users rave over multiple
buffer caches - July 2005
-
College Degree (or
equivalent experience) required - July 2005
-
Tuning multi-block I/O in Oracle
- July 2005
-
New Amazon SIP
helps you search Oracle Books - June 2005
-
Indexes -
Rebuilding and using multiple blocksizes - May 2005
-
The
importance of clustering_factor in multi-block I/O - May 2005
-
Are
you wrong to schedule table and index reorganizations? - May 2005
-
Oracle Offshoring a Failure
for Many Companies - April 2005
-
Intelligent Oracle 10g
DBA Maintenance - April 2005
-
Prove that index rebuilds
and table reorgs improve performance - February 2005
-
How does hardware affect
Oracle performance? - April 2005
- Oracle SQL
Developer
- Oracle
certification tips
-
Tuning Oracle Parallel
Query Execution - March 2005
-
Oracle Performance Bug – Check your
cpu_count setting - March 2005
-
Optimize Oracle backup time
duration - March 2005
-
Are all scientists created
equal? - February 2005
-
Predictive modeling in Oracle
10gr2 - February 2005
-
A peek at Oracle 10g Release 2
- January 2005
-
Oracle Third-party tuning
tools - January 2005
-
A peek at Oracle 10g Release 2
- March 2005
-
Hypercharge
complex Oracle LIKE searches with text indexes - March 2005
-
Hypercharge ETL with Oracle Data
Warehouse “exchange partition” functionality - March 2005
-
Oracle DBA job skills
- February 2005
-
Reduce I/O with Oracle cluster
tables - February 2005
-
Improve performance with multiple
blocksizes - December 2004
-
Burleson webcast on 64-bit Oracle
for Windows & Linux - December 2004
-
Internals of Oracle redo log management - January 2005
-
Robert Freeman joins Burleson
Consulting - January 2005
-
Oracle bitmap index tricks -
January 2005
-
Oracle Virtual Indexes -
December 2004
-
Oracle University
tips
-
Oracle enhancements & new features by Oracle release - December 2004
-
Oracle8i
to Oracle10g migration a popular option - December 2004
-
Gartner Group Concerned about Oracle
Security Patch Number 68 - November 2004
-
Oracle10g wait event tuning
book published - November 2004
-
New Oracle publisher dominates market -
November 2004
-
Why does
Oracle performance go bad after a migration? - December 2004
-
Google Print boom for Oracle
Professionals - December 2004
-
Oracle Fraud Alert -
November 2004
-
New insights into SQL resource usage
- November 2004
-
New redo log sizing advisor in
Oracle10g - November 2004
-
SQL WHERE clause order can be important to performance! - November 2004
-
Oracle Linux (UNIX) or Oracle Windows? - November 2004
-
Oracle Disk Load Capacity - October 2004
-
world's most widely-read security
security expert speaks on Oracle server hacking - November 2004
-
Disks and Oracle -
October 2004
-
Oracle Professionals plan for the
Future. . . Winners announced! - October 2004
-
File
System Mount Options and Oracle - October 2004
-
Oracle Failover Options - October 2004
-
Oracle and
RAID Usage - October 2004
-
Don't waste RAM on 32-bit Oracle Windows
servers - October 2004
-
The Importance of Join Order -
October 2004
-
Oracle terms with multiple
meanings - October 2004
-
Microsoft announces new shell
programming language - September 2004
-
Index Column Order Does Matter
- September 2004
-
Oracle Professionals plan for the
Future - September 2004
-
Fixing Corrupt System
Managed Undo Segments - September 2004
-
Oracle on Windows makes inroads
- September 2004
-
Detecting Oracle Overload -
September 2004
-
The changing role of the DBA -
September 2004
-
Oracle issues critical
technical alert on 8/31 - September 2004
-
Oracle10g Intel itaniun 64-bit windows - August 2004
-
Fast Guide: Solving common
Oracle errors - SearchOracle.com - August 2004
-
Some words on tuning the
Apache server - August 2004
-
Creating A Cascade Update Set of Tables - August 2004
-
34 Oracle PL/SQL security exposures found
- August 2004
-
Tune sub-optimal SQL with function
based indexes - August 2004
-
Oracle
SQL query monitor index use
- August 2004
-
The best Oracle DBA forum -
September 2004
-
Easy Oracle export/import with
Excel Spreadsheet - August 2004
-
Oracle gurus answer your Oracle
questions - September 2004
-
Oracle10g Intel itaniun 64-bit
windows - Oracle 10g - August 2004
-
PCTFREE and PCTUSED - August 2004
-
INITRANS, MAXTRANS,
FREELISTS and FREELIST GROUPS - July 2004
-
Check your Oracle license
compliance - July 2004
-
Oracle10g PL/SQL speed
improvements - July 2004
-
Format HTML output from SQL*Plus - July 2004
-
Intel threatens to change Oracle OS platforms - July 2004
-
Free Oracle SQL Tuning Secrets Webcast
- June 2004
-
Oracle Windows AWE Data
Buffer Size - July 1, 2004
-
New ORA-600 error message lookup on MOSC
- June 2004
-
Mike Ault on 10g RBO tips - June 2004
-
Use direct I/O with all Oracle databases
- May 2004
-
Choose the right disk configuration for
Oracle - May 2004
-
Migrate to CBO - May 2004
-
New SQL tracing utility - May 2004
-
Oracle10g new features Webcast - June
8, 2004
-
UNISYS and Rampant offer free Oracle10g
reference poster - April 2004
-
Setting AWR data retention thresholds
- April 8, 2004
-
Oracle announces controversial 2-day DBA
training - April 6, 2004
-
Important costs for 10g diagnostic
and tuning packs - March 2004
-
Speeding up Oracle logical I/O
- March 30, 2004
-
Benchmarks using large data buffer cache
and multiple blocksizes - March 29, 2004
-
Proving Oracle behavior - March 23,
2004
-
Try-out Oracle10g Windows on your PC today
- March 23, 2004
-
Free Oracle9iAS tuning Webinar -
March 18, 2004
-
Track I/O for specific Oracle tables &
Indexes - March 16, 2003
-
Oracle10g new utl_mail PL/SQL e-mail
package - March 12, 2004
-
Oracle10g beats SQL Server - March
9, 2004
-
Get your OCP fast to avoid training requirement
- March 2, 2004
-
Get 250.000 TPM with Oracle10g on Windows
- February 25, 2004
-
Which OS is right for you? - February 19,
2004
-
Oracle Headline News Announced - February 5,
2004
-
Linux NFS configuration services -
February 3, 2004
-
New Oracle-L - February 10, 2004
-
Super fast database copying - February 24,
2004
-
New rules for Oracle10g Grid data buffer
management - February 19, 2004
-
Hypercharge Oracle table inserts -
February 17, 2004
-
Should we re-analyze our schema? -
February 12, 2004
-
Oracle10g New Features Book
downloads available - February 10, 2004
-
DBA unemployment tops 6% - February 10,
2004
-
Super-size RAM with _smm_max_size
parameter - February 5, 2004
-
Sequence for using dbms_stats
-
February 3, 2004
-
Oracle10g now available - February 3, 2004
-
Rewrite Oracle SQL sub-queries for faster
performance - January 29, 2004
-
Super fast Oracle with SSD - January 27, 2004
-
Court decision may effect millions of Oracle
web applications - January 20, 2004
-
Oracle10g breaks record for speed -
January 15, 2004
-
Document Oracle Performance Changes -
January 13, 2004
-
Oracle physical Security - January 8,
2004
-
Recover from lost root password -
January 6, 2004
-
Insist your your rights with vendor
systems - December 30, 2003
-
Oracle features and prices - December 25,
2003
-
Oracle failover options - December
23, 2003
-
Report excessive chained row fetches
- December 18, 2003
-
Automatic Histogram detection with dbms_stats
- December, 16, 2003
-
Beware of small-table full-table scans
- December 11, 2003
-
Battle Against any RAID-5 for Oracle -
December 9, 2003
-
Oracle Standard Edition( SE) features vs. Oracle
Enterprise Edition (EE) - December 2, 2003
-
Oracle Standard Edition One - October 21,
2003
-
Oracle Structures and How They Affect Installation - October, 2003
-
Cold Backups - October, 2003
-
Free Oracle Goodies - November 7, 2003
-
Index on NULL index columns - November 4,
2003
-
Mike Ault releases his Oracle scripts
- November 3, 2003
-
OracleWorld 2003 presentations downloads
free on OTN - September 18, 2003
-
Ellison speaks out on Oracle10g Grid
Computing - September 19, 2003
-
Update on RBO in Oracle10g - September 10,
2003
-
Rule-based SQL optimization de-supported in
Oracle10g - September 5, 2003
-
OracleWorld 2003 Update - September 5,
2003
-
Performance Tuning Webcast, Part
3 - September 3, 2003
-
Oracle9i XML Security Exposure Patch -
August 24, 2003
-
Performance Tuning Webcast, Part
2- August 26, 2003
-
Performance Tuning Webcast, Part 1-
August 21, 2003
-
Justify your Oracle partitioning project
- July 22, 2003
-
Inside the Oracle SGA regions - July
31, 2003
-
Oracle9i sorting
enhancements - July 29, 2003
-
Find top Oracle sessions - July 24,
2003
-
Examine Oracle global I/O - July
22, 2003
-
Find Oracle physical database
design flaws - July 17, 2003
-
Find
sub-optimal Oracle SQL - July 15, 2003
-
Proper size your PGA with PGA advice
utility - July 10, 2003
-
Oracle Performance Checklist - July
8, 2003
-
Oracle9i RAC - Cluster file system & raw
devices - July 3, 2003
-
Hypercharge Oracle SQL*Loader and imp speed
- July 1, 2003
-
Automatically assign Oracle tables & indexes
to the KEEP pool - June 26, 2003
-
At last, Oracle humor articles! - June 19,
2003
-
Oracle v$shared_pool_advice shared
pool advisory utility - June 24, 2003
-
Improve Oracle indexes - build faster,
smaller & better balanced indexes - June 16, 2003
-
Oracle vs. SQL Server comparison
- June 10, 2003
-
New Oracle Certification Program being
offered - June 6, 2003
-
Free Webinar
Thursday June 5, 2003
- June 4, 2003
-
Proof that Large Index
Blocksizes Reduce I/O - May 26, 2003
-
Find the exact block causing a hung
session - May 18, 2003
-
Automate histogram analysis with dbms_stats
- May 14, 2003
-
Quickly improve SQL performance with
dbms_stats - May 6, 2003
-
Using dbms_metadata. get_ddl to punch
Oracle table & index syntax - May 6, 2003
-
How
to predict I/O reduction from a larger data cache - May 2, 2003
-
Ted Codd, father of the relational database,
dead at 79 - April 22, 2003
-
Oracle and Oracle9iAS developers must comply with
the ADA - April 19, 2003
-
Oracle9i WebDAV to compete with Microsoft
-
April 17, 2003
-
Your Oracle cpu_count is important -
April 12, 2003
-
Freelists vs. Freelist groups - April 9, 2003
-
Oracle Linux vs. Oracle Windows - March 29, 2003
-
Optimize your Oracle PGA Regions - March 24, 2003
-
Don't use the OPTIMAL parameter in
RBS - March 18, 2003
-
Is your Oracle system
in compliance with the ADA? - Pending
-
Oracle SQL test for OCP is now un-proctored -
March 9, 2003
-
Control optimizer
permutations with _optimizer_search_limit - February 26, 2003
-
Are you hiring the right Oracle Professional? - February 22, 2003
-
Setting optimizer_index_cost_adj - February 9, 2003
-
Migrating to the cost-based SQL optimizer, part 1 - January 31, 2003
-
Slammer virus cripples Oracle web traffic - January 25, 2003
-
Oracle8i de-supported in 2003 - January 23, 2003
-
STATSPACK now required for some iTars - January 19, 2003
-
New Oracle Trace Analyzer from Carlos @oracle.com - January 16, 2003
-
Great new Oracle Corporation Oracle SQL utility - January 14, 2003
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.
-
_optimizer_cost_based_transformation tips -
October 26, 2007
-
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
-
Add Constraint Oracle
-
Adding animated pictures to PowerPoint Presentations
-
Adjusting STATSPACK Collection levels
-
Aegis Oracle Tips
-
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
-
All Oracle 8i hidden parameters
-
Alter Oracle for autoextend on
-
Alter Tablespace Add Datafile
-
Alter User Oracle
-
alter_database_tab_monitoring
-
alter_schema_tab_monitoring
-
Alteration of Databases
-
Altering Oracle sequences
-
and-equal data access method
-
Andrew Kerber expert systems,
decision support systems and AI experience
-
Anonymous Block Tips
-
ApEx (HTML-DB) release 3 new features
-
Application Page to use a JavaScript multi-level menu list
-
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
-
asmcmd tips
-
Assigning Oracle user security roles
-
Assigning weights for a multi-column Oracle text index
- January 18,
2008
-
ASSM, freelists and PCTFREE
-
auditing concepts webcast
-
Auditing Oracle eBusiness Suite Financials
-
Ault & Burleson to give Predictive Modeling Seminar
-
Autonomous Transaction
-
Automated Storage Management ASM configuration
-
Automatic speech/voice recognition software for the Oracle professional
- January 19, 2008
-
Automating Oracle Data cleansing approaches
-
AWR and SQL Tuning
-
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
-
Biometric fingerprint scanners planned for credit card authentication
-
Bizgres tips
-
Black Arabian Stallion
-
Blocking Oracle access by IP Addresses
-
British Bloggers face journalist standards when web publishing
-
Buffer busy waits and I/O contention
-
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
-
Change Oracle IP and Domain DNS Tips
-
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
-
Cloning a large terabyte RAC database
-
Cloning an Oracle user
-
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
-
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
-
Concurrent manager job scheduling utility
-
Configuring oracle network
-
Connect Oracle to SQL Server
-
Connecting to Oracle with the Perl DBI
-
Consolidation of Oracle Audit Data sources
-
Converting Oracle rows to columns
-
copy Oracle table into MySQL database
-
Corporate e-mail spam rules
-
Corporate Information Technology (IT) budget planning
-
counterintelligence-scope CI polygraph
-
Counting Oracle tables
-
Create Database Link Oracle
-
Create or Replace Procedure
-
Create Schema
-
Creating an Oracle Data Cleansing Architecture
-
Criminals offer shilling bidding service for eBay
-
CTAS table reorg
-
Data Dictionary catalog scripts
-
Data format validation with Oracle regular expressions
-
Data Guard: archive log target fix
-
Data guard switchover with
dgmgrl
-
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
-
dateline adoption scams fraud
-
db_cache_size
-
db_file_multiblock_read_count
-
dba_advisor_findings procedure
-
DBI and Oracle
-
dbms_auto_task_admin tips
-
dbms_backup_restore tips
- November 6, 2007
-
dbms_job vs. dbms_scheduler
-
dbms_job.broken tips
-
dbms_job.remove tips
-
dbms_lob.writeappend to join BLOB columns
-
dbms_metadata tips
-
dbms_mtune
-
dbms_outfut.put_line
-
dbms_scheduler replaces cron for shell scripts
-
-
dbms_stats.gather_fixed_objects_stats tips
-
dbms_stats.gather_system_stats and SQL optimizer behavior
-
dbms_warning usage tips
-
dbms_xmlquery vs. dbms_xmlgen
-
DBWR Tuning Tips
-
Decompiling Oracle Java decompiler
-
Decreasing log file sync waits
-
Dedicating CPU processors - Oracle affinity
-
Defending against web content theft
-
Definition: Ya Boo Sucks to you
-
Delete duplicate rows - Deletion from Oracle tables
-
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
-
Difficulty with Host Credentials in Linux September 10th, 2007
-
Dimensionless Star Schema (Bitmap Star)
-
disable Oracle 10g statistics collection
-
Disable Oracle Dynamic Sampling
-
Discoverer: The server
is running low on virtual memory tips
-
Discoverer "Not all rows
have been retrieved. Data may be inaccurate" tips
-
Disk Average Failure Rate (AFR)
-
Disk to LUN I/O performance on SAN and NAS
-
Display Oracle concurrent manager processes
-
Display Oracle locks - locked rows for a user
-
Display Oracle SQL output rows on one single line
-
Display RAC Interconnect
Details
-
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
-
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
-
Elite Oracle Tips
-
Enabling AMM in 10g
-
Entity Relation Diagram (ERD) tools for Oracle databases
-
Error: dbconsole java.lang.exception: no such metric September 11th,
2007
-
ERROR 45
Initializing SQL*PLUS Internal Error
-
Estimate Oracle Index Size
-
Estimate Space used by an
Oracle Index
-
Estimating SGA size tips
-
Estimating the costs of Oracle data exposure
-
ETL with pipelined table functions & external tables
-
Excel Database tips
-
Excluding Tables from Full Exports September 12th, 2007
-
Execute Immediate on
Large Insert Strings
-
Execute operating system commands in Oracle
-
Executing SQL with the Oracle Perl DBI
-
exp imp tables
-
Oracle export
performance tuning - December 13, 2008
-
EXP: ORA-01036:illegal variable name/number
-
EXP-00002 tips
- December 19, 2007
-
EXP-00008: ORACLE error 904 encountered tips
-
EXP-00056: ORACLE error 942 encountered database link
-
EXP-00091 Exporting questionable statistics tips
-
FAS 48 and income statements for publicly held corporations
-
Find gaps in Oracle sequences
- October 26, 2007
-
Find movie show times fast
-
Find Oracle RAC Locks
-
Find tables referenced inside PL/SQL stored procedures
-
Find the Last Accessed Date for an Oracle Discoverer Workbook
-
Find the threshold for large tables and small tables
-
Find the threshold for large tables and small tables
- November 14, 2007
-
Find unused columns with dba_unused_col_tabs
-
Finding Oracle business intelligence experts
-
Finding Oracle materialized view opportunities
-
Finding Oracle Tuning experts
-
fingerprints as tables primary keys
-
fired for web surfing
-
Fix high "cache buffer chain" waits
-
Fix Oracle mutating table errors
-
Fix Oracle swapping on AIX
-
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
-
Forecasting Oracle Performance
-
Formatting PL/SQL stored procedure output
- January 16, 2008
-
FRM-10221
September 17th, 2007
-
FRM-41839: Disk I/O error on temporary record buffer file September
26th, 2007
-
Fun News!
-
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_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
-
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 to become an Oracle Applications DBA
-
How to change an Oracle table owner
- October 24, 2007
-
How to create a word document from Oracle
- December 27, 2007
-
How to create an Oracle database link
- January 17, 2008
-
How to detect a leap year with Oracle
- January 15, 2008
-
How to do switching between oracle databases
-
How to enforce a minimum password length
- November 8, 2007
-
How to Format Oracle output with HTML/XML
- January 15, 2008
-
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 retrieve oracle passwords
-
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
-
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
-
IE 7 Review
-
IMP-00010: not a valid export file tips - January 14, 2008
-
Import selected rows
-
-
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
-
Informix to Oracle migration tips
-
Ingres tips
-
init.ora file
-
Initialization Parameters in Oracle 10g
-
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
-
Integrating Streams Replication and Standby Databases
-
Installation of Oracle
-
installing Oracle STATSPACK
-
Installing RAC for an Oracle data warehouse
-
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
-
IOUG
Collaborate 2010
-
IOUG 2006 Top Session attendance results
-
Is my Oracle 32-bit or 64-bit?
-
Java Testing Principles
-
job_queue_interval
-
joins in oracle
-
Jon Emmons on Oracle Linux & UNIX shell scripting
-
Justifying a migration upgrade to Oracle 10g
-
killing oracle sessions
-
kewastUnPackStats(): bad
magic 1 tips
-
laptop notebook computers with biometrics and cameras
-
Large Oracle Blocksizes
-
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
-
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
-
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 Types and REF Cursors with Oracle Perl DBI
-
Locating similar SQL in Oracle
-
Lock Down Your Server
-
logging with LOB, BLOB, CLOB
-
Longest Oracle RAC 24x7 continuous availability
-
Lost SYSOPER password in Oracle 10g
- October 4, 2007
-
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
-
Maximum Oracle Limits
-
Maximizing Value in Oracle Training Budgets
-
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
-
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?
-
Modeling transitive Data Dependencies
-
Modeling transitive Data Dependencies webcast
-
Monitor Oracle Windows disks
-
Monitor Oracle Windows dump and trace files
-
Monitoring Oracle SGA & PGA Memory Changes
-
Monitoring Oracle Table Usage
-
Monitoring SQL*Loader Inserts
-
More Random Data
-
MS-Word adding & removing carriage returns
-
multiple block sizes
-
multiple materialized views
-
Multiple Oracle buffer LRU latches?
-
narcissistic personality disorders
-
Net Present Value of undergraduate grades towards law school tuition
-
New Shared Pool Features of Oracle 10gr2 (release 2)
-
NFB alleges Oracle Human Resources software is not blind-friendly
-
Non-ORA Errors September 25th, 2007
-
Object type in dba_objects
-
OEM RAC Monitoring
-
Official DMCA Copyright Infringement Removal Request
-
OLAP Analytic Workspace XML objects
-
On personal integrity and consulting
-
Online data validation format systems characteristics
-
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
-
Optimize Oracle import (impdp) speed
-
Optimize Oracle SQL*Loader Performance
-
Optimizer costs don't match SQL execution performance
-
Optimizing Linux network TCP/IP kernel parameters
-
Optimizing Oracle INSERT SQL performance
-
Optimizing Oracle performance
-
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-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-00972: identifier is too long tips
-
ORA-00980: synonym translation is no longer valid tips
-
ORA-01000: maximum open cursors exceeded tips
-
ORA-01034: ORACLE not available tips
-
ORA-01187 from RMAN copy command tips
-
ORA-01187: cannot read from file nnn because it failed verification tests
-
ORA-01207 tips
-
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-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-01940 tips
-
ORA-02049: timeout: distributed transaction waiting for lock tips
-
November 17, 2007
-
ORA-02049: timeout: distributed transaction waiting for lock tips
-
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-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-12528: TNS:listener: all appropriate instances are blocking new
connections tips - October 9, 2007
-
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-16139: media recovery required tips
- October 23, 2007
-
ORA-19625: error identifying file string tips
- October 11, 2007
-
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-27101: shared memory realm does not exist tips
-
ORA-28000: the account is locked tips
-
ORA-28009:connection as SYS tips
-
ORA-28545: error diagnosed by Net8 when connecting to an agent
-
ORA-29278: SMTP transient error: string tips
- October 12, 2007
-
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-31603: object "string" of type string not found in schema "string"
-
October 15, 2007
-
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
-
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 SQL performance analyzer concepts
- January 16, 2008
-
Oracle 11g SQL tuning transformations - December 16, 2007
-
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 ADF and Java ADF faces
-
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 ANALYZE TABLE
-
Oracle version control tips
-
Oracle Analytic Functions
-
Oracle Analytics 12-5-07
-
Oracle Analyze Index
-
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 Acquires Sun Microystems for
$7.4b
-
Oracle archivelog noarchivelog mode recovery
-
Oracle ASSM
-
Oracle asynchronous change data capture
-
Oracle audit command tips
-
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 Autotrace
-
Oracle
autostats_target
-
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 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 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 copy
-
Oracle cost based optimizer
-
Oracle Convert to Number
-
oracle create database example
-
Oracle create spreadsheet tips
-
Oracle CREATE
SEQUENCE
-
Oracle create tablespace & alter tablespace syntax
-
Oracle Create Type
-
Oracle CREATE VIEW
-
Oracle cron crontab examples
-
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 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 dblink
-
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 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 Dimensions
-
Oracle Directories
-
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 DML error logging
-
Oracle DML statements
-
Oracle documentation Search
-
Oracle Drop Partition
-
Oracle Drop Tablespace
-
Oracle Drop Synonym
-
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 script for Windows
-
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 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 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 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 INSERT statement
-
Oracle INSTR
-
Oracle Initialization Parameters
-
Oracle INITRANS tips
-
oracle inline view
-
Oracle insert tuning
- October 25, 2007
-
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 IOT vs. Single-table cluster
-
Oracle Jargon Generator
-
Oracle Java
-
Oracle Java blob graphics retrieval
-
Oracle java.lang.OutOfMemoryError Tips
-
Oracle Java Methods
-
Oracle Java PL/SQL scripts
-
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 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 LTRIM
-
Oracle LTOM Lite Onboard Monitor
-
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 MREADTIM and SREADTIM workload statistics
- November 22, 2007
-
Oracle MTS - multithreaded shared servers
-
Oracle NEXTVAL function
-
Oracle next_day tips
-
Oracle nls_lang tips
-
Oracle normalization
-
Oracle not equals (!=) SQL operator
-
Oracle num_rows in dba_tables
-
Oracle OAE Training Class
-
Oracle OCA practice tests
-
Oracle OCM certification tips
-
Oracle OCP Tips
-
Oracle OLAP dbms_aw_xml
-
Oracle OLAP dimensions & cubes
-
Oracle OLAP Hierarchical Tools
-
Oracle OOAD Database Design
Object Oriented
-
Oracle on the Internet
-
Oracle on Windows Vista
-
Oracle online systems for data scrubbing
-
Oracle online table reorganization
-
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 Parse to Execute Ratio
-
Oracle Partition Key Statistics & tuning
-
Oracle partition SQL queries
-
oracle partitioning
-
Oracle partitioning and tables - partition-wise joins
-
Oracle password protection tips
- November 8, 2007
- Oracle password tips
-
Oracle Password Security
-
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 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 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 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 caching & performance
-
Oracle Sequences
-
Oracle server configuration
-
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 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 cost-based optimizer parameter _like_with_bind_as_equality
-
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 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 SQL Query - Rollup
Analytical Function
-
Oracle standby database license requirements
-
Oracle standby reporting database
-
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 hash clusters
-
Oracle Table I/O and buffer efficiency monitoring
-
Oracle table monitoring
-
Oracle table object wait statistics - v$segment_statistics
-
Oracle tablespace exports
-
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 third-party tuning tools
-
Oracle Times Ten data caching
-
Oracle Timestamp Elapsed Math
-
Oracle tkprof utility
-
Oracle TNS-12541 tips
-
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 Validated Configurations
-
oracle varray
-
Oracle Varrays
-
Oracle Veritas vxfs filesystem optimization
-
Oracle version control & change control tips
-
Oracle version control and change control?
-
Oracle Virtual Private Databases VPD multiple policy values
-
Oracle vmware tips
- November 13, 2007
-
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 Monitoring tips
-
Oracle on Windows 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: 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
-
Oracle10g Release 2 10g Case insensitive searches
-
Oracle10g SQL*Trace Changes
-
Oracle8i hidden trace parameters
-
Oracle9i desupport date set for July 2007
-
oradim
-
orakill
-
Organizing Oracle Not-for-profit Functions
-
OS commands for RAC
-
OUI-10151 During Install tips
- October 17, 2007
-
overview of STATSPACK install scripts
-
Parallel query error ORA-12801
-
Parsing with regular expressions regexp_like
-
Partitioning an Oracle table
-
Peoplesoft Configuration & Oracle Consulting
-
Personality assessment for business professionals
-
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 best practice Standards
-
PL/SQL best practice Standards
-
PL/SQL Capitalization Best Practices Standards
-
PL/SQL code alignment standards
-
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 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
-
plan9i.sql script
-
plsql_optimize_level
-
Poor Oracle performance after 64-bit server migration
-
Poor Quality, Diploma Mill MBA Schools
-
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
-
professional golf etiquette for IT professionals
-
Pursuing a career in Oracle Medical Informatics
-
Purge Oracle Recyclebin
-
RAC and Oracle data warehouse
-
RAC clusters for laptop computers
-
RAC GES Monitoring
-
RAID5 acceptable for Oracle databases
-
Reading a STATSPACK report
-
Reading SQL 10053 trace files
-
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
-
Reducing undotbs01.dbf tips
- October 19, 2007
-
Refresh test database from production schema
-
Refreshing an Oracle
Materialized View
-
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
-
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
-
Renaming files from inside PL/SQL
-
Reorganization with "alter table xxx move" syntax
-
repair corruption with UNDO tablespace
-
Republishing a libel & internet censoring
-
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
-
reverse key indexes
-
Rittman OWB articles
-
RMAN-03009: failure of backup command
-
RMAN large pool PGA RAM tips
-
RMOUG 2006 Conference speaker evaluations
-
row resequencing webcast
-
rules for internet journalists
-
Sample STATSPACK (AWR) Analysis
-
Sample Table Scans and Oracle Dynamic Sampling
-
SAP Oracle Configuration Consulting
-
SAP Oracle Tuning
-
Scam to fool Google by simulating Oracle web sites
-
Scheduled job completion verification
-
Scheduling Oracle jobs in Windows
-
Scheduling weekly, monthly and yearly jobs
-
Script to compute Oracle table size
-
Script to display SQL Server files for autogrowth
-
Script to display SQL Server locks
-
Script to verify that Oracle database is running
-
Search Engine Precision and Recall
-
Search Engine word stemming and synonym expansion
-
segment_type in dba_segments
-
Segregate tables and indexes on disks?
-
Sending e-mail from HTML-DB
-
Sending e-mail from Oracle
-
Sending e-mail with wwv_flow_mail
-
session_cached_cursors sizing
-
Setting nls_date_format September 5th, 2007
-
Setting Oracle environment variables in Linux/UNIX
-
Setting SQL bind variables
-
Shortcomings of the 10046 Event
-
Show redo volume for an active DML transaction
-
Signature Analysis of Wait Events
-
Simulating Oracle server & disk failures
-
Single-task versus two-task or multitask structure
-
SLA - Service level agreement tips
-
Slony-I tips
-
software regression modeling for Oracle
-
sort merge join tips
- December 12, 2007
-
Spyware and Adware Detection and Immunization
-
SQL - Find number of commas with a string
-
SQL best practices
-
SQL design patterns tips
-
SQL hanging on TEMP space usage
- October 18, 2007
-
SQL Tuning with Transitive
Closure
-
SQL Server 2005 script to display disk space usage
-
SQL Server capacity planning scripts
-
SQL Server database fragmentation script
-
SQL Server file I/O script
-
SQL Server script to find disk bottlenecks
-
SQL Server table Fragmentation script
-
SQL Server Health Checks
-
sql server users groups
-
SQL Server workload script
-
SQL*Loader - loading data into multiple tables
-
SQL*Loader External Tables
-
sqlldr
-
sqlldr reorg
-
sqlnet_expire_time and dead connection detection
-
SSD coming for Oracle PC Applications
-
stats$enqueuestat Table
-
stats$latch Table
-
stats$latch_misses_summary Table
-
stats$rollstat Table
-
stats$waitstat Table
-
STATSPACK oracle
-
STATSPACK Oracle9i SQL Snapshot thresholds
-
STATSPACK purge utility
-
STATSPACK Snapshot thresholds
-
Steps to install STATSPACK
-
Stochastic methods for Oracle holistic tuning
- September 29,2007
-
stopping a queue error: ORA-03113: end-of-file on communication channel
-
Storing MS-Word docs in Oracle
-
Storing pictures and photos in Oracle tables
-
Subtract SQL result sets?
- December 13, 2007
-
Superfluous overhead in Oracle
-
Supporting HTML-DB JavaScript and Cascading Style Sheets
-
SYSAUX tablespace
-
System Date errors and computer application exposure
-
table rename column
-
tablespace change extant management local uniform to autoallocate
-
Taking a STATSPACK or AWR snapshot
-
Taking a STATSPACK report
-
Terminating Oracle connections with connect_time, idle_time, expire_time and
inbound_connect_timeout
-
The Art of Oracle Heuristic “Rule of Thumb” Tuning
-
Why Oracle is not like CA
-
The best Linux books
-
The best of IOUG Collaborate 2006
-
The best Oracle authors
-
The History of
Oracle
-
The Oracle Manuals
-
The origin of Oracle scott/tiger
- Tony Jambu
-
The perils of server deconsolidation
- November 18, 2007
-
The Plague of Large Oracle Disks
-
The Publish/Subscribe Model for Oracle Replication
-
The Screaming Banshee
-
They AMM to Please...Sometimes
-
Tips for ORA-02292 Constraint violation - child records found
-
Tips for reading Oracle trace files
-
Tips for using the COMPATIBLE parameter
- November 17, 2007
-
TLD e-mail filtering masks
-
TNS-01190: The user is not authorized to execute the requested listener
command lsnrctl
-
TNS-12531 error
-
TNS-12560: TNS:protocol adapter error
-
tnsnames.ora
-
tnsnames.ora dns host server name
-
Top 10 Reasons for poor Oracle performance
-
top job interview questions
-
Top Oracle books now available overseas
-
Top Oracle developer certification & skills
-
trace Oracle bind variable values
-
Tracing Events
-
Tracing Oracle Sessions
-
Tracking & Monitoring table growth
-
Tracking Oracle full table scans
-
Tracking Oracle hash joins
-
Tracking Oracle schema changes
-
transposition errors with Oracle regular expressions
-
Troubleshooting & diagnosing TNS SQL*Net connectivity errors
-
Troubleshooting network TNS SQL*Net connectivity
- November 17, 2007
-
Tuning Cognos on Oracle
-
Tuning large oracle batch jobs
-
Tuning Linux VM on Kernel 2.6
-
Tuning Oracle redo logs
-
Tuning Oracle SQL subqueries
-
Tuning Oracle UNDO segments
-
Tuning Oracle with NUMA on Solaris 9
-
Tuning SQL inside Oracle batch jobs
- October 31, 2007
-
Tuning SQL with STATSPACK & AWR
-
Tuning SQL with temporary tables
-
Types of Oracle auditing?
-
Unauthorized Network access becomes a felony
-
undo tablespace sizing
-
UNDO tablespace with autoextend
-
United States SECRET security clearances. Costs, time required, and
disqualifying conditions
-
UNIX commands from inside Oracle
-
Upgrade Oracle Applications R11i version 11.5.5 invalid Java class
-
Using asm_diskstring for LUN's in Solaris multipathing
-
Using dba_optstat_operations
-
Using dbms_hprof to trace PL/SQL execution
-
Using explain plan
-
Using faster hardware to correct an Oracle performance problem
-
Using Google keyword searches to Find Oracle Information
-
Using Oracle to capture UNIX/Linux vmstat output
-
Using ORADEBUG To Set A Trace Event
-
Using SQL*Loader to Reorganize Oracle Tables
-
Using SQL*Plus autotrace
-
Using TDE with Partitioning and
OLS
-
Using the APPEND hint with the MERGE (upsert) SQL
- November 14, 2007
-
Using the Oracle _convert_set_to_join parameter
-
Using The SQL MODEL Clause
-
Using the up arrow key for
command history in Oracle
-
Using utl_recomp
-
Using v$sql_monitor
- November 22, 2007
-
v$active_session_history
-
v$asm_file extraction script
-
v$bh status column and free RAM blocks
-
v$cache_transfer
-
v$event_histogram tips
-
v$lock wait events
-
v$logmnr_contents tips
-
v$pq_tqstat script?
- January 12, 2008
-
v$sql_plan_statistics
-
v$system_event
-
Verifying & Auditing Data Replication Oracle
-
Vertical vs. Horizontal scalability for Oracle
-
View Oracle patents
-
Viewing Oracle CPU and I/O costs
-
Viewing SQL execution details over time
-
VOUG 2006: Virginia Oracle Users Conference Speakers
-
Warning: Product user profile information not loaded
- January
9, 2008
-
Web Predators book
-
Web Server page compression tips
-
Web Stalkers Book exposes criminal tactics
-
webcast - Sorted Hash Clusters
-
webserver RAM caching tips
-
Webserver Traffic Monitoring Tips
-
Welcome to My Nightmare – The Common Performance Errors in Oracle Databases
-
What to do when somebody seals your web content?
-
What to do when you cannot connect to Oracle
- January 8, 2008
-
Why choose Oracle?
-
Why use a small data block buffer cache with solid-state disks?
-
Windows Oracle Job Schedulers examples
-
Windows script to display SQL Server Disk Usage
-
Word 2007 docx file conversion
- October 23, 2007
-
world record data warehouse benchmark
-
Writing conditional messages to SQL*Plus spool file
-
Writing Efficient Oracle SQL
-
Writing Oracle BLOB to OS file
-
Writing to the Oracle Alert Log
-
Zero Day attack definition
-
利用Oracle数据库存储和分析Unix操作系统的性能
open web page in
expression web from browser
Oracle 12c New
Features Training Course
Upgrading to Oracle 12c
training class
Oracle 12c New Features training in
Oracle12c
Linux block_devices
Linux character devices
Linux named pipes
Linux sockets
Linux: sending output
to a File
escape special characters
Linux PATH variable Tips
Moving Oracle control files
How to disable AWR
dbms_stats run frequency
tips - 28 October, 2012
SCN change tips - 28 October, 2012
Find function-based indexes -
26 October, 2012
Find function-based
indexes - 26 October, 2012
Limiting Oracle table size
- 26 October, 2012
Data Guard fal_client
and fal_server -
25 October, 2012
RMAN backup of ASM disk -
24 October, 2012
RMAN convert file to ASM storage
- 24 October, 2012
Calling COBOL from PL/SQL
- 24 October, 2012
ORA-01153: an
incompatible media recovery is active tips - 22 October, 2012
_use_adaptive_log_file_sync
tips - 22 October, 2012
ORA-01722: invalid number &
SQL*Loader - 22 October, 2012
ORA-16792 Tips - 17 October, 2012
ILM clause Tips -
17 October, 2012
12c Transaction Guard Tips - 17
October, 2012
Hybrid Histograms tips - 16 October,
2012
adaptive execution plan tips
- 16 October, 2012
Pluggable Database Tips - 15
October, 2012
Oracle data copy speed - 15 October,
2012
Display maxsize for a data
file - 11 October, 2012
dbms_scheduler dictionary
views - 9 October, 2012
Obsolete Import Utility
Parameters - 9 October, 2012
RMAN convert clause tips - 9
October, 2012
TOAD: ORA-01031:
Insufficient privileges - 9 October, 2012
Create tablespace using ASM - 9
October, 2012
Invalidating SQL after running
dbms_stats - 8 October, 2012
Index full scan tips - 7 October,
2012
RMAN section size tips - 7 October, 2012
RMAN maxpiecesize tips -
7 October, 2012
import schema with impdp Tips -
6 October, 2012
ORA-01276: Cannot add file Tips - 6 October, 2012
dba_parallel_execute_chunks
Tips - 4 October, 2012
Negative value in an AWR
report - 4 October, 2012
Using substr with
multibyte character sets - 2 October, 2012
Guaranteed Restore
Point tips - 1 October, 2012
Oracle extent overhead tips - 27 September 2012
awr_sql_report_text tips - 27 September 2012
Oracle table performance tips - 26 September 2012
dbms_workload_repository
topnsql Tips - 26 September 2012
Increase the
maximum number of open file descriptors in Linux - 26 September 2012
AWR: high water mark of
sessions - 25 September 2012
df command in Oracle - 23 September 2012
Oracle: Using the UNIX mount command
- 23 September 2012
Find UNIX file blocksize - 23 September 2012
Oracle lsof command tips - 23 September 2012
identity column tips
- 21 September 2012
RMAN ORA-01403 No Data Found
Tips - 20 September 2012
File
management between primary and standby database Tips - 20 September 2012
db_file_name_convert Tips - 20
September 2012
Shutdown Timeout Tips - 19 September
2012
Oracle change
execution priority - 18 September 2012
Oracle display RAM - 18 September 2012
Oracle controlfile I/O Tips -
18 September 2012
SQL*Loader bad file vs
discard file - 18 September 2012
Real-time ADDM - 15
September 2012
SQL Commonality Index Tips -
15 September 2012
Recursive PL/SQL -
15 September 2012
Remote file copy tips -
15 September 2012
ASH Analytics -
11 September 2012
Recursive PL/SQL - 9 September 2012
How to execute multiple sql
files in DOS Windows - 6 September 2012
v$shared_pool_reserved tips -
5 September 2012
Row cache enqueue lock tips -
5 September 2012
ORA-31693: Table
data object failed to load/unload error - 5 September 2012
ASM intelligent file
placement Tips - 2 September 2012
v$asm_disk_iostat Tips - 2
September 2012
Oracle index rebuild online -
2 September 2012
Oracle defragmentation Tips - 1
September 2012
Copy Oracle BLOB - 31 August, 2012
How to insert a
video into an Oracle database - 31 August, 2012
Difference
between CONSISTENT and OBJECT_CONSISTENT parameter - 30 August,
2012
Data Recovery Advisor tips
- 29 August, 2012
Reset SYS password tips - 29
August, 2012
Oracle block format tips - 27
August, 2012
Oracle merge hint tips - 23 August, 2012
Oracle alter table
shrink compact - 22 August, 2012
Oracle library cache SQL hash
value - 22 August, 2012
Automatic re-start of
Oracle on Windows - 21 August, 2012
Alert when Oracle refuses connections
-
19 August, 2012
Alert on hung Oracle database
-
19 August, 2012
Alert oracle database crash -
19 August, 2012
Backup oracle files with tar
-
19 August, 2012
Copy tnsnames.ora file tips -
19 August, 2012
Oracle file soft link tips -
19 August, 2012
Change Oracle file
permissions with chmod -
19 August, 2012
Materialized view refresh
group tips -
17 August, 2012
ASM Background Processes -
11 August, 2012
ASM Instance Management -
11 August, 2012
Tablespace Alert Script -
11 August, 2012
Masking Oracle table rows -
11 August, 2012
Masking Oracle columns Tips
- 11 August, 2012
Gupton's Guns Henderson NC
ORA-00494 enqueue
[CF] held for too long tips - 8 August, 2012
Oracle SCAN listener tips - 7 August,
2012
Oracle Bulk Collect Tips -
7 August, 2012
PLS-00306: wrong
number or types of arguments tips - 5 August, 2012
delete all data rows from
Oracle table tips - 2 August, 2012
unexpire Oracle password tips -
1 August, 2012
Reset forgotten password -
1 August, 2012
ORA-28002 tips
- 1 August, 2012
Oracle fusion middleware job
duties tips - 1 August, 2012
Oracle Weblogic job duties tips -
1 August, 2012
Oracle client 32 bit or 64 bit?
- July 28. 2012
Oracle one-way replication tips -
July 26. 2012
Create snapshot tips - July 26. 2012
Oracle 11g new CBO
Optimizer Features- July 23. 2012
undo advisor Tips - July 22. 2012
MTTR Advisor Tips - July 22. 2012
dbms_xplan.display_cursor Tips
- July 22. 2012
utl utilities list - July 22. 2012
utl_coll Tips - July 22. 2012
Oracle UTL_ENCODE Tips - - July 22. 2012
PL/SQL Boolean Examples - July 22.
2012
difference
between RAC public IP, private IP and Virtual VIP - July 18, 2012
DMSYS Schema tips - July 18, 2012
log_archive_local_first tips - July 12,
2012
standby_log_archive_dest &
log_archive_dest tips - July 12,
2012
ORA-01400: cannot
insert NULL into ("SYS"."AUDIT_DDL"."DICT_OBJ_TYPE") tips - July 11,
2012
create_stored_outlines tips -
July 10,. 2012
dbms_space
create_index_cost tips - July 10, 2012
dba_dimensions tips - July 8, 2012
dba_constraints tips - July 7, 2012
dbms_advisor tips - July 7, 2012
dbms_workload_capture tips -
July 7, 2012
ORA-25152: TEMPFILE
cannot be dropped tips - July 4, 2012
dbms_space_admin tips - July 4, 2012
Why does SQL not choose
the lowest cost plan? - July 4,
2012
generate index DDL tips - July 3,
2012
Generate PL/SQL
stored procedures from Oracle - July 3,
2012
Generate database DDL
tips - July 3,
2012
dbms_redefinition example - July 3,
2012
Import entire schema Tips- July 3,
2012
Import entire tablespace Tips- July 3,
2012
Search a CLOB column tips - July 3,
2012
impdp parameter tips - July 2, 2012
Optimize impdp performance
- July 2, 2012
fastest way to join two
tables - July 2, 2012
ORA-26689 Column Type
Mismatch tips - June 30, 2012
SQL*Plus timing start and timing stop
tips - June 30, 2012
Copying Oracle statistics tips
- June 29, 2012
ORA-09925: Unable to create audit trail file
tips - June 29, 2012
estimate_percent tips -
June 27, 2012
gc cr current grant busy tips
- - June 26, 2012
gc cr multi block request
tips - June 26, 2012
db link usage script tips -
June 25, 2012
/etc/sysconfig/oracleasm tips - June 25, 2012
ocfs2console tips - June 25, 2012
orastack tips - June 24, 2012
renice tips - June 24, 2012
Tips for Tracing Oracle - June 20, 2012
Share tnsnames.ora tips - June 20, 2012
Share tnsnames.ora tips -
June 20, 2012
NETCA tips - June 19, 2012
Oracle restart tips - June 18, 2012
How Oracle users are mapped
to tablespace files - June 18, 2012
crsctl css pin -n command tips - June 16, 2012
Oracle Capturing Date Information
in UNIX - June 14, 2012
Capturing server information
in Linux/UNIX - June 14, 2012
Common UNIX/Linux commands
- June 14, 2012
Linux dircmp command example -
June 14, 2012
TNS connectivity example -
June 14, 2012
Difference between
multiplexing and mirroring - June 13, 2012
Oracle Windows binary
executables list - June 11, 2012
Oracle UNIX Linux binaries list
- June 11, 2012
Oracle packages list - June 11, 2012
Export expdp command syntax
- June 9, 2012
expdp parameters for
procedures functions and and packages - June 9, 2012
The value of MAXTRANS
parameter ignored tips - June 7, 2012
SP2-1503:
Unable to initialize Oracle call interface tips - June 6, 2012
oracleasm command tips - June 4, 2012
ASM create diskgroup tips -
June 4, 2012
ASM external redundancy -
June 4, 2012
dcmctl command tips - May 31, 2012
Oracle relink command tips -
May 31, 2012
Oracle file striping tips - May 31,
2012
dbms_stats compare
statistics tips - May 29, 2012
dbms_stats incremental
statistics tips - May 29, 2012
ORA-12008 tips - May 26, 2012
raw vs. cooked Oracle file tips -
May 25, 2012
Change SYSDATE display value Tips
- May 25, 2012
/etc/sysconfig/clock zone
values - May 25, 2012
ORA-00308 cannot open
archived log tips - May 16, 2012
ASM allocation units for RAC
- May 13, 2012
Oracle: display euro symbol
€ - May 10, 2012
Oracle Linux server sizing tips
- May 10, 2012
AWR Global RAC report tips
- May 9, 2012
olsnodes command tips
- May 9, 2012
RAC Policy managed database
tips - May 8, 2012
RAID 10 vs RAID 0+1 Tips - May 8,
2012
Consistent read block tips -
May 8, 2012
Dirty block tips - May 8, 2012
Purpose of the large pool -
May 8, 2012
RAC global resource
directory tips - May 8, 2012
RAC heartbeat tips - May 8, 2012
11g hint list - May 8, 2012
RAC voting disk tips - May 7, 2012
Startup mount tasks tips -
May 7, 2012
Debugging utl_smtp email tips -
May 6, 2012
Oracle trigger validation tips
- May 2, 2012
Oracle incremental checkpoint tips
- May 2, 2012
Oracle RAC Grid Differences
- May 2, 2012
Oracle cluster tables tips
Oracle cluster index tips -
May 1, 2012
Select rows per block in Oracle -
April 29, 2012
Select first 10 rows from an Oracle
table -
April 28, 2012
Select last 100 rows from an Oracle
table -
April 28, 2012
Server room standards Tips -
April 20, 2012
ORA-00028 Tips - April 20, 2012
Oracle export
import character set differences - April
19, 2012
Find Oracle system roles- April
19, 2012
SQL*Plus single logon
attempt Tips - April
19, 2012
SQL*Plus restriction
Tips - April
19, 2012
ref cursor examples
- April
18, 2012
ORA-06504 ref cursor OUT Tips
- April
18, 2012
Running WebCenter from
Weblogic tips - April
17, 2012
ORA-00904 when
select nvarchar from SQL Server - April
17, 2012
ORA-30683: failure establishing connection to debugger tips - April
16, 2012
ASM disk
does not exist or is not instantiated tips - April
15, 2012
extract data files from RMAN tips
- April
14, 2012
RAC: IP address has
already been used tips - April
14, 2012
authid current_user Tips - April
13, 2012
Oracle PAE Tips - April
13, 2012
Oracle HACMP Install Tips - April
13, 2012
Oracle Total Recall Tips - April
11, 2012
RAC CRS will not start tips - April
11, 2012
Oracle estimate percent tips
- April 10, 2012
Recover a missing control
file tips - April 9, 2012
ORA-00205: error in
identifying controlfile - April 9, 2012
Recover Oracle after losing
a data file - April 9, 2012
Oracle control file tips - April 9, 2012
dba_hist_undostat tips - April 7, 2012
DBA_DATAPUMP_JOBS Tips - April 4, 2012
SQL to convert a day of
the week to a number - April 4, 2012
ORA-31626 tips - April 4, 2012
Why is my index not being used? - April
3, 2012
Oracle mlog$ tips - April 2, 2012
Oracle drop tips - April 2, 2012
Oracle sqlcode tips - April 1, 2012
Oracle sqlcode = 100 tips
- April 1, 2012
sqlnet.inbound_connect_timeout tips - April 1, 2012
v$transaction tips - April 1, 2012
alter database
backup controlfile to trace - April 1, 2012
for update nowait tips - April 1,
2012
for update wait tips - April 1, 2012
pls_integer tips - April 1, 2012
v$locked_object tips - April 1, 2012
elsif tips - April 1, 2012
Oracle multi-column subquery tips
- March 31, 2012
Oracle correlated subquery tips -
March 31, 2012
Oracle memory usage tips -
March 31, 2012
v$sql scripts - March 31, 2012
Oracle Bulk Insert tips - March 31, 2012
Oracle VARRAY Table tips - March 31, 2012
Oracle Nested Table tips - March 31, 2012
parallel hint tips - March 31, 2012
update multiple columns tips - March 31, 2012
Calling an Oracle function - March 31, 2012
Calling an Oracle stored
procedure - March 31, 2012
index range scan tips - March 30, 2012
index fast full scan tips - March 30, 2012
SQL plan not
reproducible - March 30, 2012
Oracle Constraint Tips - March 29, 2012
nvl vs. nvl2 - March 28, 2012
lnnvl Tips - March 28, 2012
Update table Oracle tips - March 27, 2012
v$sqltext tips - March 27, 2012
sys.aud$ tips - March 27, 2012
Oracle spool tips - March 27, 2012
ORA-01820 tips - March 26, 2012
obtool command tips - March 23, 2012
Oracle SQL nested subqueries tips
- March 19, 2012
v$sesstat tips - March 19, 2012
PL/SQL function examples - March 18, 2012
PL/SQL assignment
statement examples - March 18, 2012
PL/SQL constant examples - March 17, 2012
PL/SQL accept command tips
- March 17, 2012
Format Report output with PL/SQL
- March 17, 2012
SQL*PLus print command tips -
March 17, 2012
Display blank lines with PL/SQL
- March 17, 2012
PL/SQL: join tables together
tips - March 10, 2012
Find SQL with excessive
hard parses - March 3, 2012
Global temporary table
example - March 3, 2012
Oracle: How to drop a histogram
- March 3, 2012
11gr2 cursor_sharing=force bug
causes contention - March 3, 2012
Tuning WHERE NOT EXISTS Tips
- March 3, 2012
Convert to a blob tips -
February 27, 2012
PL/SQL function restriction
tips - February 26, 2012
PL/SQL read file tips -
February 25, 2012
PL/SQL object type examples -
February 23, 2012
PL/SQL associative array
examples -
February 23, 2012
PL/SQL function examples -
February 23, 2012
PL/SQL implicit cursor
examples -
February 23, 2012
PL/SQL FOR Loop examples -
February 23, 2012
PL/SQL Collection tips -
February 22, 2012
PL/SQL associative array tips
- February 22, 2012
PL/SQL nested table tips -
February 22, 2012
SQL*Plus set command tips -
February 21, 2012
Oracle SQL Tuning
Quick Reference cheat sheet - February 21, 2012
Inserting Chinese character
set tips - February 21, 2012
Size threshold for
partitioning tips - February 20, 2012
dbms_auto_sqltune tips - February 11, 2012
AWR
dba_hist_colored Table - February 11, 2012
11.2 new v$ WLM views - February 11, 2012
11.2 new v$ QMON views - February 11, 2012
11.2 new v$ iostat views
- February 11, 2012
Oracle 11.2 new
GoldenGate v$ views - February 11, 2012
Oracle 11.2 new v$ dnfs
views - February 11, 2012
11.2 new v$ diag views - February
11, 2012
Oracle 11.2 new AWR Tables
- February 11, 2012
11.2 new v$ views - February
11, 2012
column "set
unused" drop column tips - February 9, 2012
SQL to select tables with rows -
February 9, 2012
Streams
Logical Standby as propagator the receiver - February
6, 2012
How to
display and show referential integrity constraint violations - February
3, 2012
What does TKPROF stand
for? - February 2, 2012
Difference between db block gets and consistent gets and physical reads? February
2, 2012
SQL to exclude rows
without strings - January
31, 2012
Oracle sharding tips - January
31, 2012
x$ir
incident reporting tips - January
27, 2012
x$ir incident reporting
tips - January
27, 2012
ORA-22835: Buffer too small
tips - January
27, 2012
x$ kernel service & cache table
tips - January
26, 2012
v$memory_dynamic_components tips EOI- January
26, 2012
11g Streams v$ Views EOI- January
26, 2012
Oracle 11g RMAN v$ Views EOI- January
26, 2012
Oracle 11g ASM v$ Views EOI- January
26, 2012
11g SQL Tuning v$ Views -
EOI- January 26, 2012
Oracle 11g SGA Pool v$
Views -
EOI- January 26, 2012
Oracle 11g RMAN v$ Views -
EOI- January 26, 2012
parallel/partition aware SQL
tips January 25, 2012
Oracle packet analyzer tips - January
24, 2012
Display directory file sizes
- January 24, 2012
Get root system user
privileges on a Windows server - January 20, 2012
example stored procedure - January
20, 2012
extproc: no such file
or directory - January 19, 2012
alter database datafile
resize Tips - January 19, 2012
SQL 2nd highest row value tips
- January 19, 2012
incremental statistics tips -
January 18, 2012
ORA-00704 bootstrap
process failure tips - January 18, 2012
alter database create
datafile - January 17, 2012
alter database add logfile - January 17, 2012
alter database add datafile
tips - January 17, 2012
add tempfile temp tips - January 17, 2012
add partition tips - January 17, 2012
User password encryption tips
- January 17, 2012
Physical Standby Database
tips - January 17, 2012
Data Guard archive redo
gap tips - January 12, 2012
Server side Data Guard
broker tips - January 12, 2012
Data Guard
standby database recovery mode tips - January 12, 2012
Flashback Sizing - January 12, 2012
Example Data Guard
Configuration - January 12, 2012
Data Guard operational
constraints - January 12, 2012
Data Guard Background
processes tips - January 12, 2012
Data Guard Standby Tips - January 12, 2012
Data Guard Logical Standby
Tips - January 12, 2012
Data Guard Manual Failover Tips
- January 12, 2012
Data Guard Disaster Recovery
tips - January 12, 2012
Oracle-02236 Tips - January 11, 2012
Virtual Circuit wait tips - January 11, 2012
Justify migrating
from Windows to Linux - January 10, 2012
Windows DOS vs. Unix
commands - January 10, 2012
v$datafile_header tips - January 9,
2012
dbms_stats.set_column_stats tips
- January 9, 2012
dbms_stats.set_index_stats
tips - January 9, 2012
dbms_stats.set_table_stats
tips - January 9, 2012
dbms_sqldiag tips
- January 8, 2012
v$iostat_file tips
- January 8, 2012
v$iostat_consumer_group tips - January 8, 2012
v$iostat_function tips - January 8, 2012
publish
pending stats tips - January 8, 2012
v$sql_plan_monitor tips - January 8, 2012
dba_audit_exists Tips - January 7, 2012
dba_audit_trail Tips - January 7, 2012
dba_audit_session Tips - January 7, 2012
Oracle Auditing Tips - January 7, 2012
dba_audit_statement tips - January
6, 2012
dba_audit_object tips - January 6, 2012
dba_obj_audit_opts tips - January
6, 2012
dba_priv_audit_opts tips - January
6, 2012
dba_stmt_audit_opts - January 6, 2012
Monitoring TEMP
tablespace activity - January 5, 2012
Monitoring tablespace usage
tips- January 5, 2012
oraenv tips - January 5, 2012
Automatic Oracle startup
on Windows Tips - January 5, 2012
Automatic Oracle startup
on HP/UX Tips - January 5, 2012
Automatic Oracle startup on
AIX Tips - January 5, 2012
Automatic Oracle startup
on Linux Tips - January 5, 2012
Automatic Oracle startup
on Solaris Tips - January 5, 2012
CDC with CLOB example - January 5, 2012
RMAN-06059 Tips - January 4, 2012
RMAN crosscheck Tips - January 4, 2012
db_recovery_file_dest_size
Tips - January 4, 2012
Oracle ROWID Tips - January 2, 2012
See All Roles Granted to a User Tips- January 2, 2012
db_lost_write_protect tips - January 2, 2012
db_block_checksum tips - January 2, 2012
db_ultra_safe Tips - January 2, 2012
Fix frequent log switches - January 1, 2012
Delete shared
memory segments in Windows - January 1, 2012
SOPA Act to shut-down foreign web
sites! - January 1, 2012
Mismanaging data queues with
dbms packages
December 27, 2011
Translate
dropped recycle bin table tames -
December 27, 2011
Becoming an OBIEE or SAS Data
Analyst -
December 26, 2011
dbms_packages util release
dates -
December 21, 2011
Save transportable
tablespace database link -
December 21, 2011
Save Secure
Oracle Passwords online -
December 17, 2011
Example of RMAN shell script -
December 17, 2011
display all years
between two dates -
December 16, 2011
Add Datafile to Oracle -
December 16, 2011
Alter Tablespace Add Datafile -
December 16, 2011
Foreign Key Constraint Tips -
December 16, 2011
Unique Constraint Tips -
December 16, 2011
Primary Key Constraint Tips -
December 16, 2011
NOT NULL Constraint Tips -
December 16, 2011
Check Constraint Tips -
December 16, 2011
Oracle TCL Tips -
December 16, 2011
Oracle DCL Tips -
December 15, 2011
Make a custom Oracle
error message -
December 14, 2011
ORA-24010 tips -
December 13, 2011
JMS-178 Invalid Queue name -
December 12, 2011
Oracle Inactive Session Tips -
December 12, 2011
Concurrent DML & DDL Tips -
December 9, 2011
nested_table_set_refs Tips -
December 9, 2011
TNS-12502 Tips - December 5, 2011
Oracle SQL tuning with
cardinality estimates - December 4, 2011
Stop unauthorized
connections to Oracle - December 3, 2011
Oracle 2012 Salary Tips - December 3, 2011
ADRCI Error
19809 creating archive log file - December 1, 2011
SQL to display
all months between two dates - December 1, 2011
dbms_assert tips - December 1, 2011
Oracle convert ANSI to UTF8 - November 27, 2011
Oracle convert function - November 27, 2011
ORA-00924 Missing BY keyword
tips - November 23, 2011
v$asm views and x$ tables for ASM - November 23, 2011
Oracle ASM Parameters
- November 23, 2011
ASM data file name tips - November 23, 2011
ORA-12514
on Data Guard Switchover - November 21, 2011
dbms_apply_adm.set_schema_instantiation_scn tips - November 21, 2011
dba_segments tips - November 20, 2011
dbms_libcache tips - November 19, 2011
ORA-15064 tips - November 19, 2011
ORA-26840 tips - November 19, 2011
Oracle Reinstantiation Tips -
November 19, 2011
emcli command tips - November 19, 2011
List all table and column
privileges - November 19, 2011
How to export/unload a BLOB/CLOB - November 19, 2011
Oracle instance_role tnsnames tips
- November 19, 2011
ORA-29702 ksuitm: waiting - November 19, 2011
Shrink TABLESPACE Tips - November 19, 2011
Add a foreign key constraint to a
table with duplicates - November 18, 2011
Oracle e-mail attachment tips
- November 18, 2011
RMAN could not locate
the LNM save file tips - November 18, 2011
Using the RMAN
Duplicate command - November 18, 2011
How to encrypt data to one
listener - November 17, 2011
Difference between
dbms_output.put_line and utl_file.put_line
-
November 17, 2011
Automate export to
test instance - November 17, 2011
Intermittent ORA-01017 errors -
November 17, 2011
Display disabled instances in CRS
- November 17, 2011
Intermittent Oracle client
connect problem - November 17, 2011
Count by year in a date columns - October 31, 2011
Count by month in a date columns - October 31, 2011
Count by day in a date columns - October 31, 2011
Loadjava sql/oracle/BLOB
jar file not found - October 31, 2011
Find the SID for a dbms_job
dbms_scheduler job - October 30, 2011
dba_lobs tips - October 30, 2011
dbms_lob.getlength - October 30, 2011
Oracle
Network Adapter could not establish the connection tips - October 29, 2011
Dynamic query for
column min and max values - October 29, 2011
******
Copying Oracle datafiles
between Linux and Windows servers - October 29, 2011
Oracle adding dates - October 29, 2011
Oracle storage parameter
exceptions - October 29, 2011
Estimate Size of Last RMAN Backup
- October 27, 2011
Oracle RMAN Number of
Days Since Last Backup - October 26, 2011
Oracle Best
Fastest Way to Delete Data from Large Table Tips - October 25, 2011
Building a Dynamic SQL
Statement - October 25, 2011
Detecting
Misspelled Row Column Data in Oracle - October 22, 2011
Name
Validation Using Oracle Regular Expression Syntax - October 22, 2011
Find Numeric
Data in Oracle Character Column - October 22, 2011
Oracle Storage Parameter
Exceptions - October 11, 2011
filesystemio_options Tips -
October 4, 2011
Oracle Introduces Sunfire SSD Firmware Appliance - October 4, 2011
trcasst Tips - October 3, 2011
Oracle sql_trace Tips - September
30, 2011
trcsess Tips - September 28, 2011
Oracle
Linux Introduces Zero Downtime Operating System Upgrades - September 27,
2011
Oracle Urges
Fix for Apache Killer - September 26, 2011
Integrating HP
Data Protector with Oracle - September 21, 2011
ALTER SYSTEM SWITCH LOGFILE vs ALTER SYSTEM ARCHIVELOG CURRENT -
September 21, 2011
Find All References to
an Oracle Table - September 16, 2011
ORA-00020: maximum
number of processes exceeded - September 15, 2011
Fastest Way to Rebuild
Oracle Index - September 15, 2011
Get Length of a Row - September 15,
2011
Difference
Between Compiled and Interpreted PLSQL - September 14, 2011
Foreign Bribery Expense
Legality - September 9, 2011
Oracle Copy Schema Tips -
September 9, 2011
RMAN v$archived log NULL -
September 6, 2011
Display the
Difference Between Two Dates in Oracle - September 5, 2011
Creating Multiple Listeners
Tips - September 3, 2011
dbms scheduler alter
running chain Tips - September 1, 2011
Add a Comment to a View - August
31, 2011
Save Oracle Email Tips -
August 31, 2011
Oracle SQL Where 1 Equals 1
- August 31, 2011
TNS 00510
Internal Limit Restriction Exceeded - August 29, 2011
ORA-39146 Directory
Object Parameter Tips - August 29, 2011
Linking Oracle with Teradata
- August 28, 2011
Dangerous
Commands to Disable Linux UNIX Server - August 27, 2011
Monitor
Performance of Oracle Parallel Server - August 27, 2011
Scripting UNIX Commands -
August 27, 2011
UNIX Add OS Date to
Filename - August 27, 2011
Access MySQL with Bash
Shell Script - August 27, 2011
Access MySQL Database
with Perl Script - August 27, 2011
Understanding Oracle
Explain Plan - August 26, 2011
Optimal Value for
job_queue_processes - August 25, 2011
Oracle RAC Cache Fusion -
August 12, 2011
Oracle Virtual Columns - August
12, 2011
ORA 39726 Tips - August 11, 2011
Find Oracle Archive Logs -
August 11, 2011
Oracle Dictionary select any dictionary and select_catalog_role - August
10, 2011
ORA 19815 Warning - August 9, 2011
Reading an Oracle Shell
Script - August 9, 2011
How to Write an
Oracle Shell Script - August 9, 2011
Restart a Failed Daemon
Process - August 8, 2011
ORA-20000
ORU-10027 buffer overflow limit of 2000 bytes - July 21, 2011
Oracle RAC vs Grid - July 20, 2011
Oracle Find First Row - June 30,
2011
Oracle Find Latest row - June
30, 2011
Oracle Find Last Row -
June 30, 2011
ORA-14552
Cannot Perform a DDL Commit or Rollback - June 29, 2011
Oracle Pragma
Autonomous Transaction - June 29, 2011
Oracle
Analyze Function Based Index Not Working - June 29, 2011
QSM 02077 Materialized View Log is Newer Than Last Full Refresh - June
29, 2011
Tuning
Correlated Subqueries for Fast Speed - June 23, 2011
How to Make PLSQL
Updates Restartable - June 21, 2011
Oracle Export Import Tips
- June 21, 2011
Oracle Flashback Status - June
21, 2011
dba_flashback_archive Tips - June
21, 2011
Oracle RAC etc resolv conf file
Tips - June 20, 2011
Oracle IO Per Second IOPS Tips
- June 20, 2011
Oracle RAC etc named conf File
Tips - June 20, 2011
RAC root sh
Failure at Final Check of Oracle CRS Stack - June 19, 2011
Find Slow Oracle SQL - June 17,
2011
The Best Oracle Commit
Frequency - June 17, 2011
Oracle Scope Options - June 17, 2011
Oracle Deadlock Waits - June 17, 2011
Oracle Row Lock and Row Level
Locking - June 16, 2011
ORA-03135 Connection Lost
Contact Tips - June 15, 2011
emoms properties File Tips - June
14, 2011
Convert Oracle Integer to
Time - June 14, 2011
ORA-01152 File 1 was Not Restored From a Sufficiently Old Backup - June
14, 2011
ORA-04033
Insufficient Memory to Grow Pool - June 14, 2011
Oracle Hash Tips - June 14, 2011
ORA-10878 Parallel Recovery Slave Died Unexpectedly Tips - June 14, 2011
Oracle Hints - June 13, 2011
pct_direct_access Tips - June 13, 2011
Oracle Pre-upgrade Utility Tips
- June 13, 2011
Oracle JPA Tips - June 13, 2011
Oracle
Boolean Expressions in Check Constraints - June 10, 2011
Oracle SVC Replication - June 9, 2011
Oracle Purge Tablespace - June
9, 2011
Create SQL Plan Baseline Tips -
June 9, 2011
Query Oracle Partition Size
- June 9, 2011
DBMS Space Usage Tips - June
8, 2011
Oracle Purge Recycle Bin -
June 8, 2011
ORA-27090
Unable to Reserve Kernel Resources Error Tips - June 8, 2011
Oracle Read Only User - June 8,
2011
ORA 28545 Oracle to
MySQL Connection Error Tips - June 7, 2011
Oracle
Deadlock Difference Between 10g and 11g - June 7, 2011
Oracle Mutex Tips - June 7, 2011
Oracle Silent Mode - June 7, 2011
ORA-12155 Internal TNS
Error Tips - June 6, 2011
Convert UNIX
Epoch Date to Oracle Display Value - June 6, 2011
develop facebook
applications - June 5, 2011
RJDBC Tips - June 4, 2011
ROracle Tips - June 4, 2011
Tuning Oracle Wait Events -
June 4, 2011
RMAN COPY Command Tips - June 4,
2011
Oracle Cardinality Tips - June
4, 2011
ORA-06530
Reference to Uninitialized Composite Tips - May 30, 2011
Oracle Large Pages - May 30, 2011
Historical Bind Variable
Storage - May 30, 2011
How to
Install Discoverer with a Windows DOS Command Script - May 27, 2011
enq TX - Row Lock Contention
Error - May 27, 2011
New Schema or New Instance -
May 19, 2011
Pause SQL
Execution at Screen Display Time - May 18, 2011
Estimate Rows Returned by SQL
- May 18, 2011
Oracle Range Partioning -
April 29, 2011
GoldenGate suppresstriggers Tips
- April 28, 2011
Oracle Installer File
Location - April 27, 2011
Oracle Dirty Reads - April 26, 2011
Oracle Isolation Level Tips -
April 25, 2011
Oracle GoldenGate 11g -
The Bridge to Everywhere - April 25, 2011
Oracle
Deprecates cursor sharing equals similar - April 25, 2011
How to Add Space
to an Oracle Linux Directory - April 25, 2011
Page Not Found on OEM Tips -
April 22, 2011
Oracle UDP Tips - April 22, 2011
recv_buf_size and send_buf_size
tips - April 20, 2011
Oracle BDP tips - April 20, 2011
Data Guard synchronous (SYNC)
vs asynchronous (ASYNC) modes - April 20, 2011
LNS wait on SENDREQ tips - April 19, 2011
Materialized View with Object Type Fails with ORA 00904 - April 18, 2011
RMAN-06429 Database is
Not Compatible With This Version of RMAN - April 14, 2011
index_fss Hint - April 13, 2011
use_concat Hint - April 12, 2011
Oracle DDL Auditing - April 11, 2011
ORA-00344 Unable to Re-create Online Log - April
9, 2011
Oracle SQL Profiles - April 8, 2011
ORA-00344 Unable to
Re-create Online Log - April 7, 2011
Oracle Display Controlfiles
- April 7, 2011
Backup Controlfile Recovery
- April 7, 2011
ORA-01578: ORACLE data
block corrupted - April 7, 2011
ORA-28575 Tips - April 7, 2011
How to export
between releases of Oracle - April 7, 2011
Pass Parameter to Oracle SQL
- April 6, 2011
Windows OS Authentication in
11g - April 6, 2011
ORA-12713
Character Data Loss NCHARCHAR Conversion - April 6, 2011
ORA-01122 Database File Failed Verification - April 4, 2011
Oracle Add Controlfile Tips -
April 4, 2011
OPN
PartnerCasts - Tool or Infomercial - April 4, 2011
ORA-30657 External Table Tips
- April 4, 2011
OERR Action - Do Not Do That
- April 1, 2011
Oracle and COBOL return - April
1, 2011
Table to Display db time
from AWR - March 31, 2011
TNS-12514 on Windows - March 30,
2011
Oracle Quota Error Tips - March 29,
2011
Oracle Deferred Segment
Creation Tips - March 29, 2011
Oracle Surrogate Key Tips - March 29, 2011
Oracle Flash Recovery Area FRA
Tips - March 25, 2011
Oracle Column Default Value Tips
- March 25, 2011
Oracle
Daylight Savings Time DST Date Conversion Tips - March 25, 2011
ORA 01456 May Not Perform Operation Inside a READ ONLY Transaction Tips
- March 24, 2011
Oracle Candidate Key Tips - March 23,
2011
RMAN 05001 Auxiliary Filename Conflicts with a File Used by the Target
Database Tips - March 21, 2011
Hypercharge Oracle with Intelligent Indexes - March 21, 2011
Execute
Simultaneous Synchronous Oracle Jobs - March 21, 2011
How to Recover an
Oracle Dropped Column - March 21, 2011
ORA 00119 with DBCA - March 21, 2011
Oracle Built in PLSQL
exceptions - March 21, 2011
Ignoring Oracle ORA
Errors in PLSQL - March 21, 2011
dbms_stats.create_extended_stats tips - March 19, 2011
Why is Oracle male? - March 19, 2011
RMAN ORA-12520 Connect Error
Tips - March 17, 2011
Oracle Cloud File System Tips -
March 17, 2011
Using Export exclude equals index
Tips - March 16, 2011
ORA-24345 Null Fetch Tips - March
16, 2011
Oracle SQL
Join Factorization Transformation (JFT) Tips - March 15, 2011
Oracle UNION Tips - March 15, 2011
Oracle UNION ALL Tips - March 15,
2011
Oracle add_years Tips - March 15, 2011
ORA-12504 TNS
Listener Not Given SID - March 15, 2011
BEWARE: Oracle
11g New Feature Causes AMM to Restart - March 14, 2011
Oracle Checkpoint Not
Complete Tips - March 9, 2011
Hung Database Analysis Tips -
March 9, 2011
PLS-00421 and ORA-04055
Encountered Tips - March 9, 2011
sqlplus: command not found Tips
- March 8, 2011
RMAN-20202 tips - March 8, 2011
dbms_xmlgen.getxml Output Spans Multiple Lines - March 8, 2011
PLS-00642: Local Collection Types Not Allowed in SQL Statement - March
7, 2011
Changing of the
Guard at Oracle Corporation - March 4, 2011
ORA-30625: Method Dispatch on NULL SELF Argument Is Disallowed -March 2,
2011
ORA-02327: Cannot Create Index on Expression with Datatype - March 1,
2011
ORA-01659: Unable to Allocate MINEXTENTS Beyond String in Tablespace String
- February 28, 2011
ORA-01445: Cannot Select ROWID from a Join View without a Key-Preserved
Table - February 25, 2011
ORA-19502: Write Error on File Tips - February 24, 2011
ORA-16055: FAL Request
Rejected - February 23, 2011
ORA-29902: Error in Executing ODCIIndexStart Routine - February 22, 2011
Using
dbms_output.put_line in Scheduled Job Script - February 22, 2011
Dumbest Oracle Error
Message - February 22, 2011
OS-Error: OS 5 Access is Denied
Tips - February 22, 2011
ORA-00824: Cannot Set sga_target Due to Existing Internal Settings -
February 21, 2011
ORA-24344: Success
with Compilation Error - February 18, 2011
ORA-01720: Grant Option Does Not Exist
- February 18, 2011
Passing SQLPlus
Variable in Shell Script - February 17, 2011
ORA-16014: Log sequence# not archived, no available destinations
-
February 17, 2011
database_properties tips - February
17, 2011
ORA-12899: Value too
Large for Column - February 17, 2011
ORA-27300: OS
System Dependent Operation failed with status - February 16, 2011
ORA-01801: Date Format is too Long for Internal Buffer - February 15,
2011
ORA-01012: job
fails when placed in crontab - February 14, 2011
Removing Oracle RAC
sequence contention - February 14, 2011
ORA-15033: disk
belongs to diskgroup - February 14, 2011
ORA-12012: Error on Auto
Execute of Job - February 11, 2011
Downgrading Oracle Enterprise Edition (EE) to Standard Edition (SE) -
February 10, 2011
Single Quote Apostrophe Marks Change to Upside Down Question Marks -
February 10, 2011
ORA-01756: Quoted String Not Properly Terminated -February 9, 2011
Oracle RAC CRS Services - February 9,
2011
ORA-29285 - File Write Error
- February 8, 2011
Oracle
Concurrent statistics gathering - February 7, 2011
Learn Oracle’s Hidden Kernel
Subsystem Designators - February 7, 2011
Oracle response time
components - February 7, 2011
ORA-22804: remote operations not permitted on object tables or user-defined
type columns - February 1, 2011
Re-create oraInventory
with Oracle Universal Installer - January 26, 2011
ORA-04084: cannot change NEW values for this trigger type - January 17,
2011
ORA-27191: sbtinfo2
returned Error Tips - January 10, 2011
Oracle SQL profile Tips - January
7, 2011
SQL to change all in a table - January
7, 2011
Remove all
special characters from table rows - January 7, 2011
Foreign key on delete
cascade tips - January 6, 2011
Foreign key indexing tips - January 6, 2011
Tightly packing table rows onto
data blocks - January 6, 2011
SQL Server vs Oracle
terminology - January 4, 2011
Download Oracle Table Rows Into Separate Excel Spreadsheets - January 3,
2011
Non-correlated subquery tips - January 3, 2011
Save and re-set an Oracle
user password - January 3, 2011
Oracle drop table if exists - January 1, 2011
ORA-00609: could not attach to
incoming connection tips - January 1, 2011
tns_admin tips - January 1, 2011
Compare dates in oracle - January 1, 2011
v$osstat tips - January 1, 2011
Oracle Upgrade Best
Practices - December 29, 2010
Oracle Patchset
Does Not Update v$version - December 29, 2010
Alternatives to
tnsnames.ora File - December 29, 2010
Create tnsnames.ora - December 28,
2010
Create listener.ora - December 28,
2010
Create sqlnet.ora - December 28, 2010
ORA-25141:
invalid EXTENT MANAGEMENT clause tips - December 27, 2010
Recovering a
Dropped Oracle User with Flashback - December 27, 2010
SQL Alternative to UNION
clause - December 23, 2010
Oracle JDBC Connection
Testing - December 23, 2010
ORA-39087: directory name
is invalid tips - December 23, 2010
SQL*Plus COLUMN FORMAT tips -
December 21, 2010
Do not use lsnrctl and sqlplus as
SYSDBA in 11g release 2 RAC - December 20, 2010
Removing ASM datafiles
from disk - December 20, 2010
ORA-19804:
cannot reclaim string bytes disk space - December 17, 2010
Oracle Sniped Session tips -
December 16, 2010
Oracle Create Database
Parameters tips - December 15, 2010
Oracle ALTER SESSION tips -
December 15, 2010
Oracle ALTER SYSTEM tips - December
15, 2010
ORA-03134 tips - December 14, 2010
Oracle SCAN for RAC tips - December 13, 2010
"show errors" tips - December 13, 2010
Oracle SSO tips - December 11, 2010
Oracle Enterprise Single
Sign-on (ESSO) tips - December 11, 2010
Configuring X
Windows for the Oracle Installer - December 9, 2010
Oracle Data Dictionary
Statistics tips - December 8, 2010
Oracle SYSDBA tips - December 8, 2010
Oracle Hash Join Right Semi tips
- December 7, 2010
Oracle listagg Function -
December 7, 2010
TNS-12545: Connect Failed Because Target Host or Object Does Not Exist tips
- December 6, 2010
SQL*Net Round Trip Tracing tips
- December 6, 2010
SQL*Net tracing tips - December 3, 2010
ORA-12014: table does not contain a primary key constraint tips -
December 3, 2010
Oracle Hash Aggregation Tips -
December 2, 2010
SQL Grouping by Timestamp -
December 1, 2010
Create a
Materialized View Using a Database Link - November 30, 2010
Oracle ASM Dictionary Tables
- November 29, 2010
ORA-01920: user name 'string' conflicts with another user or role name -
November 29, 2010
Suppressing
NULL Column Values in SQL Output - November 29, 2010
Oracle port number tips - November
24, 2010
Multiple schema
copies on an Oracle server tips - November 24, 2010
Archived redo
logs on shared ASM storage - November 24, 2010
ORA-31623: A Job is Not Attached to This Session Via the Specified Handle
tips -November 24, 2010
How to Flush AWR Data -
November 24, 2010
Disabling Oracle
Cartesian Merge Joins - November 23, 2010
Oracle Lightweight Directory Access Protocol
(LDAP) - November 23, 2010
PL/SQL
Execute Immediate and Error Trap Checking - November 22, 2010
Enterprise Manager is not able to connect to the Database instance -
November 2, 2010
nls_date_format tips - October 2,
2010
SQL wm_concat function - September 19, 2010
Oracle Business
Intelligence 11g - September 18, 2010
New Features in
Oracle Warehouse Builder - September 18, 2010
Data pumping Convenience -
September 18, 2010
Performance Tuning Tools - September 17, 2010
Simplify Code Using PL/SQL
- September 17, 2010
Multiple Redo log threads - September 17, 2010
Procedure works in SQL but
not the scheduled job - September 16, 2010
Listener Service Registration
- September 15, 2010
ORA-01284: file
string cannot be opened tips - September 14, 2010
PLS-00109: unknown
exception name tips - September 14, 2010
Display row where count(*) is
zero? - September 4, 2010
Make a list of public holidays
dates - September 3, 2010
Oracle undo_retention tips - September 1, 2010
Oracle Streams to be
rolled into GoldenGate - September 1, 2010
Estimating the
maximum results from a paginated Oracle SQL query - September 1, 2010
ORA-29260:
network error: TNS:lost contact tips - August 27, 2010
Exporting
dbms_stats tips - August 27, 2010
ORA-12514: TNS:listener does not currently know of service requested in
connect descriptor - August 27, 2010
Oracle local listener tips - August 27, 2010
Inside the Oracle DBA boot camp
scam - August 26, 2010
Add a new instance to
a server tips - August 26, 2010
Where does the optimizer find details on disk RAID, stripe size and
blocksize? - August 25, 2010
Oracle Stress Testing Tips
- August 24, 2010
Oracle System Testing tips
- August 24, 2010
Large DML insert/update
hanging tips - August 24, 2010
Local vs. global
partitioned index query tips - August 23, 2010
How to move an Oracle database
between platforms - August 20, 2010
Oracle time display mismatch
tips - August 20, 2010
Generating dates from
dbms_scheduler - August 19, 2010
ORA-12058:
materialized view cannot use prebuilt table tips - August 18, 2010
ORA-30678 too many open
connections tips - August 18, 2010
SAMPLE FAST FULL SCAN Tips - August 16, 2010
Oracle composite
index column ordering - August 16, 2010
Send text message e-mails from
OEM - August 15, 2010
Send
e-mails from Oracle to cell phone mobile SMS devices - August 15, 2010
America's top Oracle
experts - August 13, 2010
ORA-25001: cannot
create this trigger type on views tips - August 13, 2010
RAC cluster verify (cluvfy)
utility tips - August 13, 2010
Trace RAC CRS tips - August 12, 2010
Oracle convert number to
float tips - August 11, 2010
Oracle disable partitioned
index tips - August 11, 2010
Oracle disable index tips - August
11, 2010
skip_unusable_indexes tips - August
11, 2010
Troubleshooting slow SQL
- August 9, 2010
Script to remove old trace
files in Windows - August 8, 2010
Removing old
archived redo log files in Windows - August 8, 2010
Materialized Views
and Database Links - August 8, 2010
Oracle move partition tips -
August 8, 2010
Plugging-in a tablespace -
August 8, 2010
RMAN
Recoverable Image Copy tips - July 30, 2010
nmccollector.exe program tips - July
30, 2010
Multiple alert logs in
RAC - July 29, 2010
Oracle TOAD technical
support - July 28, 2010
Oracle predictive modeling
software - July 28, 2010
Step to create NFS/NAS disks for
ASM - July 26, 2010
import ORA-04030 error tip - July 25, 2010
dbms_ddl.wrap procedure tips - July 24, 2010
Wrapping an Oracle package body - July 24, 2010
Force a materialized view
refresh - July 23, 2010
Oracle sessions parameter tips - July 23,
2010
Multiple instances on a server
tips - July 23,
2010
Suspending a schedule job
tips - July 22,
2010
Data Pump sqlfile parameter
tips - July 22,
2010
ddl_lock_timeout tips - July 22,
2010
dbms_datapump metadata_remap
tips - July 21,
2010
Oracle Storage Indexes - July 21,
2010
Oracle redo log usage tips - July 20,
2010
Order by NULLS first tips - July 19,
2010
Oracle test cases vs. benchmarks
- July 18,
2010
accuracy vs. precision
examples - July 18,
2010
ORA-01194: file needs more recovery to be consistent tips - July 17,
2010
How to get the
exact time in Oracle - July 17, 2010
Excessive empty
space within a table tips - July 16, 2010
Oracle Bug Code List - July 15, 2010
Locally Managed
Tablespaces (LMT) benefits - July 14, 2010
Oracle OCA
requirements tips - July 13, 2010
Oracle UGA Tips -
July 9, 2010
Oracle design third normal
form -
July 9, 2010
ORA-01994: GRANT
failed orapwd file tips -
July 6, 2010
ORA-01743: only
pure functions can be indexed Tips -
July 5, 2010
Oracle DBUA Upgrade Tips
-
July 3, 2010
Sample tnsnames.ora file -
July 2, 2010
Sample sqlnet.ora file -
July 2, 2010
Sample listener.ora file -
July 2, 2010
TNS-01192 SID listener tips - July
2, 2010
Apex cannot print PDF
with ORA-12570 error - July 1, 2010
ORA-12570: TNS:packet
reader failure tips - July 1, 2010
open source oracle
reporting software - June 29, 2010
Move a file to ASM storage tips - June 27, 2010
Create a standby database
using RMAN - June 25, 2010
David Ellison: Heir to the Oracle throne?
- June 21, 2010
Oracle
whistleblower asks for $42,000,000 reward - June
18, 2010
oracle log switch frequency - June
17, 2010
Oracle table fragmentation - June
16, 2010
Overloading
oracle functions and stored procedures - June 15, 2010
Display stored
procedure arguments - June 15, 2010
ORA-16608:
One or more databases have warnings - June 14, 2010
RMAN-06172 no autobackup
found tips - June 14, 2010
Using v$datafile to track
database growth - June 14, 2010
dba_hist_tablespace_stat tips
- June 12, 2010
Remove
trailing spaces with trimspool - June 11, 2010
2010 Oracle offshoring a
disaster - June 10, 2010
ORA-29702 and
ORA-15032 caught in ASM I/O path - June 10, 2010
Startup error ORA-16433
after RMAN cloning - June 10, 2010
2010 Oracle layoffs may
exceed 10,000 - June 9, 2010
Oracle global vs.
local partitioned indexes - June 4, 2010
Startup error ORA-48175 tips - June 3,
2010
Two Phase Commit 2PC Tips - June
2, 2010
Named subqueries in Oracle SQL - May 29, 2010
Ideal personality
type for a production support DBA - May 29, 2010
Import impdp ORA-39083 fix
- May 29, 2010
Oracle view temp tablespace
segment tips - May 28, 2010
How to use bad
credit reports against employees - May 27, 2010
Transparent Data Encryption TDE with export import tips - May 27, 2010
Transporting TDE encrypted columns with export import encryption_password
parameter - May 27, 2010
Oracle ZFS holding RAM memory
- May 27, 2010
dbms_stats analyze index
syntax - May 26, 2010
Releasing PGA RAM from
xmldata - May 26, 2010
11g RMAN cloning - May 26, 2010
Screening job
applicants for immoral behavior - May 26, 2010
Database resident connection pooling (DRCP) vs Shared Servers (MTS) - May 26, 2010
Tuning execution plans for global temporary table and WITH clause
materializations - May 26, 2010
Oracle sequence cache misses tips
- May 23, 2010
Streams propagation error
ORA-26851 - May 23, 2010
Oracle active database
duplication - May 23, 2010
11g encrypted tablespace tips
- May 23, 2010
Oracle transparent data
encryption - TDE Tips - May 23, 2010
11g compound triggers - May 23, 2010
11g dynamic SQL Tips - May 22, 2010
Oracle unlimited licenses
have limits? - May 21, 2010
ORA-04061:
Existing state of string has been invalidated Tips - May 21, 2010
Uninstall/deinstall OEM
Enterprise Manager - May 21, 2010
Oracle read only table -
May 20, 2010
Oracle: The requested URL
was not found on this server -
May 20, 2010
Oracle SQL WITH clause
connect by isleaf -
May 20, 2010
ORA-12532: TNS: invalid
argument tips -
May 19, 2010
dba_sql_plan_baselines tips -
May 19, 2010
Oracle 11g upgrade
performance problems -
May 18, 2010
Oracle 11g
resource_manager_plan new features -
May 18, 2010
ORA-01926:
cannot GRANT to a role WITH GRANT OPTION -
May 17, 2010
Oracle 11g OEM new features -
May 16, 2010
ORA-01466: Unable to read data -- Table definition has changed -
May 15, 2010
Flashback error ORA-06553: PLS-213: package STANDARD not accessible -
May 14, 2010
I/O bandwidth
monitoring for multiple instances -
May 14, 2010
Complex SQL Query Nesting Tips
-
May 14, 2010
Oracle Partitioning Pruning Tips -
May 14, 2010
Oracle Global Index vs.
Local Index - May 14, 2010
SQL*Plus Timing Start
command tips - May 14, 2010
Streams Heartbeat Tips - May
13, 2010
dbms_metadata.set_remap_param tips - May 13, 2010
dbms_metadata.set_transform_param tips - May 13, 2010
ORA-26672: timeout occurred while stopping STREAMS process Tips - May 12, 2010
Oracle lexical parameter Tips - May 11, 2010
FRM-40509: Unable
to UPDATE record Tips - May 11, 2010
Kamran Agayev wins Oracle ACE
award - May 10, 2010
RMAN backup Optimization -
May 10, 2010
SP2-0310 unable to open file
tips - May 10, 2010
ORA-30042:
Cannot offline the undo tablespace tips - May 10, 2010
There is no
irreplaceable man poem - May 8, 2010
Oracle rlwrap tips - May 8, 2010
Computer Database sex
gender codes - May
7, 2010
Sizing the Data
Guard SQL Apply LCR cache - May
7, 2010
Trace a RAC deadlock - May
7, 2010
Oracle UNDO management tips - May
6, 2010
Insert Oracle CLOB column - May
5, 2010
Oracle ASM with NSF - May 4, 2010
_parallel_min_table_threshold tips - May 2, 2010
parallel_degree_policy tips - May
2, 2010
RAC Node
affinity with parallel instance groups - May 1, 2010
ADRCI command tips! - May 1, 2010
Massachusetts State Privacy Law to effect hundreds of Oracle databases - April 29, 2010
Oracle societies & clubs - April 29, 2010
Oracle cardinality feedback tips - April 29, 2010
Installing Oracle on
Oracle Enterprise Linux - April 26, 2010
Drop UNDO tablespace
with active segment - April 26, 2010
Oracle server Internal file
cache vs. JFS cache - April 25, 2010
dbms_utility.get_parameter_value tips - April 25, 2010
ORA-00267:
name of archived log file not needed tips - April 25, 2010
Oracle with multiple
physical disk blocksize - April 15, 2010
Oracle Wallet
Secure external password file - April 15, 2010
Secure an external password
file in Oracle - April 15, 2010
Oracle Pro*C SQL Array processing
- April 15, 2010
Optimizer
statistics for temporary tables - April 15, 2010
Oracle fixed statistics tips - April 15, 2010
ASM background timer tips - April 15, 2010
v$sql scripts - April 14, 2010
SQL Jokes! - April 14, 2010
Migrate Oracle OCR to ASM - April 12, 2010
Oracle Compatibility Matrix
- April 12, 2010
Oracle Performance
Management - April 12, 2010
Oracle Performance Tuning
Guide - April 12, 2010
Oracle Performance Tips
- April 12, 2010
Oracle Performance Tuning
tools - April 12, 2010
ORA-56920 tips - April 12, 2010
Oracle
dbms_dst Database is using a timezone file older than version 11 tips - April 12, 2010
ORA-39714: upgrade
script utlmmig.sql failed tips - April 11, 2010
Oracle data modeling tips - April 11, 2010
utlrp.sql
ORA-04020 error on dbms_standard - April 11, 2010
Inventor
of Java resigns Oracle - April 11, 2010
sqlpath Windows Registry
Entry tips - April 11, 2010
2010 Top
Computer Information Systems jobs - March 15, 2010
Corporate travel
etiquette manners - March 9, 2010
RMAN catalog command tips
- February 21, 2010
set timing on tips
- February 17, 2010
Measure run time for Oracle SQL
- February 17, 2010
Oracle recover with missing
redo log
- February 15, 2010
SQL*Loader (sqlldr) example syntax - February 15, 2010
Linux Antivirus for
Oracle Tips - February 15, 2010
Migrating Oracle SQL Profiles
February 12, 2010
ORA-00445 background process PMON did not start tips - February 11,
2010
ORA-1115 IO error
reading block from file - February 11, 2010
Find the high
water mark of parallel query processes - February 11, 2010
How to read
distributed SQL execution plans - February 11, 2010
Oracle n-way Streams
replication - February 9, 2010
ORA-00279:
change string generated tips - February 2, 2010
Oracle metric table tips -
February 1, 2010
Importing
data from Excel into Oracle - January 30, 2010
Fix unnecessary
full-table scans - January 29, 2010
Oracle internal_function tips -
January 28, 2010
How to
find Oracle deprecated parameters - January 25, 2010
Oracle 10g deprecated
parameters - January 25, 2010
Oracle parameter list - January
25, 2010
SQL "partition" Analytic
Function tips-
January 25, 2010
Oracle "over" Analytic Function
tips -
January 25, 2010
Oracle analytic
function examples -
January 25, 2010
Oracle top-n SQL -
January 25, 2010
AMM vs. manual RAM allocation tips
-
January 19, 2010
Oracle applications scripts
-
January 18, 2010
Oracle hugemem kernel tips -
January 17, 2010
Oracle select tips -
January 17, 2010
Oracle join elimination tips -
January 16, 2010
Disk calibrate_io tips -
January 16, 2010
Oracle 11g multiblock
read tips - January
16, 2010
Spooling Oracle
data to Excel - January
10, 2010
Find infrequently used
indexes - January
10, 2010
Oracle design tuning - January
9, 2010
Oracle application tuning - January
9, 2010
Oracle startup I/O error - January
9, 2010
Oracle
bitmap index maximum distinct values - January 8, 2010
Oracle Database File
Systems (DBFS) tips - January 8, 2010
Oracle 11g connect as sysdba
causes ORA-01031 - January 7, 2010
Oracle 2010 salary survey - January 6, 2010
Find SQL with highest disk reads
- January 6, 2010
Find SQL with longest elapsed
time - January 6, 2010
Upgrade 9i App Server to
Oracle 10g Application Server - January 6, 2010
Oracle good hints list - January 6, 2010
Display Oracle
background processes in windows - January 6, 2010
Oracle select for update tips -
January 5, 2010
Oracle deadly embrace tips
- January 5, 2010
Can an Oracle session deadlock
itself? - January 5, 2010
Oracle fast recovery area tips - January
2, 2010
ignore_row_on_dupkey_index
tips - January 1, 2010
Using dba_outstanding_alerts - December 29,
2009
alter
database set standby to maximize protection tips - December 28,
2009
alter
database set standby to maximize availability tips - December 28,
2009
alter
database set standby to maximize performance tips - December 28,
2009
Oracle SQL ignores hint - December 26,
2009
Compare two CLOB columns
- December 26, 2009
Oracle: Display optimizer
features - December 24, 2009
Start the Windows Oracle service
- December 24, 2009
ORA-28500:
connection from ORACLE to a non-Oracle system tips - December 23, 2009
Oracle High
Availability Services (OHAS) - December 22, 2009
Missing sequence gap in
archived redo log - December 22, 2009
Setting the
optimal disk RAID stripe size - December 21, 2009
ASM and RAID-10 stripe size -
December 19, 2009
ASM hidden parameters -
December 18, 2009
Oracle ASM internals - December 18,
2009
RAC failover_interval and
failover_delay tips - December 18, 2009
RAC load balancing advisor
tips - December 18, 2009
clb_goal and goal in dbms_service
tips - December 18, 2009
FAN (fast application
notification) - December 18, 2009
Technological feasibility and
Oracle - December 17, 2009
v$flashback_database_log tips -
November 25, 2009
Fixing ORA-00060: deadlock detected while waiting for resource -
November 24, 2009
Oracle startup search
order for spfile and pfile - November 24, 2009
Difference between
dba_tables and dba_segments - November 24, 2009
Oracle ROWNUM and ROWID
difference - October 28, 2009
Modeling
irrational human decision processes - October 26, 2009
first_rows optimizer
mode deprecated? - October 20, 2009
SIMS Raleigh golf tournament
2009 - October 20, 2009
Detect Oracle redo log gaps -
October 19, 2009
See Oracle CPU by user
session - October 19, 2009
Oracle YUM server - October 17,
2009
Oracle file watcher tips - October
15, 2009
Oracle SQL Test case builder tips
- October 15, 2009
Log
actively being archived by another process tips - October 12, 2009
optimizer_use_pending_statistics tips - October 11, 2009
Linux optimal shmmax
and shmall for Oracle - October 11, 2009
optimizer_use_invisible_indexes tips - October 11, 2009
Restricting oracle
access tips - October 8, 2009
ORA-20003:
File could not be opened or operated on as requested - October 7, 2009
SQL*Loader with tab
delimited data - October 6, 2009
2009 Oracle security survey released - October 2, 2009
Oracle OS statistics - October 2, 2009
Understanding Oracle
knowledge engineering - October 2, 2009
Oracle: Track table history -
September 25, 2009
11g
flash_cache changes to Oracle buffer pool management -
September 25, 2009
Definition of spinning rust -
September 25, 2009
Procedure to write
comma-delimited table rows into a OS file -
September 23, 2009
ORA-27069:
skgfdisp: attempt to do I/O beyond the range of the file -
September 21, 2009
Version tracking of
PL/SQL code changes -
September 21, 2009
See SQL details (rows
processed) for a specific user session -
September 19, 2009
Relating RAT, SPA and STS tuning
components -
September 18, 2009
Backup
controlfile to trace places file into wrong directory -
September 18, 2009
Using PL/SQL with DB2
-
September 17, 2009
ORA-20000: index or
partition of such index is in unusable state -
September 15, 2009
Oracle Sun on Flashfire SSD
-
September 13, 2009
Oracle SQL execution plan
cost column tips -
September 12, 2009
The benefits of Oracle remote
DBA support -
September 12, 2009
Oracle's
states goals of Sun takeover -
September 12, 2009
Oracle 11g r2 new parallel query management enhancements -
September 9, 2009
re-start here
SQL tuning with
flash memory (solid state disks SSD RAM) -
September 8, 2009
Oracle delayed block cleanout tips
-
September 8, 2009
PL/SQL one time only
procedure tips -
September 7, 2009
Recursive
subquery factoring using the SQL WITH clause -
September 6, 2009
Oracle Instance Caging tips -
September 6, 2009
Oracle Omotion tips -
September 6, 2009
RAC One Node tips -
September 6, 2009
Oracle 11gr2 column level
compression -
September 5, 2009
Oracle flash_cache tips -
September 5, 2009
High
throughput vs. fast response time - September 4,
2009
Tuning
SQL to invoke nested loops joins -
September 4, 2009
Information Technology
(IT) speaker - September 3, 2009
Information
Technology (IT) professional management organizations - September 3,
2009
Hardware advances
and changes in Oracle technology - September 3, 2009
tnsnames.ora tips - August 30, 2009
Oracle business intelligence Tips
- August 29, 2009
How to save your job from an
Oracle layoff - August 29, 2009
Hardware advances and changes in
Oracle technology - August 29, 2009
Oracle Utilities Tips - August 29,
2009
Hypercharging SQL by restructuring complex queries using intermediate
results - August 29, 2009
Benchmark showing the difference in performance of complex SQL subqueries
rewritten with intermediate tables - August 29, 2009
Oracle 11g
changes to "order by" and "group by" performance - August 18, 2009
Oracle
database products - August 16, 2009
Best practices for security policies for accessing production data -
August 16, 2009
The
force_matching_signature column - August 15, 2009
remote_os_authent tips - August 15,
2009
Best practices for
scaling Oracle VLDB systems - August 14, 2009
Oracle wallet manager tips - August
13, 2009
Inside Oracle 2020 - August 13, 2009
Troubleshooting a hung
Oracle database - August 12, 2009
dbms_stats.set_table_prefs
tips - August 12, 2009
Equivalent of UNIX mtime
for Windows - August 12, 2009
Oracle RAC SGA sizing - August 11,
2009
Oracle: lower table high
water mark tips - August 11, 2009
Scheduling oracle
index rebuilding - August 9, 2009
v$session_longops tips -
August 4, 2009
ORA-16401:
archivelog rejected by RFS tips - August 4, 2009
Oracle disaster recovery
details - August 3, 2009
Oracle: Counting the
number of table changes - August 3, 2009
Costs of SQL Server vs. Oracle
- August 3, 2009
Updating tables with
Oracle 11g compression - July 31, 2009
Swapping SQL Profiles - July
30, 2009
Inserts become slow as
table grows - July 29, 2009
Oracle row_number analytic
function - July 28, 2009
Oracle index hint syntax -
July 28, 2009
Steps for Oracle
performance tuning - July 28, 2009
Oracle redo log corruption - July
27, 2009
Oracle SQL Tuning tricks - July 26,
2009
Oracle hikes tuning pack prices
- July 26, 2009
Oracle Windows
listener error: System error 3 has occurred - July 25, 2009
Reuters says Oracle hacking
will become easier - July 24, 2009
Tuning SQL with "rownum=1"
- July 24, 2009
Oracle cross platform
replication - July 24, 2009
Escaping
special characters in PL/SQL - July 24, 2009
Oracle documentation best
practices - July 22, 2009
Rewrite exists subquery using rank and partition analytics - July 21,
2009
Oracle patch set update (PSU) tips
- July 20, 2009
SQL tuning and
execution statistics - July 19, 2009
CNN reports DBA jobs in high demand
in 2010 - July 18, 2009
ORA-04031:
unable to allocate bytes of shared memory tips - July 17, 2009
Statistics and
function-based indexes - July 12, 2009
DBA's arrested for stealing millions
- July 10, 2009
Oracle derived parameters - July
9, 2009
Oracle processes parameter tips -
July 9, 2009
SQL GROUP BY for time periods
- July 9, 2009
Oracle on Google Chrome OS tips -
July 8, 2009
dbms_space.object_growth_trend tips - July 8, 2009
Formatting numbers in Oracle SQL -
July 8, 2009
Formatting numbers in
Oracle SQL - July 8, 2009
Windows PowerShell for
Oracle - July 7, 2009
The effect of
optimizer_mode on SQL execution plans - July 6, 2009
Oracle alter system check
datafile tips - July 6, 2009
Rewriting SQL for faster
performance - July 5, 2009
Oracle SQL
execution plan is incorrect - July 5, 2009
The NetApp Snap Manager for Oracle
- July 4, 2009
Oracle SQL query chooses
wrong index - July 3, 2009
Tuning Oracle dictionary SQL
- July 2, 2009
Tuning Oracle SQL that has
views - July 2, 2009
oracle optimizer costing
equations - July 2, 2009
RMAN delete obsolete
does not remove all files - June 19, 2009
Oracle column-level security -
June 18, 2009
Tablespace size &
initial extent size - June 18, 2009
SQL coalesce function tips - June 17,
2009
utl_file
umask permission tips - June 15, 2009
Oracle Advanced Queuing tips - June
15, 2009
db_block_checking tips - June 15,
2009
Sequence
of steps in oracle SQL explain plan - June 15, 2009
Hide Oracle
password for SQL*Plus - June 12, 2009
Location
of Oracle shutdown script - June 12, 2009
Oracle
software license compliance consulting support
Debugging dbms_scheduler
jobs - June 9, 2009
Oracle:
Tracking failed logon attempts - June 9, 2009
See Oracle SQL execution details over time - June 8, 2009
Viewing SQL execution details over time - June 8, 2009
Oracle resource manager tips
- June 7, 2009
Forcing
partition pruning on a distributed query using a db-link - June 7, 2009
Default database writer
processes tips - June 7, 2009
Performance of multiple schemas in a single instance - June 6, 2009
ORA-01450: maximum
key length (string) exceeded tips - June 6, 2009
Advanced Oracle
troubleshooting - June 5, 2009
Oracle Exadata
benchmark uses bizarre initialization parameters - June 5, 2009
Understanding direct path read
waits - June 5, 2009
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized
view tips - June 4, 2009
Mapping
Oracle data file extents to segments - June 3, 2009
Why is Oracle SQL query not
using an index? - June 3, 2009
Convert SQL Server
T-SQL to Oracle PL/SQL - June 3, 2009
database worst practices -
June 2, 2009
alter system start
rolling upgrade tips - June 2, 2009
Low downtime Oracle upgrade secrets
- June 2, 2009
Tracking Oracle
blocking sessions - June 2, 2009
Don Burleson as a cult hero! -
June 2, 2009
The role of the OS oracle
user - June 2, 2009
dba_scheduler_job_log tips -
June 1, 2009
Using
v$sys_optimizer_env and v$sess_optimizer_env - June 1, 2009
Using
dbms_shared_pool.purge to remove a single task from the library cache -
June 1, 2009
Visualizing
Oracle performance data to spot trend changes - June 1, 2009
Oracle to desupport RAW data
files - May 30, 2009
Oracle ACE warns about
optimizer bug - May 29, 2009
FRM-40510: ORACLE error: unable to DELETE
record. - May 29, 2009
Oracle index performance -
May 29, 2009
Tracking & auditing changes to your init.ora parameters - May 29, 2009
Create your own
multidimensional interface for Oracle - May 29, 2009
Oracle Windows
DOS script to detect and remove all trace files that are over 30 days old
- May 28, 2009
Managing multiple Oracle instances - May 27, 2009
Microsoft issues bizarre
Oracle workaround - May 26, 2009
v$sysaux_occupants Tips - May
26, 2009
dbms_space.create_index_cost
tips - May 26, 2009
Find Oracle blocking sessions
- May 26, 2009
Oracle RAC blocking sessions -
May 26, 2009
Oracle colored
command line backgrounds - May 20, 2009
Oracle indexes tips - May 20, 2009
Automatic Database Diagnostic Monitor (ADDM) in Oracle Database 10g -
May 19, 2009
Oracle redo log sizing advisor
- May 19, 2009
ORA-39802: ADT not allowed in
direct path mode tips - May 18, 2009
Real application testing
tips - May 17, 2009
Oracle SR tips - May 17, 2009
dbms_stats.gather_table_stats tips - May 17, 2009
v$sql_feature tips - May 15, 2009
Oracle acquires Virtual Iron
- May 14, 2009
Display all Oracle schemas - May
13, 2009
enq: TX - allocate ITL entry
tips - May 13, 2009
Oracle Windows script to check
alert log messages - May 13, 2009
Oracle OFA for Windows tips - May 13,
2009
Monitor index usage - May 12,
2009
ORA-24550: unhandled signal
received tips - May 12, 2009
Oracle 12i upgrade
RMAN incremental backup tips
- June 15, 2009
Oracle flashback database tips -
May 11, 2009
ORA-14074 tips - May 11, 2009
ORA-16009: remote archive log
destination must be a STANDBY database tips - May 10, 2009
Oracle recover standby database until
cancel tips - May 10, 2009
Oracle Windows TNS error:
No Listener found - May 9, 2009
What are Oracle statistics
- May 9, 2009
How to create a
duplicate database in Oracle - May 9, 2009
Script to
query multiple Oracle servers & instances - May 9, 2009
Oracle standby database tips - May
8, 2009
Oracle recover
standby database until cancel tips - May 8, 2009
Oracle interval partitioning tips
- April 31, 2009
Difference between
chained and migrated rows - April 31, 2009
Advanced
scheduling of STATSPACK snapshots - April 30, 2009
_cursor_features_enabled tips
- April 30, 2009
Monitor Oracle I/O with
PL/SQL and gv$sysstat - April 29, 2009
Oracle nologging tips - April 28,
2009
Oracle row count for all
tables in schema - April 28, 2009
Grant access to Oracle
trace and dump files - April 28, 2009
Learning Oracle in plain
English - April 27, 2009
Oracle transportable database
tips - April 27, 2009
How to extract a jpg
image from Oracle - April 27, 2009
Oracle system and session
_fix_control tips - April 26, 2009
Oracle driving table tips - April 26,
2009
Oracle timed_statistics tips - April
26, 2009
The
importance of communications skills for the Oracle DBA - April 25, 2009
Oracle monitoring with the vmstat wa
column - April 25, 2009
Oracle Database: SQL
Certified Expert - April 25, 2009
ORA-04045: errors during recompilation/revalidation - April 24, 2009
Oracle on Nehalem -
April 22, 2009
String parsing in Oracle
- April 22, 2009
Invoking FTP from PL/SQL -
April 22, 2009
Using dba_hist_log - April 21,
2009
Oracle
acquires Sun Microsystems for $7.4b - April 20, 2009
Oracle vs. DB2 UDB - April 20, 2009
Plotting Oracle
CPU Utilization percentage - April 20, 2009
PL/SQL script to shut
down Oracle Windows server - April 20, 2009
Avoiding bad
Oracle advice on the web - April 20, 2009
_ash_size and ASH data
buffer size - April 19,
2009
Buffer
cache size factors into Oracle optimizer execution plans - April 19,
2009
Oracle performance
software tips
Display Oracle session
volume per minute - April 18, 2009
Oracle Text: Map
Linux to Windows path - April 16, 2009
DBA fer rednecks - April 14, 2009
The best Oracle blogs - April 13,
2009
2008 Oracle DBA salary survey
- April 12, 2009
Fast data transfer
between instances - April 11, 2009
Fix error ORA-39097:
Data Pump job encountered unexpected error - April 11, 2009
Inside Oracle 11g fully
automated SQL tuning - April 9, 2009
Days to previous day
of the week in SQL - April 7, 2009
Display OS
variables with dbms_system.get_env - April 6, 2009
Oracle 11g hidden undocumented
parameters - April 5, 2009
Using v$sql_hint - April 5, 2009
Placing a date in a data
pump export file name - April 1, 2009
Find historical SQL by date
- March 27, 2009
Oracle memory leak
troubleshooting - March 27, 2009
Alert log x$dbgalertext
tips - March 26, 2009
What's the value of a professional
DBA? - March 25, 2009
How to Display Oracle CLOB columns
- March 6, 2009
Execute a shell
script from a PL/SQL procedure - March 4, 2009
Oracle diagnostic tips
How to get more out
of Oracle support - March 2, 2009
Over-allocation of Oracle
resources - March 2, 2009
Restore a single table in RMAN
- March 1, 2009
Oracle SQL execution steps -
February 25, 2009
Remove
spaces and special characters from Linux file names - February 24, 2009
How to extract a
timestamp date from a LOB - February 24, 2009
Information
Systems college major tips - February 23, 2009
Find RAC waiting sessions -
February 23, 2009
t_rman_insufficient_privileges.htm - February 7, 2009
Using
v$memory_dynamic_components with AMM - June 1, 2009
Oracle performance
management tips
Fix Oracle Hanging - February 4, 2009
Oracle Windows XP Tips - February
3, 2009
Oracle performance
software tips
Oracle versioning tips - February
1, 2009
Disabling Automatic Memory Management and execution plan changes -
January 31, 2009
parallel_adaptive_multi_user
tips - January 31, 2009
Find an Oracle table column size
- January 22, 2009
What SQL is included
in AWR tables? - January 22, 2009
Remove Oracle Windows
registry - January 22, 2009
Oracle DBA personality Quiz! - Not ready for
release!
Upgrade Oracle 9i to Oracle 11g
- January 21, 2009
Upgrade Oracle 8i to Oracle 10g
- January 21, 2009
Oracle SQL Plan Regression -
January 20, 2009
Managing legacy Oracle
databases - January 19, 2009
Oracle RAM Disk performance Tips
- January 19, 2009
Cartoon
illustrations for explaining technical topics - January 17, 2009
Oracle patch tracking & patch
management - January 16, 2009
Oracle log switch SQL reports
- January 15, 2009
Custom RMAN catalog reports
- January 12, 2009
Historical
analysis of SQL execution plans - January 9, 2009
Differences
between Data Pump impdp and import utility - January 3, 2009
Oracle data pump impdp
import modes - January 3, 2009
Oracle Data Pump expdp
export modes - January 3, 2009
Oracle software engineer duties
- January 2, 2009
Fix ASMCMD
slow performance - January 1, 2009
Import: Tablespace
does not exist tips - December 30, 2008
Oracle export query option tips -
December 29, 2008
How to
index on a SQL CASE statement - December 29, 2008
How to remove an expired
backupset with RMAN - December 29, 2008
Oracle SQL for padding leading
zeros - December 28, 2008
ORA-00845: MEMORY_TARGET not supported on this system tips - December
27, 2008
Understanding a key preserved table
- December 27, 2008
Script to identify index fragmentation - December 23, 2008
Oracle Windows
tnsnames.ora location - December 26, 2008
ORA-1652: unable to extend
temp segment tips - December 23, 2008
Oracle script to
detect index fragmentation - December 23, 2008
Fix
hanging SHUTDOWN: waiting for active calls to complete - December 22,
2008
opmnctl gives IP port
conflict error - December 19, 2008
Export
Import optimizer statistics with dbms_stats - December 19, 2008
BC papers - Collaborate 2009
Origin of nowt so queer as
folk
SQL to Display fields
of two tables in tabular form - December 18, 2008
How to buy Rampant Oracle books
in India - December 18, 2008
Supplementing Oracle technical support - December 17, 2008
Oracle service request
support - December 17, 2008
How to reclaim space from a
temp segment - December 16, 2008
driving_site hint tips - December
16, 2008
Fix SQL Developer vendor
error 17002 - December 15, 2008
How to remove a database
instance - December 14, 2008
A script to detect
when indexes require rebuilding - December 13, 2008
How to read a text file into an
Oracle table - December 13, 2008
Create Oracle
listener on a non-standard port number - December 13, 2008
Oracle technical support and
archivelog mode - December 13, 2008
A case study in incomplete
recovery - December 13, 2008
Managing swap in Oracle Linux &
UNIX - December 13, 2008
Handy awk commands - December 13, 2008
How to monitor a data pump
import - December 12, 2008
Find large files in
a UNIX/Linux directory - December 10, 2008
Find recent files in
a directory - December 10, 2008
Script to
clean up Oracle trace & dump files - December 10, 2008
UNIX/Linux
script to remove old archived redo log files - December 10, 2008
EXP-00056: ORACLE
error 6502 encountered - December 10, 2008
Oracle
Transparent Data Encryption (TDE) performance benchmark test - December
9, 2008
Accessing an ASM
instance from DB Console - December 8, 2008
Blocking access to Oracle - December
8, 2008
How to store a
PDF file into Oracle? - December 6, 2008
Oracle merge performance issues
- December 5, 2008
Oracle default tablespace tips -
December 5, 2008
Oracle Visualization techniques
Resolving the
ORA-02050: transaction string rolled back error - December 3, 2008
Parallel_index hint tips -
December 3, 2008
What session has locked a
PL/SQL package? - December 3, 2008
Display distinct
multiple columns with SQL - December 2, 2008
Display all
Oracle privileges within a schema - December 2, 2008
Crontab entries for holidays
- December 2, 2008
Tuning Oracle parallel updates
- December 2, 2008
Why use an
American Oracle Training Class? - December 1, 2008
Oracle optimal parallel degree
tips - November 30, 2008
Oracle MDM: Master Data
Management - November 30, 2008
Loading large datasets with
SQL*Loader - November 28, 2008
v$recovery_file_dest and
v$flash_recovery_area_usage give bad results - November 26, 2008
Using v$sort_usage tips - November 26,
2008
Oracle enqueue wait tips -
November 26, 2008
Oracle 11g upgrade bug causes unnecessary disk sorts - November 26, 2008
How much rollback
segment spaced is used by a SQL session? - November 25, 2008
Using v$version in Oracle scripts
- November 25, 2008
ORA-27092 tips - November 21, 2008
Using DDL in PL/SQL
- November 20, 2008
Oracle eBusiness
Suite r12 Workflow Training Class
Oracle EBS-R12 Training
Classes
Identifying Oracle professionals for layoffs - November 20, 2008
Oracle Management Downsizing Tips
- November 19, 2008
Using the Linux/UNIX
fuser command with Oracle - November 18, 2008
What is a "fuzzy" Oracle file? -
November 16, 2008
Preventing Oracle
chained migrated rows - November 15, 2008
What is the
difference between a chained row and a migrated row in Oracle? -
November 15, 2008
Shell script to check the
Oracle alert log - November 13, 2008
Best scripting language for
Oracle? - November 12, 2008
Oracle release dates - November 11,
2008
dbms_lob.getlength
gives incorrect length - November 11, 2008
Using Linux Hugepages with Oracle -
November 10, 2008
How to display your Oracle
session ID number - November 10, 2008
Using Oracle ASM with RAC tips
- November 6, 2008
PL/SQL debugging tips -
November 5, 2008
How to become an
Oracle programmer / developer - November 5, 2008
Space
management with LOB tables using PCTVERSION and RETENTION - November 5,
2008
ORA-27040: file create
error, unable to create file tips - November 4, 2008
How often should I apply
Oracle CPU patches? - 3 November 2008
Oracle parallel recovery tips -
July 15, 2008
Oracle active data guard tips -
July 15, 2008
How to insert a BLOB image
from a client PC - July 15, 2008
Script to monitor the alert log
- July 16, 2008
Creating XML with PL/SQL - July
16, 2008
RAC JDBC tips - July 17, 2008
Oracle Monitoring
Best Practices - July 21, 2008
Differences between Oracle 9i and 10g
- July 23, 2008
Oracle workload tips - WIP
Burleson Regional DBA
Oracle data recovery support
Oracle x$dbgdirext tips
Oracle Discoverer
releases and desupport dates
Oracle tuning For Windows
Remove archived
redo log files in Windows - August 12, 2009
Oracle Windows
consulting support
Oracle database recovery
support
Oracle recovery support
Oracle data recovery tips - August 5,
2009
SQL Server Scripts
Oracle disaster planning
show current SQL tips
Oracle auditing tips - July
29, 2008
How to Monitor CPU usage in UNIX -
July 29, 2008
TNS-03505: Failed to
resolve name tips -July 31, 2008
Get faster
performance with composite bitmap indexes - August 1, 2008
Repair corrupt Oracle blocks -
August 6, 2008
Using Cube Oriented
Materialized Views - August 6, 2008
Oracle RAC instance affinity tips
- August 8, 2008
Scheduling job on
specific instances - August 8, 2008
Origin "Meanwhile back at
the ranch" - August 11, 2008
ASM Cluster
Filesystem (ACFS) in 11gR2 - August 11, 2008
Oracle 11g
release 2: Cluster Voting Disk and Cluster Registry in ASM -
August 11, 2008
Oracle 11g R2: ASM
Dynamic Volume Manager - August 11, 2008
ASM Cluster
File System Snapshots - August 11, 2008
ASM Optimal Disk
Placement (ODP) - August 11, 2008
Renaming ASM Disk Groups
- August 11, 2008
How to find
leading and trailing spaces - August 12, 2008
Limitations of Apex? - August 23,
2008
ORA-12542:
TNS:address already in use tips - August 24, 2008
How to do a loop in Oracle SQL - August 24,
2008
Troubleshooting
Oracle performance - August 26, 2008
SQL to find the previous
word in a text string - August 27, 2008
Oracle Pivot examples - August 28,
2008
Invoking an Oracle
bat file from dbms_schedule
Understanding Oracle
troubleshooting - September 4, 2008
Creative STATSPACK and AWR scripts
- September 6, 2008
Auditing Oracle features
used with dba_usage_features_statistics - September 6, 2008
Inside Oracle cloud Computing - October 6, 2008
Oracle bloom filter hashing -
October 7, 2008
The Oracle "Scott/tiger" User
- October 13, 2008
Oracle: set threshold alerts -
October 14, 2008
Storing video files in
Oracle - October 14, 2008
Managing the Oracle alert
log file - October 14, 2008
Oracle bind variable peeking
tips - October 14, 2008
Oracle is a profession, not a trade!
- October 15, 2008
SQL Profiles to
replace stored outlines - October 16, 2008
When CPU speed hinders storage
speed - October 16, 2008
Why does OEM
import keeps large tablespace size? - October 17, 2008
New Intel SSD for personal computer
systems - October 18, 2008
How to write SQL
injection-proof PL/SQL - October 18, 2008
Oracle Windows 3GB tips - October
20, 2008
Difference
between logical & physical standby database? - October 21, 2008
What does a DBA examine when
starting a new job? - October 21, 2008
ORA-19809: limit
exceeded for recovery files tips - October 22, 2008
db_flashback_retention_target tips
- October 23, 2008
Teradata endorses SSD for future data
warehouse systems - October 25, 2008
Oracle delete performance tips
- October 25, 2008
How to start Oracle
Windows services - October 26, 2008
Parallel create index tips -
October 27, 2008
Optimizing Oracle data file
size - October 27, 2008
Setting the priority
for Oracle batch jobs - October 28, 2008
Does FORALL improve
delete performance? - October 28, 2008
How
much PL/SQL context switching with forall and bulk collect? - October
28, 2008
Oracle SQL response time monitoring
- October 29, 2008
Insufficient
privileges to create a view - October 29, 2008
How
to disable Streams synchronous CDC - October 29, 2008
append Oracle tips - October 31, 2008
Oracle sga_max_size tips - October 31,
2008
Why does OEM import keeps large tablespace
size? - October 31, 2008
How to schedule image
changes on a web site? - October 31, 2008
Using Confio Ignite for reactive
tuning - November 1, 2008
ORA-25183:
index-organized table top index segment is in a different tablespace tips
- November 1, 2008
ORA-01354: Supplemental log data must be added to run
this command
dbms_file_transfer.copy_file tips
Oracle
XML Formatting tips
Get
current date and time tips
How to change the default data format
Forcing a Materialized View to be picked up
Oracle on Windows 7 support
Using the analyze command and DBMS_STATS
Interested Transaction List
ORA-16146 and bug 6004936
Mapping objects to relational tables
Oracle expdp
tips
Oracle WebLogic Tips
Oracle tuning For Solaris
dbms_stats.set_table_prefs
tips - August 12, 2009
Migrate MySQL to Oracle
Migrate SQL Server to Oracle
RMAN-20098: invalid backup redo log low scn
Oracle NVL
How to re-size an Oracle database
Oracle Warehouse Builder (OWB) Informix migration
Difference between reloads and pin miss
Changing your Oracle character set
See RAM usage for an Oracle session
See contents of oracle library cache
Spool SYSDATE to a csv
spreadsheet name
ORA-19566 Exceeded
limit of corrupt blocks tips
Module name in dbms_application_info
_kgl_large_heap_warning_threshold
How to debug sql*net conectivity
Fixing oracle network connect errors
Monitoring growth with dba_hist_tbspc_space_usage
optimizer_dynamic_sampling tips
Tips for using the opt_estimate hint
Using
Oracle test cases
Oracle: write a file to to a client PC
Midori OS to displace Windows
ORA-28674: cannot reference transient index-organized table tips
SQL
coding best practices
Oracle Checkpointing internals
Oracle SQL Tuning book
ETL tools for transferring Universe DB with Globus to Oracle
SQL
Test Case Builder Tips
Sun
CMT servers with Oracle
Buffer Exterminate wait tips
Oracle VLAN
On-site SQL Server Training Courses
Finding quality Oracle EBS training
Oracle tuning For Solaris
Data Guard Managed Recovery Tips
v$dataguard_status script
v$managed_standby Tips
v$archive_log tips
Data Guard parameters Tips
Data Guard tnsnames and listsner.ora Tips
Starting a standby database tips
Create a Logical Standby Database Tips
Oracle Dataguard Logical Oracle instance LogMiner Switchover Failover
Collection Data Types
dba_logstdby_unsupported script
Rely constraint tips
dba_logstdby_not_unique Tips
LogMiner tablespace tips
Oracle tuning on HP UX UNIX - July 25,
2009
Oracle tuning on Linux - July
25, 2009
Logical backup file name with date
Reset an
ASM diskgroup
using the remap_table import option
Oracle DBA advisor tables - August
1, 2009
Oracle SQL last_day function - August 1,
2009
How
to Monitor Oracle Streams
How to migrate from Windows to Linux using RMAN
Oracle RAC node eviction tips
Oracle
support services
Optimal Oracle bitmap index values?
Optimal Oracle bitmap index values
Oracle licensing
compliance support
Oracle: Display optimizer
features - December 24, 2009
Frequent commits and ORA-01555
Oracle numa tips
Oracle library cache contention tips
What to do when you cannot log on to Oracle
Using utl_http for uploading into Oracle
Oracle
index skip scan tips
Does Oracle track privileged user sign-on activity?
Fix a
broken Oracle db link
Starting RAC CRS and the CRS-0184 error
Display Oracle stored procedures
Oracle
SQL for self join
Deleting large number of rows in Oracle quickly
Changing passwords of dba_users in RAC environment
Archive log backup in a different location using RMAN
Oracle
9i decommissioning
Oracle Bulk Insert and Update
Oracle DBA Blog
Oracle alert log location tips
Grant a package to other users
Maximum number of Oracle instances on one server
ORA-00205: error in identifying controlfile
Oracle Excel interface - October
25, 2009
Excel Oracle interface tips
reclaim space from LOB table
Professor Emeritus Frank
A. Logan – 1924-2005
Oracle experts
Oracle rule-based SQL
Optimizer Migration
Migrate optimizer from RBO to CBO
*********************************************
PL/SQL Tips:
Oracle date function tips
Oracle connectivity tips
PL/SQL decode tips
PL/SQL Case Tips
Oracle substr tips
Oracle instr tips
PL/SQL Exception Tips
PL/SQL procedure
PL/SQL stored procedure
ORA-29855 Tips
PL/SQL Developer
PL/SQL interview questions
PL/SQL for loop
PL/SQL cursor
PL/SQL functions
PL/SQL table
PL/SQL instr
PL/SQL if
PL/SQL array
Display Oracle server
blocksize
Oracle NFS Tips
Oracle License
Negotiations
Oracle Outsourcing
#1 PL/SQL tutorial guide
MS SQL to Oracle Database Migration
Support
Remote System Administration
Support
Remote Linux System
Administration Support
Remote AIX System
Administration Support
Remote HP/UX System
Administration Support
Remote Solaris System
Administration Support
Oracle PL/SQL book
Backing up the Weblogic -
Metadata Repository
Oracle Weblogic
Server Load Balancing - vmstat utility - web cache to http server
Oracle Weblogic
Component Overview
WebLogic Disaster
Recovery
Configure a WebLogic monitoring environment
Oracle
Weblogic Server Exception Reports - vmstat Trend Reports
WebLogic and
High Availability
Modify WebLogic Kernel
Parameters
Oracle Weblogic Performance Tuning - Monitoring Oracle Weblogic - Server
Parameter RAM Cache Tuning
Weblogic Server Forecasting and Trend Analysis
Weblogic HTTP Server
Performance Tuning
Upgrading a Weblogic
Server
Weblogic Server
CPU Bottlenecks with vmstat
Installing Oracle Weblogic-
Oracle Universal Installer (OUI) - Metadata Repository
Oracle Weblogic
Architectural Overview - Oracle Weblogic Multi-tiered Model - Oracle
Weblogic functional tiers
Installing Oracle Weblogic
- Oracle server configuration - JVM HEAP
Oracle Weblogic Security -
Oracle Web Cache
COBOL Consulting Support
Oracle COBOL Support
Oracle COBOL Contracting
COBOL Programming
COBOL Programming
contracting
C Consulting Support
Oracle C Contracting
Oracle C Support
Oracle C Programming
Oracle C Contracting
C++ Consulting Support
Oracle C++
Contracting
Oracle C++ programming
Oracle C++
programmer contracting
Oracle C++ contractors
Advanced PL/SQL book
Oracle Hyperion Consulting
Java Consulting Support
Oracle Java contractors
Oracle Java programmers
Oracle Services
OBIEE Training Course
Oracle BI Suite Training
Course
Oracle BI Training Course
-------
Saving
Oracle query results into Excel Spreadsheets
Export Oracle
query results into Excel
Convert Oracle data into
Excel
BC Oracle Outsourcing
Oracle Security
Training Course
Oracle Auditing
Training Course
Oracle Audit Vault
Training Course
#1 PL/SQL programming book
USA's #1 Oracle cloud consulting
support
Oracle GoldenGate Consulting
GoldenGate Consulting
Oracle PL/SQL programming tips
Hyperion Essbase
Support
Oracle Hyperion Consulting
Essbase Consulting
Oracle Linux consulting
USA's top GoldenGate Support Services
United States
Large Technical Universities
Custom Hyperion Classes
Oracle Hyperion Training Courses
Hyperion Essbase Training
Oracle Application
Server to Weblogic Migration Tips
Advanced PL/SQL book
---------
Burleson
genealogy
Genealogy of James Vespasian
Burleson
Genealogy of John Wesley Burleyson
Dive bombing a B-17 in WWII
Virginia Geraldine Burleson
*****************************
Irish Celtic cross Crucifix
******************************
Oracle Windows book
Chapter 1-7
History of Microsoft
Windows
Windows threaded
model tips
Chapter 2
Chapter 5
Find Windows Oracle environment variables
Chapter 8 - 14
Oracle ipconfig tips
Oracle ping tips
Oracle nslookup tips
Oracle tracert tips
Oracle Windows
Connecting to a Device on a Remote Server
ch 9
Oracle kill process tips
Kill stuck
Windows service using sc queryex and taskkill
ch 10
Install Oracle on Windows Tips
Oracle Windows add
shutdown script tips
Windows soon command tips
Windows sleep command tips
Windows blat command tips
Windows forfiles command tips
Windows rename ren command
tips
scripts
Oracle Windows shutdown script
Oracle Windows backup SQL*Net
log script
Windows Oracle Startup Script
Windows Data Pump export script
Oracle Windows
Services Status Script
Windows: Purge Oracle audit
tables script
Windows cold backup script
Chapter 14
Windows Net file command
Windows UAC Tips
Run ODBC on a 64-bit Windows server
FTP to a Windows server
DOS findstr command tips
Debug Windows exe command
Get Sorger ch 15
RMAN Recovery Catalog Tips
RMAN Configuration Tips
RMAN Advantages Tips
RMAN Autobackup Tips
Key RMAN Backup and Recovery
Principles
Cloning a database with RMAN
Skipping Tablespaces while
cloning RMAN database by duplicating to a past point in time
Cloning a database with RMAN
RMAN DBA Job Duties
RMAN Duplicate Database
*********************************
RMAN Failure Tips
Creating a Duplicate Database on a Remote host with a different directory
structure
RMAN Backup and
Recovery Redo Log Files
RMAN Consistent and
Inconsistent Backup Recovery
Creating a duplicate
database with the DUPLICATE DATABASE command
RMAN Duplicate Database
RMAN Backup and Recovery
Types
RMAN Backup Piece Tips
RMAN Backup Set Tips
Using RMAN to rename datafiles
RMAN Parallelism Tips
RMAN Backup Encryption Tips
RMAN Archivelog
Deletion Policy Tips
RMAN Flashback
Recovery Area (FRA) Tips
Connecting to RMAN Tips
RMAN Backup and Recovery
Switching to Archivelog Mode
RMAN Backup and Recovery Example
RMAN CheckSyntax Tips
RMAN backup types
RMAN full Database Backup
RMAN Noarchivelog Mode Tips
RMAN Backup Control File Tips
RMAN Multiplex Control
Files
RMAN Multisection
Multisectional Backups and Recovery
RMAN Backup Archived Redo
log Files
RMAN Delete Input Tips
RMAN Archival backups Tips
Encrypted RMAN Backup Tips
RMAN Validate Backup Tips
RMAN Backup Sets Example
RMAN Incremental Backup tips
RMAN Block Change Tracking
Tips
RMAN
Renaming and Disabling Block Change Tracking
RMAN Reporting Tips
RMAN Archived Redo Log
report
RMAN Listing Image Copies of
Database Files
RMAN Incremental Backup Tips
RMAN Schema Report example
RMAN Recovery Tips
RMAN Recovery Internals
RMAN Media Recovery Types
RMAN: Recover Control Files
RMAN Restoring
Control File with Redo Logs Intact
RMAN When Control Files, Datafiles, and
Redo Logs are Lost
RMAN Lost Control Files Using
Redo Logs
RMAN Restoring the Spfile
RMAN Backup Datafiles
RMAN Backup System
Datafile
RMAN Backup Undo Datafile
RMAN tablespace Backup
and Tablespace Recovery
RMAN set newname Command
RMAN Block Media Recovery
RMAN Corrupted Blocks Tips
RMAN Flashback Log Tips
Performing Block
Recovery Without RMAN Backups
RMAN Recover a Noarchivelog
Database
RMAN Disaster Recovery Example
RMAN Incomplete Recovery Tips
RMAN Time-Based
Incomplete Recovery
RMAN Recovering
RMAN Recover to a
Previous Incarnation
RMAN Tablespace Point-in-Time
Recovery (TSPITR)
RMAN Auxiliary Instance Tips
RMAN Data Recovery Advisor
Tips
RMAN Failure Command
Cloning with RMAN
RMAN - cloning on a Remote
Host
RMAN - cloning on a Local Host
RMAN - auxname Tips
RMAN Flashback Tips
Skipping Tablespaces in RMAN
cloning
RMAN Resynchronize a Duplicate
Database
RMAN Duplicate on Windows
RMAN Clone Without
Connecting to the Target Database
RMAN Cloning with OEM
Creating Standby Database Using
RMAN
Recovering Standby
Database Using Incremental RMAN
RMAN Transportable
Tablespace (TTS)
Transporting Tablespaces
with RMAN
Transporting Tablespaces
Tips
RMAN
Cross platform Transportable Tablespaces
RMAN Cross-Platform
Database Migration
RMAN Recovery Catalog Tips
RMAN Register
Database in Recovery Catalog
RMAN Unregister from
recovery Catalog
RMAN Recovery Catalog Tips
RMAN Synchronizing a Catalog
RMAN Upgrade Recovery
Catalog Tips
Monitor Flashback Tips
expdp exclude parameter
expdp exclude parameter
expdp reuse
dumpfiles parameter
expdp content Parameter
Saving
RMAN Backup Scripts in the Recovery Catalog
RMAN Run Backup Script tips
RMAN Catalog File Copy Tips
RMAN Backing Up and
Recovering the Recovery Catalog
RMAN Virtual Private
Catalog Tips
RMAN Recovery
Catalog Management
RMAN query the Recovery
Catalog
Troubleshooting RMAN Tips
Interpreting RMAN Errors
RMAN Debug Mode Tips
RMAN sbttest Tips
Monitor RMAN Tips
Monitoring RMAN Session
Progress
RMAN Archivelog Backupset
Kill Hung RMAN Session Tips
RMAN Tuning Tips
RMAN Synchronous I/O Tips
RMAN Asynchronous I/O
User-Manager RMAN Scenarios
RMAN Backup Database in
Archivelog Mode
RMAN Backup Mode Internals
RMAN End Backup Command Tips
RMAN Alter Database Command
RMAN Restore Database
Running in Noarchivelog Mode
RMAN Backup Archive Files
RMAN Verify Backups
RMAN Recover From Loss
of Controlfiles
RMAN Multiplexing
Controlfiles
RMAN recovery basics
RMAN Backup of Read
Only Tablespaces
RMAN Backup Undo Tips
RMAN Recover with lost Undo
RMAN Recover lost Redo
Log Files
RMAN Recover
From Loss of Inactive redo log Group
RMAN Recover lost
Redo Log Group
RMAN Recover to point in
time
RMAN Time-Based Recovery
RMAN Media Management
Layer (MML) Tips
RMAN Secure Backup Tips
RMAN for Oracle Application
Servers
RMAN Reader Class Tips
RMAN Daemons
Related to Oracle Secure Backup (OSB)
RMAN Installing Oracle Secure
Backup (OSB) on Linux
RMAN
Configuring Oracle Secure Backup (OSB)
RMAN OSB example
RMAN Flashback Recovery Tips
Flashback Query Example
Retrieve dropped table
Tips
Flashback
Transaction Query
Flashback
Transaction Backout
RMAN Oracle Flashback Table
Flashback Drop Tips
Exclude Tablespace
from Flashback
Recover Dropped Schema
with Flashback Database
Restore Dropped
Tablespace Tips
Recover Database until SCN
Tips
Modify Flashback Data
Archive Tips
Flashback Versions
Query Tips
Data Pump Architecture
Data Pump Mode Tips
Data Pump Export Utility (expdp)
Example
Metadata Filtering with
expdp
expdp filesize Parameter
expdp remote db_link tables
RMAN Parallelism Tips
expdp in parallel
expdp full export tips
expdp Table Example
impdp remap parameter
impdp remap_tablespace
parameter
impdp display DDL Tips
impdp Network Mode Import
expdp Command Line Tips
expdp consistent with SCN
or time
Linux whatis & info commands
TCP/IP netmasks
IP Routing
Linux CASE statement Tips
Linux FOR Loops
2007 hot topics updates:
SQL tips by Laurent Schneider:
 |
|
MySQL Articles
|
MySQL Notes and Tips:
 |
|
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 employees
consultants with extensive experience and knowledge.
 |
|
Notes for
Oracle newsletter
|
For upcoming Oracle Newsletter:
For impending release:
-
Oracle
export & import into earlier release -
January 20, 2008
-
PL/SQL
coding standards tricks -
January 20, 2008
-
Oracle data
protection tips - January 23, 2008
-
dbms_stats AUTO sample size tips - January 23, 2008
-
Oracle
technical support tips - January 24, 2008
-
UNIX/Linux e-mail consolidation tips
-
Script to
monitor RMAN progress - February 5, 2008
-
Oracle
standby archive_lag_target tips - February 5, 2008
-
Library cache overload tips - February 7, 2008
-
Oracle Performance Tuning Analyzer tips - February 7, 2008
-
Theft of
Oracle research becomes epidemic - February 7, 2008
-
Oracle
data integration tools - February 8, 2008
-
Oracle
opaque_transform hint tips - February 8, 2008
-
Oracle table
join order tips - February 8, 2008
-
“SQL*Net
message to client” and network throughput - February
8, 2008
-
Important Oracle 10g bug in index rebuilding -
February 8, 2008
-
Alter table move vs. shrink space commands - February 9,
2008
-
Oracle vmware pros and cons - February 9, 2008
-
_optimizer_ignore_hints tips
-
Tuning vendor
SQL tricks
-
2008 Oracle publishing market tips
-
Honing
your Oracle problem solving skills
-
SQL Server
on the web
-
Sub-optimal SQL and the 11g CBO - February 17, 2008
-
11g
adaptive cursor sharing tips - February 19, 2008
-
Oracle test
data generation tips - February 22, 2008
-
Oracle Continuous Connection
Network (OCCN) - February 25, 2008
-
Online Tool Improves Oracle Performance Analytics
-
Using the
"alter system dump" command
-
Monitoring Streams with DBA views
-
dbms_sqlhash
tips
-
In-memory vs.
Solid State Disks
-
Learning by Analogy: Fallacious reasoning
-
Capture a workload in 10g for 11g - March 3, 2007
-
Removing jobs
from the job queue - March 3, 2007
-
How to execute
dynamic PL/SQL procedure calls - March 4, 2007
-
O'Reilly sizes-up computer market for 2008
- March 4, 2007
-
Oracle speaks
on 10g migration tips
- March 4, 2007
-
Storing XML
documents in Oracle
- March 5, 2007
-
Web
2.0 MOSC now online! - March 6, 2007
-
statistics_level parameter tips
- March 6, 2007
-
gather_plan_statistics hint tips - March 6, 2007
-
Expert Oracle Consulting for Denmark: Aalborg,
Aarhus,Copenhagen, Odense
-
Setting server swap
space for Oracle
- Psyops: Wartime spam in-action
- May 5, 2008
- What not do
do when applying for a job - May 5, 2008
- Fixing
ARC0: Failed to archive log errors - May 7, 2008
-
Overtime pay for salaried computer professionals? - May
10, 2008
- Finding the
length of a LOB - May 11, 2008
- Fixing the
"kkjcre1p: unable to spawn jobq slave process" error - May 11, 2008
- Monitoring CPU with
UNIX - May 13, 2008
-
ORA-27037: unable to obtain file status tips
- May 13, 2008
- v$resource_limit tips
- May 14, 2008
- Use RMAN to
copy/clone a database - May 14, 2008
- How to move a table
with a LOB column - May 15, 2008
- What to
check when an export "hangs" while exporting definitions - May
15, 2008
- Inside the pickler fetch
- May 16, 2008
- Alter system
switch logfile tips - May 16, 2008
- 使用dbms_xplan工具查看执行计划
- May 16, 2008
- How to create an
Oracle PL/SQL package body - May 17, 2008
- How to
re-compile PL/SQL packages - May 17, 2008
-
Fixing different execution plans with different bind variable values
- May 17, 2008
- How to
select a LONG table column - May 18, 2008
- Inside Oracle
Streams Configuration Change Data Capture - May 19, 2008
-
Difference between summa cum laude, magna cum laude and with highest
distinction - May 20, 2008
- How to compare two Oracle
schemas - May 20, 2008
- Hypercharge
Oracle truncate table performance - May 20, 2008
- Oracle update
statement syntax - May 22, 2008
-
SQL*Loader readsize tips
- May 23, 2008
- Understanding Oracle
fusion
- May 23, 2008
- Oracle
troubleshooting Tips - May 23, 2008
-
Oracle
partitioning and derived horizontal fragmentation (DHF) - May 24, 2008
- Which operating
system OS is best for Oracle? - May 25, 2008
- Why doesn't Oracle
use my index? - May 25, 2008
- Using
dbms_space.create_table_cost - May 26, 2008
-
Detecting CPU
bottlenecks in Windows - May 27, 2008
- Oracle PL/SQL developer programmer job
duties - June 2, 2008
- PL/SQL debugger tips
- June 4, 2008
- Sun
Servers to offer SSD - June 6, 2008
- Oracle
Parallel Automatic Tuning tips - June 6, 2008
-
Automatic
tuning of db_file_multiblock_read_count - June 8, 2008
-
Parallel transaction recovery, undo and CPU performance - June 13, 2008
- SQL to
compare two date ranges - June 13, 2008
-
Oracle
tuning Guru achieves 20x performance improvement - June 14, 2008
-
Recommended 2008-2009 regional Oracle user group conferences
- Distributing
RMAN backups across multiple disks - June 17, 2008
- How to flush the data
buffer cache - June 18, 2008
- Oracle
performance testing tips - June 18, 2008
-
dbms_xplan.display_awr tips - June 21, 2008
- export with
complex query filtering - June 29, 2008
- Oracle RAC Service
Settings tips - July 1, 2008
- Oracle CMAN address tips
- July 4, 2008
- Oracle Windows
Utilities list - July 5, 2008
- Oracle
UNIX/Linux Utilities list - July 5, 2008
- Online redo logs
and RAID tips - July 7, 2008
- Quickly uninstall
Oracle - July 11, 2008
- RAC Database
cloning with HOT Backup - July 11, 2008
- Online AWR baselines -
July 14, 2008
- Oracle Migrations tips
- July 17, 2008
- Oracle uptime tips - July 17,
2008
-
Physical Standby Missing Log Scenario - October 16, 2008
-
Data Guard
Physical Standby Missing File tips - December 3, 2008
Ben work:
-
Checking
that Tables exist in Oracle - May 5, 2008
-
Disabling Archive Log Mode - May 5, 2008
-
NL exception when attempting to connect to 10g RAC database using JDBC -
May 5, 2008
-
Inserting
an "&" into a table - May 5, 2008
-
Oracle OEM
Timezone - May 7, 2008
- Oracle Timezone -
May 7, 2008
- sga_max_size
- May
7, 2008
-
sqlplus
List Tables and VIEWS - May 7, 2008
- Enabling
and Disabling Constraints
-
Recover Database until cancel tips
-
ora-00119
- Oracle ALTER
TABLESPACE
-
OEM 10G Host Credentials, Validation error
-
fatal ni connect error 12560 tips
-
java.lang.exception no such metric
-
On Delete Restrict or On Delete No Action
-
Error in invoking target 'all_no_orcl ihsodbc' Tips
-
sqlplus Hang Tips
-
SQL Wait Event: PX Deq Credit: send blkd
-
Linux Error: 13: Permission denied
-
Show indexes
in Oracle
-
ALTER
SESSION SET NLS_LANGUAGE
-
Disable
Archive log mode
-
No privileges on tablespace 'USERS'
-
Setting column width of query output in Oracle
-
skgpspawn failed Alert Log tips
-
DBA_TAB_MODIFICATIONS
-
ORA-22288 Tips
-
ORA-19505 Tips
-
Oracle LPAD
-
Data
file init write Wait Event
-
SQLNET.AUTHENTICATION_SERVICES
-
ORA-00600 Tips
-
ORA-24801: illegal parameter value in OCI lob function
-
ORA-12549: TNS:operating system resource quota exceeded Tips
-
LRM-00109: could not open parameter file "string"
-
ORA-00214: control file "string" version string
inconsistent with file "string" version string Tips
-
Checking oracle_home Tips
-
Oracle exception handling
-
Switching from NOARCHIVELOG Mode to ARCHIVELOG Mode
-
Expert secrets on
oradebug
-
Associative Arrays
-
Oracle XMLELEMENT
-
Data warehouse partitioning in Oracle 11g
-
Tips on Improving the Performance of Large Data Queries
-
EXTRACTVALUE
and datatype errors
-
Oracle
Data Warehousing TEMP tablespace size
-
Oracle Enterprise Manager - emctl not found in windows and HP-UX
-
oracle_12i/index
-
Oracle GROUP BY HAVING
-
Disaster Planning
-
Oracle Disaster Recovery
Support
-
Disaster Recovery
-
12/8/08
-
Enterprise Manager configuration Tips
-
ORA-03297
-
ORA-38500
-
Oracle Grant All
-
Oracle EXECUTE IMMEDIATE
-
Oracle Become User
-
PLS-00920
-
12/23/08
-
ORA-01079 ORACLE database was not properly created, operation aborted tips
-
Granting ALTER SYSTEM KILL SESSION to users
-
ORA-01467 sort key too long tips
-
ORA-01654
-
ORA-27154
-
ORA-38760
-
Oracle INSTEAD-OF Trigger
-
PLS-00302
-
RMAN-03014
-
AUDIT_TRAIL tips
-
12/24/08
-
EXP-00008
-
ORA-01476
-
ORA-02778
-
12/26
-
ORA-24247
-
1/5/08
-
Data Pump export parameters
-
1/6
-
Oracle Java fundamentals training Class
-
SQL and PL/SQL Training
-
Oracle
11g New Features training
Class
-
1/16/09
-
Oracle 11g migration
-
Oracle Check Constraint tips
-
Oracle RAC Training
-
Oracle 11i
Applications DBA training
-
Oracle CREATE SYNONYM
-
Oracle Associative Array
-
Oracle Apps Class
-
Oracle end-user SQL
training
-
1/20/2009
-
Microsoft SQL Server vs. Oracle
-
SQL Server
vs. Oracle
-
ORA-06512 Tips
-
1/21/09
-
cursor_sharing=force
-
Oracle OCP
-
1/26/09
-
Oracle data recovery support
-
Oracle Disaster Recovery Planning
-
Oracle Drop User
Cascade
-
Oracle Discoverer
Training
-
Oracle Training United
Kingdom
-
Oracle training Sweden
-
1/29/09
-
Oracle 11g new features
-
Oracle Data Guard
-
2/5/09
-
Oracle RAC recovery
-
Oracle 11g Grid
training
-
Oracle Windows
-
Oracle Date Functions
-
2/6/09
-
Ora-19588
-
ORA-21700
-
ORA-16000
-
Oracle Drop Datafile
-
Oracle
Substring
-
2/16
-
ALTER SYSTEM KILL
SESSION
-
dbms_job.submit
-
Decode SQL
-
Oracle CAST
-
2/17
-
Oracle CONCAT
-
Oracle Convert
-
Oracle Database Link
-
Oracle hint
-
2/18
-
Oracle ORDER BY
-
Oracle TRANSLATE
-
Oracle TRIM
-
Get ready
for Oracle SSD
-
2/26/09
-
Oracle Create Directory
-
Fix Hung Redo Log
Archiving
-
ORA-16191: Primary log shipping client not logged on standby
tips
DBAZine Articles
Henderson country club
DO NOT CHANGE ANYTHING BELOW HERE! INCLUDED CONTENT
|
impdp tips - 21 May 2012
Audit_trail parameter tips - 21 May 2012
Smallfile tablespace tips - 21 May 2012
Optimal data buffer cache
hit ratio tips - 20 May 2012
Oracle smart scan tips - 17 May 2012
Move RAC redo log files in
ASM - 17 May 2012
RMAN Tablespace Report example -
17 May 2012
ORA-31003 Tips - 16 May 2012
How to read an AWR report -
16 May 2012
v$access tips - 15 May 2012
ORA-01555 in expdp - 14 May 2012
Add a bucket to a
frequency histogram - 14 May 2012
Insert Nested Table tips - 14 May 2012
SQL to add row counts
from multiple tables - 13 May 2012
How to switch
between multiple databases releases on Windows - 9 May 2012
Convert excel files
into Oracle Tables - 8 May 2012
execute
immediate causes insufficient privileges over a database link - 8
May 2012
LOB freepools Tips - 8 May 2012
Uninstall Oracle XE Windows Tips
- 8 May 2012
Convert VARCHAR2 to CLOB Tips
- 8 May 2012
Remove Oracle table row lock
- 7 May 2013
Natural vs surrogate
keys for Oracle tables - 7 May 2013
How to monitor Data Pump sessions -
7 May 2013
How to
validate that a SQL*Plus script executed successfully - 7 May 2013
How to see if I am licensed to
use AWR - 6 May 2013
Public Synonyms Tips- 5 May 2013
current_schema Tips - 5 May 2013
RMAN duplicate database Tips
- 5 May 2013
endian format Tips - 4 May 2013
optimizer_sql_plan_baselines Tips - 3 May 2013
ORA-16025 Tips - 3 May 2013
cursor: pin S wait on X Tips - 1
May 2013
impdp specific column tips
- 1 May 2013
Oracle Windows job
scheduler tips - 30 April 2013
Chain together Oracle jobs - 29
April 2013
Test the Windows Oracle
Service - 29 April 2013
Oracle fix_corrupt_blocks - 29
April 2013
Oracle validate structure
command - 29 April 2013
Add space to Oracle
tablespace - 29 April 2013
Run SQL*Plus script
from DOS - 28 April 2013
Run Oracle export
script from Windows DOS - 28 April 2013
Standard Linux/UNIX
prompt for Oracle - 28 April 2013
Change Oracle environment
in UNIX/Linux - 28 April 2013
sample login file for
Oracle UNIX/Linux - 28 April 2013
bash .profile for Oracle -
28 April 2013
ksh .profile for Oracle
- 28 April 2013
Get 10g SQL plans -
28 April 2013
Oracle waiting SQL -
27 April 2013
TT0802:
Database permanent space exhausted Tips -
27 April 2013
db_writer_processes Tips -
25 April 2013
Reading the XML alert log -
23 April 2013
v$sql_optimizer_env Tips - 22
April 2013
v$sql_shared_cursor Tips - 22
April 2013
PLS-00310 Tips - 22 April 2013
parallel_min_time_threshold
Tips - 19
April 2013
v$waitclassmetric Tips
- 16 April 2013
Query level change
notification Tips - 16 April 2013
ORA-01155 Tips - 15 April 2013
sga_target Tips - 30 March 2013
sga_size_factor Tips - 27 March 2013
ORA-26713 Streams Apply Tips - 27 March
2013
Compress Oracle tablespaces - 26
March 2013
Disabling AWR data purging - 25
March 2013
Oracle display tablespace
contents - 25 March 2013
index_rs_asc hint tips -
25 March 2013
Convert Oracle dmp file -
23 March 2013
RMAN CATALOG vs. NOCATALOG Mode?
- 22 March 2013
default ORACLE_HOME location
on Windows - 21 March 2013
ezconnect Tips - 22 March 2013
v$rowcache Tips - 22 March 2013
row cache hit ratio Tips - 22 March 2013
log_archive_dest_2 Tips - 22 March 2013
Cloning ORACLE_HOME Tips - 21
March 2013
Monitor Oracle Connections Tips
- 12 March 2013
Oracle IP address history
Tips - 11 March 2013
offset fetch first rows only
tips - 11 March 2013
How to cancel a
concurrent manager request - 28
February 2013
Oracle 12c adaptive
optimization of SQL - 26
February 2013
shared pool internals - 22
February 2013
AWR Report CPU Analysis - 20 February
2013
First_rows tips - 19 February 2013
ORA-27085 Tips - 15 February 2013
Extended cursor_sharing tips
- 12 February 2013
bind_aware hint tips - 12 February
2013
ORA-29283 with impdp network_link -
11 February 2013
Max partitions in table - 11
February 2013
Get ORACLE_SID from inside
PL/SQL - 10 February 2013
Fix shared pool latch
contention - 9 February 2013
SQL Optimizer
Transformations - 8 February 2013
Find SQL*Plus file path
- 7 February 2013
STARTUP_WAIT_TIME Tips - 6 February
2013
DBGSQL Tips - 4 February 2013
Port number of OEM? - 3
February 2013
Location of DDL files for
SQL*Plus- 1 February 2013
ORA-24756 Tips - 1 February 2013
Difference between rman and
Oracle Secure Backup - 29 January 2013
ASM Template Tips - 29 January
2013
_optimizer_group_by_placement tips - 27 January 2013
_optimizer_extend_jppd_view_types tips - 27 January 2013
Installation of AWR - 25
January 2013
Parallel_max_servers tips - 25
January 2013
Solaris 32-bit 64-bit
for Oracle - 23 January 2013
How to enable
automatic statistics collection in 11g r2 - 22 January 2013
Find tables
that do not belong in the SYSTEM tablespace - 22 January 2013
Purging AWR statistics from Oracle
- 15 January 2013
Extract SQL from Oracle - 14 January 2013
Add Streams
replication to new server node - 11 January 2013
Oracle zombie process Tips - 10 January 2013
Oracle dictionary
object time created? -
10 January 2013
Oracle
diagnostic_tuning_pack_installed - 6 January 2013
Oracle export tape tips - 6 January 2013
authid & invoker rights - 5 January 2013
authid & definer rights tips -
5 January 2013
Invisible data columns Tips
- 5 January 2013
alter database
move datafile <number> tips - 4 January 2013
max_sql_string_size
Tips - 4 January 2013
expdp
view_as_tables Tips - 3 January 2013
DBCA database name
display Tips - 3 January 2013
What does a Core DBA do?
- 2 January 2013
Difference between Oracle DBA and
Oracle Apps DBA - 31
December 2012
Oracle first_rows
vs all rows optimization - 31
December 2012
Difference
between Oracle DBA and Oracle Apps DBA - 29
December 2012
Oracle nosort index - 28
December 2012
Linux Script using UTL_MAIL
from SQL* PLUS - 28
December 2012
ORA-01210:
data file header is media corrupt Tips - 26
December 2012
Oracle CCA Tips - 24
December 2012
ORA-38136 ORA-04067 on
export - 24
December 2012
Where are the value for
oracle sequences stored? - 24
December 2012
TNS poison attack tips - 23
December 2012
Oracle directory object tips - 22
December 2012
Export table to csv Tips- 21
December 2012
How to generate a csv of a oracle
table Tips - 21
December 2012
AU size and stripe size tips - 21
December 2012
Database size by month tips - 21
December 2012
Database size by day tips - 21
December 2012
Cemutlo tips - 20 December 2012
AWR report for RAC Tips - 17 December 2012
Get AWR report on two time
periods - 17 December 2012
Data Pump Import/export parallel tips
- 17 December 2012
Get AWR report on windows - 17 December 2012
List AWR Snapshots - 17 December 2012
Select remote table DDL Tips - 15 December 2012
ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed Tips - 14 December 2012
Testing a database link Tips - 14 December 2012
Change long raw
datatype to character column - 14 December 2012
Insert into long raw column Tips
- 13 December 2012
ORA-19554 ORA-27211: Failed to load Media Management Library Tips - 13 December 2012
EXP-00008: ORACLE
error 1455 encountered Tips - 13 December 2012
Stained Glass center of
Raleigh
Export to csv file Tips - 12 December 2012
Modify AWR
Automatic Snapshot Settings
- 12 December 2012
Simulate Load on Oracle
Database - 11 December 2012
Find Location of Oracle redo
logs on Windows - 10 December 2012
ORA-00823 Tips -
10 December 2012
dba_dml_locks Tips - 10 December 2012
dba_hist_resource_limit Tips
- 7 December 2012
wri$_optstat_tab_history Tips
- 6 December 2012
Monitor Oracle alert log Tips -
28 November 2012
Size of Oracle database - 27
November 2012
How to tell when partition pruning
is used - 27 November 2012
Encrypt BFILE column Tips -
26 November 2012
How to force an execution plan
-
25 November 2012
_db_block_cache_protect tips -
21 November 2012
_awr_flush_threshold_metrics
tips - 21 November 2012
Optimal SHMMAX for Oracle - 21 November 2012
rows per second Oracle
throughput Tips - 21 November 2012
Convert BLOB to CLOB script
- 21 November 2012
How often to
reanalyze statistics Tips - 20 November 2012
SGA: allocation forcing
component growth Tips -
19 November 2012
How to read an Export expdp
dmp file -
19 November 2012
current trace file Tips -
17 November 2012
Export table and index
definitions only -
16 November 2012
Oracle Direct Read vs physical
read Tips -
15 November 2012
find oracle corruption -
15 November 2012
Oracle 11g
release 2 upgrade performance problems -
13 November 2012
Java ORA-01461 solution -
13 November 2012
ORA-31684 import error Tips -
13 November 2012
export import
from Solaris to Linux - 13 November 2012
ASM vs filesystems - 13
November 2012
Alter table column
from LONG to CLOB Tips - 11 November 2012
dbms_job.submit Tips - 10
November 2012
Oracle schema definition Tips - 9 November 2012
impdp import with ORA-04020 error
- 9 November 2012
How to display the
execution plan for a finished SQL - 8 November 2012
display composite indexes
Tips - 8 November 2012
resmgr:cpu quantum Tips - 8 November 2012
PL/SQL Exception Tips - 8 November 2012
RMAN vs. EBU Features - 8 November 2012
tnsping syntax Tips - 8 November 2012
fatal ni connect error 12170
Tips - 7 November 2012
RAM used by session Tips - 7 November 2012
dba_hist_service_wait_class
Tips - 7 November 2012
KEEP pool data buffer hit
ratio - 7 November 2012
Data buffer
hit ratio for multiple data buffer pools - 7 November 2012
RAM used by SQL Query Tips - 7 November 2012
RAM used by Oracle user - 7 November 2012
What sessions are
using a database link? - 6 November 2012
See when an Oracle
table was last changed - 5 November 2012
ORA-12557: TNS:protocol adapter not loadable
- 5 November 2012
Expdp Impdp Network_Link Tips - 5 November 2012
ORA-29701: Unable
to connect to Cluster Manager Tips - 5 November 2012
XTTS - 5 November 2012
OER 7451 in Load Indicator
Tips - 5 November 2012
Get DDL for
Materialized View Script - 5 November 2012
Oracle isnumeric test - 5 November 2012
Find recently executed SQL -
5 November 2012
user who is running
a SQL Tips - 5 November 2012
DDL over a db link tips - 5 November 2012
PLS-00201: identifier ‘DBSNMP.BSLN_INTERNAL’ must be declared - 5 November 2012
Time Drift Detected tips - 5 November 2012
RMAN tuning Tips - 4 November 2012
Oracle processes high disk
reads
- 4 November 2012
Oracle tablespace Growth
scripts - 4 November 2012
ORA-39152: Table exists Tips -
4 November 2012
Compare Oracle Database Tips - 4
November 2012
Recover Oracle database Tips
- 4 November 2012
newgrp command Tips - 4 November 2012
setfacl getfacl command Tips
- 4 November 2012
Import nls_lang not
compatible - 3 November 2012
UDI-00018 Tips - 2 November
2012
Replication Pages
Creating Oracle replication
Push/Purge Jobs
Create Master
Replication Group
Adding Tables to
the Master Replication Group
dbms_repcat.genrate_replication_support tips
Adding multiple
Oracle replication Master Sites
Oracle Replication
Multimaster Enterprise Manager Repadmin
do_deferred_repcat_admin Tips
Multi-Master
replication Key Conflict Tips
Adding and Removing
Oracle replication Objects
Replication Parameters
Repadmin Schema Tips
repuser user Account Tips
Repproxy and repadmin
Replication Schemas
Database links for
Replication Tips
Configure Tables for
Replication Tips
Overview of Replication Packages
Oracle Materialized Views
Replication
Primary Key Based Oracle
Materialized Views
Oracle Materialized View Replication
ROWID
Replication catrep.sql Tips
Replication conflict avoidance tips
Create REPADMIN User
Create REPPROXY User
dbms_rectifier_diff
Monitoring Oracle
replication Conflict Resolution
OEM
to Define Oracle replication Conflict Resolution Methods
Replication Master Site
User Tips
Replication Refresh
Groups with OEM
Defining Oracle replication
Site Priority
Oracle replication User
on the Remote Site
Oracle Updatable
Materialized View UMV Replication
Disk pages re-names
scsi_options tips
sd_io_time tips
Configuration of CFS or Raw
Devices
Configure OCFS for Linux
Configure PolyServe
Cluster File System for Linux
PSFS File System Tips
ATA Tuning in LINUX
Tuning the SCSI Interface
SCSI Bus Tips
LVM Tips
Context Dependent
Symbolic Link
Vertias CFS
HP Tru64 Cluster file system Tips
Oracle Cluster File System (OCFS) Tips
Oracle Disk Manager Tips
Configuration of ASM
Oracle SCSI Tips
IEEE 1394 Interface Tips
Veritas Volume Manager
etc/rc.config: Tips
Kernelized Asynchronous I/O
Audit book pages:
Invoker Rights model Tips
SQL Injection Security Tips
Product User Profile Tips
SQL*Plus Security Tips
Single Login Security
Oracle Security Checklist
Encryption Key Management Tips
PL/SQL code wrapping Tips
MD5 Security Tips
Oracle Network Security Tips
Oracle Spoofing Tips
Statements that
are not auditable as privileges
Using multiple
Statement/Privileges
Protecting the Audit Trail
Grants Auditing
Auditing Distributed
Databases
Oracle Privacy Security Auditing
FGA Fine Grained Archiving Audit Data
List of Oracle security
commands
ALTER SESSION Tips
aud_find_users_broad_privileges.htm
Find
Non-Schema Owners with Schema Privileges
Default Role Tips
Find Privileges in Roles
Object Access-Based
Security
Object Masquerading
Encryption Concepts
Oracle Policy Manager Tips
Privilege Auditing
INT Book
_allow_resetlogs_corruption
tips
Oracle Trace Event Classes
EVENT Initialization
Parameters
Alter session set event tips
Tablespace free space
Script
Extract Oracle parameters
Latch sleep script
Partitioned Table Script
Partition Statistics script
Waiting sessions Script
Monitoring DDL Locks
Monitoring Internal Locks
Table column grant script
Oracle Database Policy Script
Monitoring
Currently Logged-in User Processes
Monitoring Profiles
Audit Table Monitoring
PHYS Book
The SDU and TDU parameter Tips
disable_oob parameter tips
break_poll_skip parameter tips
Oracle Hardware Design
Oracle Server Swap Disk Tips
Network design for Oracle
queuesize parameter in
listener.ora
Connection Pooling Tips
Oracle Hardware Design ODBC Network
Performance Replication Snapshot Materialized View
Oracle Replication Design
Oracle event waits script
Oracle object ID Tips
Design with VARRAY Tables Tips
Oracle non first normal
form table design
dba_log_groups Tips
|
|
|
Win your Oracle Dream Job!
Colleges don't teach the expert tips and
secrets for getting an Oracle job and acing your Oracle job
interview with
The Oracle Job Interview Handbook. Order directly from
Rampant
and save 30%.
|
|
|
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
|
|
|
|
Get the Complete
Oracle Tuning Details
The landmark book
"Oracle
Tuning: The Definitive Reference Second Edition" has been
updated with over 1,150 pages of expert performance tuning tips.
It's packed with scripts and tools to hypercharge Oracle 11g
performance and you can
buy it for 40% off directly from the publisher.
|
|
|
|
|
|
Hypercharge Oracle on
Linux!
The landmark book
"Linux
for the Oracle DBA" is a complete guidebook of expert tips
and secrets for automating Oracle database administration. It's packed with
working Linux scripts and tools to make any DBA look like a
guru.
|
|
|
|
|
|
Get the Complete
Oracle Utility Information
The landmark book
"Advanced Oracle
Utilities The Definitive Reference" contains over 600 pages of
filled with valuable information on Oracle's secret utilities.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
|
|
Teaser pages for the Exploring Oracle Internals book:
to remote-dba.cc
Automatic Memory Management
System Global Area (SGA)
Database Buffer Cache
Fixed:
11g new Partitioning
Automatic Diagnostic Repository (ADR)
Monitoring
v$library_cache_memory
The Data Dictionary Cache
Oracle large pool tips
java pool advice tips
Oracle Streams Pool Size Tips
v$memory_dynamic_components
Tips
Oracle flashback memory buffer
Tips
v$sga_dynamic_components Tips
Streams Pool
The v$pgastat view
v$mutex_sleep tips
Windows Memory and Threads
UNIX and ipcs commands
sysresv and pmap command tips
Memory Stack Traces
Database Isolation Levels and Serialization for Transactions
Types of Locks Within Oracle
Lock Management and Escalation
Detecting Lock Conflicts
Serializing locks with Oracle
Explicit lock tips
Insufficient ITL slots
Latches
redo log buffer latch tips
Shared pool latches
Exploring v$latch and v$latchname Views
How Latches Differ From Locks
Latch Contention Issues with Oracle
New v$ Views in Oracle 11g
v$ views for the DBA
v$ir_repair
Teaser pages for the Linux Oracle DBA book:
To do:
Choosing a Distribution of Linux for
the Oracle DBA
**************
Viewing Linux Command History
Installing Linux for
Oracle
Configuring Disks
for Linux on Oracle
Choosing a
Distribution of Linux for Oracle
Linux Repeating
Previous Commands
VirtualBox Linux Oracle
Tips
Linux touch Command
Linux Slash Home
Directory
Linux rm and rmdir Commands
*********
Viewing Linux Files for the Oracle
DBA
Searching
for Files
Examining
the System
Advanced
Command Line Use
Exporting
Variables
Viewing
and Controlling What is Executed
Checking
What is Executed
Becoming
Another User with su Command
Linux File and Directory Permissions
for the Oracle DBA
Editing
with vi and vim
Different
Modes in vi
Commands
for Making and Undoing Changes
Listing
Multiple Commands on One Line
Single and
Double Quotes
Standard
Input and Output Streams
Reading
Input from a File or from the Terminal
Linux Shell Scripting for the Oracle
DBA
Graphical
User Interfaces (GUI)
X Windows
Forwarding
X Windows
Forwarding on Mac OS X
VNC
Virtual Network Computing Server
Tunneling
VNC Through SSH and Connecting
Closing
and Reconnecting VNC Sessions
Oracle
Requirements and Installation
Linux for the Oracle DBA Software
Requirements and RPM Package Manager
Security
Enabled Linux (SELinux)
Creating
the Oracle Software Owner and Group
Starting
the Oracle Installer
Customizing the Oracle User's Environment
Starting
Up, Shutting Down and Runlevels
The init
Program and Runlevels
Shutting Down and Restarting Linux
for the Oracle DBA
Setting
What Runlevel to Start Into
Linux Startup and Shutdown Scripts
for the Oracle DBA
Users and
Groups
Determining the Current User, Group and Who is on the System
Who
Recently Logged Into the System?
Files
Associated with User, Group and Password Management
Managing
Users
Modifying
a User's Account Using the usermod Command
Using the
userdel command to delete a User
The
Importance of Consistent User and Group IDs
Password
Aging
Using su
to Run Commands as Other Users
Working
with a User's Login Shell
Login and
Logout Files
Modifying
and Sharing Login Files
The oratab
File
The PATH
Variable
Alias
Commands and Settings
Variables
and Commands in Prompts
Checking
and Restarting the Cron Daemon
The Format
of the crontab File
Controlling Who Can Use cron
Using at
to Schedule Tasks
Process
and Service Management
Restrict ps Output Using grep
Starting
and Managing Background Jobs
Linux SIGHUP Signal for the Oracle
DBA
The
Command Exit Status
Managing
Services (Daemons)
The RPM
Package Manager (RPM)
Installing
and Updating Software with RPM
Compiling
Software from Source Code
Managing
Disks and File Systems
Using
Journaling to Track Changes
Logical
Volume Manager (LVM)
Viewing
Current File System Information
Creating a
New File System
Mounting
and Unmounting File Systems
Mounting
and Unmounting File Systems
Mounting
and Unmounting the CD/DVD
Checking
and Repairing File Systems
Changing
When Full Checks are Run
Storage
Virtualization Concepts
Mirroring
Using the
Logical Volume Manager (LVM)
Editing or
Removing Logical Volumes
Starting
the Command Line LVM
File
System Performance
File and
Directory Management
Symbolic
Links
Inodes and
Hard Links
Creating
Files and Directories
Managing
File Permissions
Controlling Default Permissions with Umask
Additional
Permissions Settings
Getting
More Information on Files
Copying,
Moving, Renaming and Removing Files and Directories
Removing
(Deleting) Files and Directories
Managing
Hard and Symbolic Links
Searching
for Files and Directories
Searching
by Other Attributes
Comparing
Files and Directories
Backing
Up, Archiving, and Compressing Files
Using
cpio
Splitting
and Combining Large Files
Memory
and System Settings
Required
Settings
Monitoring Memory Usage
Using
vmstat to Monitor Memory Usage
Managing
the System Clock
Networking Fundamentals
IP
Addresses and Hostnames
The
Loopback Interface
Changing
the IP Address
Managing
Network Connections
Network
Security
Setting
Up Passwordless SSH
Synchronizing Directories with rsync
Shell
Scripting
Basic
Scripts
Variables
Input and
Arguments
Sending
Script Output to a Log
Alternate
Input Methods
Conditional Expressions
Checking
Files
Making
Simple Decisions with if and else
Loops
Checking
Results and Sending Notifications
Checking
the Output of Commands
Emails
from cron and at Jobs
Organizing Oracle Files
Organizing Files During Installation
Maintaining Oracle Logs and Diagnostic Files
Rotating
the Alert Log
The ADR
Directory
Managing
Multiple Oracle Homes
The
Oracle Inventory
Moving
Datafiles
Managing
Oracle Processes
Managing
the Listener
Managing
Oracle User Processes
The
Oracle Schedule
Submitting a Job
Using
dbms_scheduler
Using Job
Scheduler
File
Watchers
Articles below from Bryan:
Installing
Oracle Enterprise Manager - WebLogic Server Component
Introduction to the
New and Improved Oracle Enterprise Manager 11g
Oracle APEX: Applications Express;
Doing More with Less
Oracle
Database: Flashback Vs. Recovery
Configuring Oracle as a Data Source for SQL Server
What's In An Oracle
Schema?
VMware and Oracle Setup,
Part 2
VMware and Oracle Setup
Unleashing DBMS_PROFILER
Hidden treasures in
Oracle's STATSPACK utility
Transportable
Tablespaces: Why the Platform Matters
More on Using Oracle Tools
for Tracing
How Advances in
Storage Technology Create a New Security Challenge
The SQL Performance
Analyzer, SPA
Sorting Strings in
Oracle
Setting up Oracle as a Data Source for the SQL Server
Serving up Server Alerts
Sorting
Strings in Oracle
Oracle Reports for DBAs
RMAN
TSPITR, Examining the driver script
RMAN Tablespace Point in
Time Recovery
RMAN Drills
Revisiting Oracle
Passwords
Quest Code Tester for Oracle
Protecting Data from
Unintended Change or Users
Partitioning or Not in
E-Business Suite
Getting Inside the Optimizer, Part 1
Ordering Events in Oracle
Oracle
Warehouse Builder Automated ETL Processing
Oracle Database Text Setup
Spicing up Oracle on
Windows
Row Movement in Oracle
Oracle Reports for DBAs
Oracle Performance
Tuning Using Tracing, STATSPACK, AWR and Toad
Oracle on Windows
Revisited
Oracle: Sorting Out Memory
Oracle Licensing and
Auditing
The Oracle DBA Job
Interview; Nailing Common Questions
Oracle Concepts,
Splitting Hairs
Oracle
Support Notes - Complete Guides Usually Are Not
Cascading in Oracle, Friend or
Foe?
Learning Oracle by the Numbers
Oracle as a Data Source
Getting Inside the Optimizer, Part
2
Optimizer Hints in
Oracle 11g and hint overkill
Multilingual
linguistic searching and sorting in Oracle
Using SQL
Developer to Learn Oracle
Keywords In Oracle
Joining Disparate
Data in an Oracle Database
Data Manipulation Using
Java in Oracle
Installing
Oracle E-Business Suite R12 on Windows 2003
Installing
Oracle's Block Browser and Editor Tool, BBED
Making Database Administration
Easier with Freeware
Hackers in your Database
Hashing in Oracle
Getting a Handle on Indexes
Expanding
String Search Capability in Oracle Database
The Dictionary in the Data
Dictionary
Compressing Files in
Oracle
Changing the Word
Size in Oracle
Oracle: Choosing and Using
the Right Code
Clearing Alerts
in Enterprise Manager
Business
Intelligence Publisher, The Other Oracle Reports
Building a
Server Environment for Oracle and other RDBMS
Oracle's Block Browser
and Editor Tool, BBED
Barcode
Printing in Oracle Reports
Oracle after Hours:
Gathering Statistics
Using Oracle's SQL Functions -
Part 1
Using Oracle's SQL Functions -
Part 2
The Trigger-Happy DBA - Part 1 -
Using Triggers
The Trigger-Happy DBA - Part 2 -
Table Errors
The Trigger-Happy DBA - Part 3 -
System Triggers
Installation Cookbooks:
Installing Oracle9i
Installation Cookbooks:
Installing Oracle Forms and Reports 6i
Installation
Cookbook: Installing Oracle Application Server 10g (9.0.4)Forms and Reports
Services
Installation Cookbooks:
Installing Oracle9i Developer Suite
Installation Cookbooks:
Deploying Forms on the Web
Installation Cookbooks:
Deploying Reports on the Web
Oracle Certification - The
Last Word on OCP for Oracle8i
Oracle on the Web, Part 1 -
Exploring Oracle's HTTP Server
Oracle on the Web, Part 2 - Oracle
10g's HTTP Server and HTML DB
Oracle on the Web Part 3 - Using
Applications in HTML DB</font>
Oracle on the Web, Part 4 -
Upgrading HTML DB
Oracle on the Web, Part 5 - More on
HTML DB
Decrypting Oracle's
DBMS_OBFUSCATION_TOOLKIT
Oracle's Sample Schemas: Saying
Goodbye to Scott
Database Security and Oracle
Patches; Part 1
Database Security and Oracle
Patches; Part 2
Database Security and Oracle
Patches; Part 3
Database Security and Oracle
Patches; Part 4
Database Security and
Patches; Part 5
Database Migration - A Planned
Approach: Introduction
Database Migration - A Planned
Approach: Trees and Hierarchies in Oracle
Database Migration - A
Planned Approach: It's More than Running exp and imp
Unwrapping Oracle's DBMS Packages:
Understanding Oracle's Random Number Generator
DBA - One of USA's Top Ten Jobs
Oracle FIFO Queue Table
Failed to open the connection. Database Vendor Code: 12154 tips
SQORAS32 unsupported
operation tips
ORA-14098: Index mismatch for tables in ALTER TABLE EXCHANGE PARTITION tips
Track Date Time
Inserted for Table Rows
ORA-01688- unable to
extend table tips
ORA-06512 at
SYS.OLAPIHISTORYRETENTION tips
cluster_database_instances tips
Hands-on Oracle Backup and
Recovery Games - Loss of One or More Special Files
Hands-on Oracle Backup
and Recovery Games - Creating Datafiles
Materialized View ON
PREBUILT TABLE Tips
Oracle Open Resetlogs Tips
ORA-01683 unable to
extend index
ORA-12543 -
TNS destination host unreachable
ORA-00600 -
internal error code arguments kcratr1_lastbwr
Oracle and Pro*C
Describing Oracle Syntax
Doing Oracle Data Guard - Part 2
Doing Oracle Data Guard - Part 1
Using LogMiner - Part 2 - Striking Out
How Advances in Storage
Technology Create a New Security Challenge
Oracle: Separating Numbers
and Letters
Types of Tables in Oracle
How Does Oracle Perform Math
Oracle DML Error Logging
Interview Tips for Aspiring Junior
DBAs
Getting a Handle on Indexes
Hackers in your Database
Oracle: Choosing and Using the Right
Code
Making the Case for CASE tools
Controlling Backups with Database Control
Creating a Duplicate Database on a Remote host
with the same directory structure
Create a parameter file for an Auxiliary database
Create datafile locations on an auxiliary server
Creating a Duplicate Database on a Remote host
with a different directory structure September 24, 2010
Create datafile locations on an auxiliary server
September 23, 2010
Creating a duplicate database with the DUPLICATE
DATABASE command September 23, 2010
Oracle RAC Real
Application Cluster Architecture Global Resource Directory Background
Processes September 16, 2010
RAC Architecture Database September
16, 2010
Corporate travel
etiquette manners - March 9, 2010
Using the
up arrow key for command history in Oracle - March 15, 2010
Get DDL for primary and foreign key constraints - March 16, 2010
Oracle delete
tuning - March 16, 2010
Oracle soft
logical deletes - March 16, 2010
_high_priority_processes tips
- March 18, 2010
Conducting a
Database Administrator Background Check - March 18, 2010
Block Media
Recovery example with RMAN - March 19, 2010
Oracle RAC Job
Interview questions
SQL
resource_manager_plan tips - March 19, 2010
Incremental
Differential vs. Incremental Cumulative Backups - March 22, 2010
RMAN backup
types - March 22, 2010
Tuning In-line Views - March
22, 2010
Index Leaf Block
contention Tuning - March 22, 2010
open_cursors Tips - March 23, 2010
cursor_space_for_time Tips -
March 23, 2010
Oracle RAC Migration - March 23,
2010
Oracle OATM Tips - March 23, 2010
Oracle total recall Tips -
March 24, 2010
Oracle Mapping Tables - April 1,
2010
ORA-00406:
COMPATIBLE parameter needs to be string or greater - April 1, 2010
precompute_subquery hint tips
- April 2, 2010
push_subq hint tips - April 2, 2010
Disaster Recovery using RMAN
- April 5, 2010
Oracle VNC tips - April 5, 2010
Steps to Start the Oracle installer
- April 5, 2010
Oracle X Windows tips - April 5,
2010
Oracle global_names Tips - April 5,
2010
ORA-02069: global_names
parameter must be set to TRUE tips - April 5, 2010
dba_tab_stats_history tips -
April 5, 2010
Oracle DML
tuning - April 5, 2010
Oracle subquery factoring with clause for DML - April 5, 2010
ORA-27046: file size
is not a multiple of logical block size tips - April 5, 2010
select for update skip
locked tips - April 7, 2010
RMAN Recovery Window
retention policy tips - April 7, 2010
Tricks for super-fast batch
updates with CTAS - April 7, 2010
dbms_scheduler vs. UNIX
cron job - April 8, 2010
Oracle create index script -
April 8, 2010
Pages generated or updated by others below:
ORA-01715 UNIQUE may not be used with a cluster index
Oracle 12i
migration
Oracle 12i support
Oracle 12i Upgrade
Oracle E-Business Suite
support for Oracle Applications databases
Oracle E-Business Suite
support for Oracle EBS databases
Oracle Applications 12i
support Consulting
Oracle EBS
R12 consulting
BC Oracle security
Oracle E-Business Suite Support Consulting for Albuquerque New Mexico
Oracle eBusiness Suite (EBS) consulting
Oracle eBusiness Suite (EBS) release 12 upgrades
Oracle eBusiness Suite (EBS) consulting
Oracle apps support &
Oracle Applications consulting
Custom Oracle E-Business Suite for Human Resources HRMS
Oracle E-Business Suite Support Consulting for Atlanta Georgia
Oracle E-Business Suite Support Consulting for Austin Texas
Oracle E-Business Suite Support Consulting for Baltimore Maryland
Oracle E-Business Suite Support Consulting for Boston Massachusetts
OracleE-Business Suite Support Consulting for Chicago Illinois
Custom OracleE-Business Suite Support Consulting
Oracle E-Business Suite Support Consulting for Dallas Texas
Oracle E-Business Suite Support Consulting for Denver Colorado
Oracle E-Business Suite Support Consulting for Houston Texas
Oracle E-Business Suite Support Consulting for Los Angeles California
Oracle E-Business Suite Support Consulting for New York City
Oracle E-Business Suite Support Consulting for Raleigh, Charlotte, RTP North
Carolina
Oracle E-Business Suite Support Consulting for Washington DC
Oracle E-Business Suite Support Consulting for San Francisco California
Oracle E-Business Suite Support Consulting for Washington DC
Oracle 12i Consulting and
Migration
Oracle 11i upgrade
Oracle E-Business Suite Support Consulting for Salt Lake City Utah
Oracle E-Business Suite Support Consulting
Oracle E-Business Suite Support Consulting
eBusiness Suite
Consulting
|
|
|
|
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.
Copyright © 1996 - 2012
All rights reserved.
Oracle ©
is the registered trademark of Oracle Corporation.
|
| | | | |