BC Oracle Tips
Also see
Oracle Application Server Tips
This Oracle Tips newsletter will subscribe you to receive the latest
Oracle tips,
alerts and Oracle news, directly
from Don Burleson and the experts at Burleson Consulting.
Please enter your
e-mail address and preferred deliver method to quickly enroll in the
new Oracle Tips list --> |
|
|
Burleson Oracle tips provides Oracle DBA tips, Oracle PL/SQL tips,
Oracle tips for developers, Oracle data warehouse tips and Oracle
community news and Oracle alerts.
Also, visit the Oracle Tips
Archive:
EDB book excerpts:
Ingres tips
History of Postgres releases &
features
EnterpriseDB history
Bizgres tips
Slony-I tips
Open-Xchange tips
Best Postgres Features tips
PL/SQL features by release
web stalkers:
Web Predators book
Internet Predators book -
Internet predators
Internet identity theft
protection
Identity theft protection book
- internet identity theft
Internet Phishing scams book
Internet scams protection book
- online web scams
Online fraud protection - web online
internet fraud
Online libel and interference invasion of privacy
Consulting links:
Oracle Caribbean
Consulting & Caribbean Training
Oracle database poster
Oracle DBA poster
Oracle Diagram
Oracle chart
Oracle Reference
Oracle9i migration,
Oracle9i replication,
Oracle Security,
Oracle privacy,
Oracle consulting
Migrating to Oracle,
Oracle Migration,
Migrating to Oracle from
SQL Server, DB2 Oracle
Migration,
Migrating to Oracle from DB2,
Oracle Migration from SQL Server,
SQL Server Oracle Migration,
Oracle Migration from DB2
Oracle Apex Developer,
Oracle Apex Consultant,
Oracle Apex Programmer,
Oracle Apex System Developer,
Oracle Apex Programming,
Oracle Apex Consulting,
Oracle Apex System
Development, Oracle Apex
Development
We have oracle emergency
assistance and emergency oracle
support. oracle reco
emergency 1
emergency 2
emergency 3
emergency 4
emergency 5
emergency 6
emergency 7
emergency 8
emergency 9
scripts1
scripts2
scripts3
scripts4
scripts5
scripts6
scripts7
scripts8
scripts9
scripts10
scripts11
scripts12
scripts13
script14
scripts15
scripts16
script17
scripts 18
oas1 text
oas1 oas2
oas3 oas4
oas5 oas6
oas7 oas8
oas9 oas10
oas11 oas12
oas13 oas14
oas15 oas16
oas17 oas18
oas19 oas20
perf1
perf2 perf3
perf4 perf5
sec1_text
Ion Oracle proactive performance analyzer
sql1 sql2
sql3 sql4
sql5
racbook1
racbook2
racbook3
racbook4
racbook5
racbook6
racbook7
racbook8
racbook9
racbook10
rac_test
rac1 rac2
rac3 rac4
rac5 rac6
rac7 rac8
rac9 rac10
rac11 rac12
rac13 rac14
Oracle growth
monitoring
Other links:
Eagle Alliance
environmental
assets
Oracle Links
Remote Links
plsql tuning
oracle publishing
pl_sql tuning
plsql tuning
pl_sql_performance
plsql_perf
plsql_support
plsql_support
pl_sql_cons
plsql_cons
oracle links
remote
10g1 10g2
10g3 10g4
10g15/a> 10g6
10g7 10g8
10g9 10g10
10g11 10g12
10g13 10g14
10g15 10g16
10g17 10g18
10g19 10g20
oracle health check
corporate oracle training
corp ora train
cbo1
cbo2
cbo3
cbo4
cbo5
cbo6
cbo7
cbo8
cbo9
cbo10
cbo11
cbo12
10g1
grid1
grid2
grid3
grid4
grid5
grid6
grid7
grid8
grid9
grid10
grid11
grid12
grid13
grid14
grid 15
grid16
grid17
grid18
grid19
grid20
JavaJob1
JavaJob2
JavaJob3
JavaJob4
JavaJob5
JavaJob6
JavaJob7
JavaJob8
JavaJob9
JavaJob10
JavaJob11
JavaJob12
JavaJob13
JavaJob14
j2ee1
j2ee2
j2ee3
j2ee4
j2ee5
j2ee6
j2ee7
j2ee8
j2ee9
j2ee10
j2ee11
j2ee12
j2ee13
j2ee14
j2ee15
j2ee16
j2ee17
j2ee18
10gNew1
10gNew2
10gNew3
10gNew4
10gNew5
10gNew6
10gNew7
10gNew8
10gNew9
10gNew10
WebDesign1
WebDesign2
WebDesign3
WebDesign4
WebDesign5
WebDesign6
WebDesign7
WebDesign8
WebDesign9
WebDesign10
WebDesign11
WebDesign12
WebDesign13
WebDesign14
WebDesign15
WebDesign16
WebDesign17
WebDesign18
WebDesign19
WebDesign20
WebDesign21
WebDesign22
WebDesign23 WebDesign24
WebDesign25
TopJob1
TopJob2
TopJob3
TopJob4
TopJob5
TopJob6
TopJob7
TopJob8
TopJob9
TopJob10
TopJob11
TopJob12
TopJob13
TopJob14
TopJob15
TopJob16
unix1
unix2
unix3
unix4
unix5
unix6
unix7
unix8
unix9
unix10
networking1
networking2
networking3
networking4
newtworking5
networking6
networking7
networking8
networking9
networking10
networking11
networking12
networking13
networking14
networking15
networking16
networking17
networking18
networking19
networking20
webmaster1
webmaster2
webmaster3
webmaster4
webmaster5
webmaster6
webmaster7
webmaster8
webmaster9
webmaster10
webmaster11
webmaster12
webmaster13
webmaster14
webmaster15
webmaster16
webmaster17
webmaster18
webmaster19
webmaster20
webmaster21
webmaster22
webmaster23
orajob1
orajob2
orajob3
orajob4
orajob5
orajob6
orajob7
orajob8
orajob9
orajob10
orajob11
oraclescripts
oraclescript
oracletuningscripts
oracletuningscript
oracleperformscripts
oracleshellscripts
oraclecronscripts
oracledictscripts
oraclerecovscripts
oracleunixscipts
oraclebackupscript
oraclebackupscripts
oraclecrontabscripts
oraclesqlscripts
oraclesqltuningscript
oraclesqltuningscripts
unixoraclescript unixoraclescripts
oraclescripts2
oraclev$scripts
programming1
programming2
programming3
programming4
programming5
programming6
programming7
programming8
programming9
programming10
programming11
programming12
programming13
programming14
programming15
oracle shell scripting
Oracle 11g Grid & RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Oracle 10g Grid Computing with RAC
Programmer Job Interview
Programmer Job Interview
Oracle 10g Grid Computing with RAC
Programmer Job Interview
Programmer Job Interview
Programmer Job Interview
Oracle Data Guard
**********************
Oracle Dataguard
Creating a
Logical Standby Database
Create
LogMiner directory tips
Modifying
the Initialization Parameter File
Configure
Oracle Net on the Standby Site
Data Guard Redo
Log Apply Services tips
Change the dbname of a Logical Standby Database
How to turn on
Data Guard
dba_logstdby_log
tips
dba_logstdby_progress tips
dba_logstdby_progress tips
Data Guard
Symmetrical initialization files Tips
Data Guard
listener.ora file tips
tnsnames.ora for Data
Guard Standby Database
Open Data Guard
standby in read-only mode
Manual Recovery of
Data Guard Standby Database
Physical Standby
Database monitoring Tips
Monitor recovery of a Data Guard standby database
Propagating Unrecoverable Operations to Standby Databases
Physical
Standby Time Lag Tips
Fix
Archive Gap Sequence on Physical Standby Databases
DBA Tips for
Logical Standby Databases
Starting & stopping the Data Guard logical standby apply Service
Data Guard v$logstdby & v$dataguard_status Tips
Data Guard
v$logstdby & v$dataguard_status Tips
Monitoring the Data Guard SQL apply
Data Guard Log
apply service scripts
Data Guard Schema
Object tips
DDL for Data Guard
Tips
Instantiate a
Data Guard table
dbms_logstdby.skip Tips
dbms_logstdby.unskip Tips
Logical
Standby Databases Time Lag Tips
Logical standby archive log gap tips
Data
Guard physical cascaded standby databases
logical
cascaded standby databases
Data Guard Log
Management Tips
Start Logical Oracle instance apply tips
Data Guard
log management policy tips
Data
Guard Redo Log Reuse Tips`
Data Guard Redo Log retry Tips
Data Guard Redo
Log retry Tips
Data Guard
standby redo log management
remote_archive_enable Tips
Data Guard
Redo Log Tranport/copy Tips
v$archive_dest Tips
Data
Guard instance Protection Modes
Data
Guard protection mode Tips
Data
Guard Rapid Protection Mode Tips
Data Guard
maximum protection mode
Data Guard Maximum Availability Mode Tips
Data Guard Maximum Performance Tips
Data Guard
Switchover and Failover Tips
Data Guard Role
Transition Tips
Switchover Failover
Graceful Forced Data Guard
Data Guard forced
failover Tips
Data Guard
switchover Tips
Prepare
primary database for switchover
Data Guard Force
Logging Tips
Data
Guard Failover to physical standby Tips
Data Guard
failover to logical standby Tips
Data
Guard Role transition Tips
Data Guard
Performance Tuning Tips
Monitoring
Data Guard Performance Tips
Tuning Data Guard Log Transfer
Data Guard
sample physical standby example
Data
Guard optimal network bandwidth Tips
Monitor Data Guard I/O
Tuning Data Guard
Log Apply Service
Data Guard Log
Apply Statistics
Data Guard High
SCN
Tuning SQL Apply
Tips
Fast
Performance Data Guard Tips
Data Guard Broker
Tips
Data Guard
Broker States & Properties
Data Guard
Broker DMON Process
DGMGRL Command Tips
Data Guard
Configuration Tips
Data Guard
Configuration attributes
DGMGRL configuration resource command Tips
Data Guard
alter resource database set state commands
Data Guard
Broker switchover Tips
Data Guard
Data Program protection mode Tips
Data Guard RMAN Tips
RMAN channel Tips
RMAN auxiliary
database command Tips
Create
Data Guard Physical Standby with RMAN
RMAN
target database command
RMAN
auxiliary database command Tips
RMAN channel
paramater Tips
automatic channel allocation Tips
RMAN allocate channel Tips
RMAN backup
set Tips
image copy
command Tips
set
newname command Tips
configure auxname Tips
RMAN dorecover
command Tips
RMAN
nofilenamecheck Tips
RMAN - duplicate target database for standby dorecover
Backup of
Oracle instance Using RMAN
Oracle10g New
Features Data Guard Data Guard Enhancements grid computing model
Data
Guard Real Time Apply Tips
Oracle Data Guard
Encryption
Data Guard sp_name Tips
Data Guard
creation of logical standby Tips
add
Standby logfile group tips
Data Guard Create
Configuration Command Tips
Data Guard enable/edit database/configuration commands
alter database add supplemental log data
Data
Guard remove/create configuration Tips
Data standby redo
logs Tips
Data Guard
Flashback database Tips
Data Guard
supports CLOB LONG RAW IOT
log_archive_dest valid_for Tips
Secure Redo Data Transmission Tips
Oracle automatic
performance diagnosis
automatic performance tuning
Oracle automatic SQL tuning
Oracle 10g ASM, ADDM , AWR, ASSM.
Oracle10g automation for Oracle 10g
Oracle10g Automatic
storage management book
oracle automatic database
management
Oracle 9i migration
Oracle tuning
Oracle
disaster recovery
Oracle Wait Event Tuning
Easy Oracle SQL
You're fired!
Oracle Solid Disk Tuning
Using Oracle SQL Stored Outlines & Optimizer Plan Stability
Oracle SQL Stability database creation assistant DBCA
Oracle SQL Stability install outln schema
Oracle SQL Stability outln schema outln_pkg
Oracle SQL Stability create outlines
Administration Creating
Altering of OPERATOR Objects - CREATE OR REPLACE OPERATOR command
Oracle SQL Stability plan outlines
Oracle SQL Stability creation outline objects
Oracle SQL Stability alters outlines create replace
Oracle - The UNIX chmod
command
Oracle - The UNIX pwd
command
Oracle - Additional UNIX utility
commands
Oracle - Using grep in
UNIX
Oracle - UNIX and DOS
commands
Oracle - UNIX user
management
Oracle - The UNIX ls
command
Oracle - File
management in UNIX
Oracle -
Introduction to UNIX
Oracle - Appending
data to UNIX files
Oracle - Removing UNIX files and
directories
Oracle - The UNIX
touch command
Oracle - The UNIX head and
tail commands
Oracle - Locating
files in UNIX
Oracle - Changing UNIX
shell environments
Oracle- Unix -
Re-directing output to a NULL device
Oracle - Viewing and
editing files in UNIX
Oracle - Introduction to
UNIX
Oracle - UNIX shells
Oracle -
System Administration in UNIX
Oracle - The UNIX
cd command
Oracle - Using awk in
UNIX
Oracle - UNIX user
identification
Oracle - UNIX connectivity for
Oracle
Oracle - Unix - Piping output
from commands
Oracle - The UNIX wc command
Oracle - UNIX line
continuation characters
Oracle - UNIX
passwords on Oracle servers
Oracle - Controlling
UNIX file permission with umask
Oracle - Using sed in
UNIX
Oracle -
Capturing server information with UNIX
Oracle - Unix - Using
the tee command to re-direct output to files
Linux, The SUID special
permission mode, sticky bit
Linux, The read
statement, accept input from standard
Linux, Using the find
command to locate files by age
Linux,
Evaluating complex expressions, perform math functions
Linux, Find the full
directory path for file
Linux, Redirection of
Standard Input & Output
Linux, Change File
Ownership, chown, chgrp, commands
Linux, What is
a shell?, command interpreter environment
Linux, Using simple ls
command options
Linux,
Conditional Statements, testing conditions, performing specific actions
Linux, Pipes, string
together multiple commands
Linux, Setting
default permissions using a file mask, unmask, login script
Linux, User defined
variables, scripts, global
Linux, Logging on to another group,
id, uid, gid
Linux, Special
permission mode settings
Linux, Inside vi - Changing
command insert mode - saving file
Linux, Inside vi - Editor modes
of operation - text editor
Linux, The case
statement, performing different set commands
Linux, Using test
command, expression evaluation
Linux, About
Loops, for, while, execute commands repeatedly
Linux, Invoking
Crontab with various options
Linux, Crontab command
Lines, six positional fields
Linux, Cutting,
Copying, and Pasting text, default buffer
Oracle, Analysis Tools,
operating system level analysis
Oracle, Comparing
the Different Scenarios, SSD, DSS, NAL
Oracle, Random Number
Generation, cached performance
Oracle RAM data buffering
History
Oracle, Test
Architecture, overall disk specifications
Oracle, Query Processing,
qgen program, DSS
Allocating Oracle
Objects Multiple RAM Data Buffers
Oracle
environment is being virtualized, monitoring
Oracle, Standard SCSI /
ATA Runs
Oracle, Finding
source bandwidth bottlenecks
SQL Server, Storage Monitoring Basics, sp_msforeachtable sp_foreachdb
SQL Server, Avoiding Free Space Deficit Bottlenecks
SQL Server, Server-Level Space Considerations, DBCC SHRINKDATABASE
SHRINKFILE
SQL Server, Object Fragmentation, Internal External memory caches
SQL Server, Environments Benefit Fragmentation Elimination, OLTP
SQL Server, Diagnosing Object Fragmentation, DBCC SHOWCONTIG
SQL Server, Extent Proximity, prefetch, Read Ahead manager
SQL Server, Removing Fragmentation, INDEXDEFRAG DBCC DBREINDEX
SQL Server, Forwarded Rows, sys.dm_db_index_physical_stats function
SQL Server, SQL Workload Analysis, Teradata warehouse
SQL Server, Examining Plan Cache, input parameters
SQL Server, Collecting Statistics, extent logical fragmentation
SQL Server, Active vs. Passive Monitoring, sp_minibench stored procedure
SQL Server, Scheduling Statistical Collections, static system storage
metrics
SQL Server, Centralizing Operations, SQL Agent installation
SQL Server, Setting up Trend Analysis, tempdb 4GL Timeframes
SQL Server, Correlating Statistics Calculating Rates, iostall
SQL Server, Tuning Makes Difference, monitoring databases performance
SQL Server, Simplified Performance Tuning Model, Optimization
SQL Server, Making Configuration Changes, standpoint parameters
SQL Server, Consider More Memory, configuration parameters
SQL Server, configuration parameters, fillfactor NETWORKIO
SQL Server, Decimal numeric, precision scale
SQL Server, UNIQUE, constraint CLUSTERED order_id
SQL Server, MS CryptoAPI based Public Key Implementations
SQL Server, Binary, Varbinary data type fixed variable
SQL Server, Provide automatic conversion parameter data types
SQL Server, Using framework, Appwizard SDK MFC ATL DLL
SQL Server, Applications XP_HTMLENCODE, varchar nvarchar
SQL Server, Parameter Management, srv_parname XP
SQL Server, Data types code use, Cursor Table statements
SQL Server, About NULL TSQL, SET option ANSI_NULLS
SQL Server, XP_PLAYSOUNDMEMORY, TSQL PlaySound XP_NOTIFY
SQL Server, Unicode Compilation, Win32 functions
SQL Server, CRC32 Checksum Algorithm, CRC dwCRC
SQL Server, Applications XP_SMTPSENDMAIL, table
SQL Server, Variant data type, reference SP PROPERTY
SQL Server, Track Memory Leaks, runtime heap allocations
SQL Server, Dependency Walker, Input Output parameters
SQL Server, Precompiled headers, pch stdafx
SQL Server, Code Highlights, parameters CDO macros CC
SQL Server, Blowfish - TEA Block Cipher, CBlowFish ECB mode
SQL Server, ASCII Character Set, American Standard Code
SQL Server, XP_NET_SEND Jobs, Administrator
SQL Server, MD4, MD5, SHA, Hash Algorithm
SQL Server, XP_CRYPTOAPI Usage, TSQL HMAC SDK
SQL Server, Implementation, framework XP_NETSEND code
SQL Server, Exporting function, standard boilerplate code
SQL Server, Execution Extended Stored Procedures, SP, UDF
SQL Server, Encapsulate verification setup parameters
SQL Server, Using Query Analyzer, debug SP, testing TSQL
SQL Server, Char stores fixed length ASCII data
SQL Server, Nchar stores fixed length Unicode data DATALENGTH
SQL Server, Security / Connection Management, XP_ODBC
SQL Server, MS CryptoAPI based Signing / Verification Implementations
SQL Server, Named parameters, ODS XP
SQL Server, XP_PLAYSOUNDFILE, XP_STOPSOUND, XP_PLAYSOUNDALIAS
SQL Server, Implementation Details, ADO EOF MSDN
SQL Server, Real , floating point numeric valid values mantissa
SQL Server, Hashing, hash value data collision - resistance
SQL Server, MS CryptoAPI Hash Algorithm Implementations CSP
SQL Server, Using CDO Windows 2000, DLL JScript
SQL Server, Helix Stream Cipher, CryptoAPI MAC
SQL Server, Asymmetric Encryption / Decryption, RSA DSA
SQL Server, Unicode Character Set, Consortium unified
SQL Server, Testing Code, Script EXEC
SQL Server, Registering XP from Enterprise Manager, GUI
SQL Server, XP_HTMLENCODE2, EscapeXML ATL Unicode framework
SQL Server, ODS API, functions SRV_PROC pointer
SQL Server, Symmetric Encryption / Decryption, Stream Ciphers CBC
SQL Server, Handling different data types, boolean
SQL Server, XP_NET_ADDNAME, NetBIOS UNICODE SDK
SQL Server, Applications XP_CRYPTOAPI, UDF functions
SQL Server, Implement encapsulation C++ classes
SQL Server, Default values, SP XP
SQL Server, Choice Mail Library, SMTP MAPI XP
Data Warehouse Chp 1
Chapter 2
Chapter 3
Chp 4
Chp 5
Chp. 6
tp_data_warehouse_aggregation_multidimensional
Chp. 7
tp_parallel_server_SQL_lock_hit
tp_parallel_server_V$PING_contention
Chp. 8
Chp.9
Mothballing a Database Project - Ault
t_mothballing_project_system_programs_source
t_mothballed_project_data_definition_language
t_mothballed_database_exports_logical_copies
t_mothballed_project_system_backup
t_mothballed_database_project_documentation
t_mothballed_project_document_applications
t_project_mothballing_documentation_tools
t_project_mothballing_documentation_training_report
t_project_mothballing_comments_reports
t_project_mothballing_reactivated_failure
Using Object ID's in Oracle 8 - Ault
tp_Oracle_8_dangling_REF
tp_Oracle_8_REF_request_passing
tp_Oracle_8_REF_object_values
tp_Oracle_8_REF_dangling
Ault Q&A
t_oracle_deleting_user_error_message
t_oracle_user_sequences
t_oracle_10g_application_server_installation
t_oracle_key_string_encryption
t_oracle_uniform_extent_size
t_oracle_archive_log_files
t_oracle_composite_primary_key
t_oracle_archive_logs
t_oracle_changing_database_objects
t_oracle_export_command
t_oracle_exporting_data
t_oracle_creating_indexes
t_oracle_query_optimization
t_oracle_access_violation_error_message
t_oracle_installation_error_message
t_oracle_length_of_numeric_data_type
t_oracle_dynamic_sql_statement
t_oracle_dropped_table
t_oracle_removing_carriage_returns
t_oracle_reading_WSID
t_oracle_reparsing
Ault Tips
t_ault_they_amm_to_please_sometimes
Garmany Q & A
t_oracle_connecting_to_a_db
t_oracle_creating_new_9i_database
t_oracle_listener_error_message.htm
t_oracle_access_violation
t_oracle_button_trigger_exception_error
t_oracle_migrating_from_9i_to_10g
t_oracle_testing_accessibility
t_oracle_database_access_via_Internet
t_oracle_installing_on_one_server
t_oracle_running_Oracle_apps_on_Internet
t_oracle_migrating_from_dev_6i
t_oracle_cluster_forms_reports
Putting Methods to Work in Oracle8 - Ault
tp_Oracle_8_REF_requests_passing
Diving Into the Shared Pool (Part 1) - Ault
tp_shared_pool_flush_script
tp_Oracle_shared_pool_routine_flush
tp_Oracle_shared_pool_area_sizing
Diving Into the Shared Pool (Part 2) - Ault
tp_shared_pool_fixed_size_pin
tp_shared_pool_null_startup_function
tp_Oracle_shared_pool_areas_MTS
tp_Oracle_SQL_statements_area_text
Job Scheduling
Oracle 11g courses
Oracle
Application Express (Apex) Book
Tasteless Cartoons |