Comments? Email me at yong321@yahoo.com.

 
Notes with * are frequently read
If lines are not wrapped, view source in your browser and wrap long lines in there.

12500.txt ORA-12500, TNS-12500, listener failed to start a dedicated server process
12cDataDictionaryNew.txt Interesting new columns or features in 12c data dictionary
4031OnExport.txt ORA-4031 on export
4068.txt ORA-4068/4061, existing state of packages has been discarded/invalidated
AdvancedQueueing.txt
aq_tm_processes.txt
ArraySize.txt
ASM.txt
AsyncSystemTrap.txt
* AuditLogMoveAndQuery.txt
AutoExtendBug4Linux.txt Datafile auto extend bug for Linux
BecomeAnotherUser.txt
bequeath_detach.txt
BgprocessStartStopOrder.txt Background process start/stop order
BindLength.txt v$sql_bind_metadata, bind length mismatch, one reason cursors are not shared (see also sql_shared_cursor.txt)
Blackberry.txt
* BlockingSessionInRAC.txt
BufferHeaderLkLst.txt Buffer header link list
CamelCase.txt
CacheSegment.txt Disappeared with v$compatseg and v$compatibility in 10g
CharAndVarchar2.txt
CharShouldBeVarchar2.txt
CheckpointCounterDiffForEachDatafile.txt
Checkpoint.txt
CompileInvalidObjects.txt
CorruptTempDatafileDBVReports.txt
Create11gStandby.txt
CreateDirectoryInPlaceOfUtl_file_dir.txt CreateDirectory in place of utl_file_dir
csscan.txt csscan2ddl.pl is useful to generate DDL's that widen columns based on scan.err
CursorImplicitExplicitCommit.txt
cx_Oracle.txt
Datafile1stBlock.txt Datafile first block
DatafileSizeHeaderOverhead.txt Datafile size header overhead
* DataGuardNotes.txt 10gR1 Data Guard notes
DataMigration.txt Data Migration: Summary of a Case
DataObjectId.txt
* DataPump.txt
DbBlockBucketAndLatch.txt
DBLink.txt
Dbms_Job.txt
* Dbms_Space.txt
* Dbms_statsThenAnalyze.txt Less known differences between dbms_stats and analyze
DBVFoundFracturedBlock.txt
DCD Dead Connection Detection
DDLsNotUpdatingLast_ddl_time.txt
DirectIO.txt Direct I/O
Driving_siteAndRemoteView.txt
EnqueuesDumpNotes.txt
Event.txt Miscellaneous notes about setting events
ExportTablesWithRLSPolicy.txt
FilesystemBlockSize.txt
Flush_Cache.txt
ForceSCN.txt Force SCN in RAC
FormsServerSessionTimeout.txt
FreelistBlocks.txt
HalfDocumentedViews.txt
HideClientIP.txt
HighWaterMarkHow2Find.txt
* HijackSQLSession(Failed).txt Wish Oracle would do this with a "front-door" command
* Histogram.html
HitRatioCritique.txt Correct way to criticize tuning based on buffer cache hit ratio
HowToBeMoreCareful.txt
* HugePages.txt Linux HugePages
ifile.txt
* ImpExpThruPipe.txt Old trick, new twists
IMU.txt In-memory undo
InMemoryTable.txt In-Memory improves performance by reducing consistent gets
IndexFullScan.txt
IOBufferSize.txt
IOWaitUsingPrex.txt I/O wait using Solaris prex utility
ItaniumProblem.txt
JDBCIdentfConn2DB.txt Identify JDBC connections to database
JobLogUser=ImpUser.txt User_jobs.log_user is user running import
KCFWriteOpenError.txt
KeptObjCan'tBeFlushed.txt
KstTraceCdmpTrwFiles.txt
* LargePoolMtsPga.txt
LatchGetMissSleep.txt
LatchLevel.txt
* Ldap2Tnsnames.txt How to dump LDAP TNS entries to tnsnames.ora file
LdapInsteadOfTnsnames.txt
LibraryCacheLoadReload.txt
LibraryCachePinOrLock.txt
LinkWhereParseSP.txt Using a DB link, where is stored procedure parsed?
LMTDefaultStorage.txt
* LoadBalanceAndFailover.txt
LobConsistentRead.txt
LOBSegmentModifySQL.txt
LobStoredWhere.txt
LockOnLibraryCacheObject.txt
LocksExperiment.txt
* LocksWhere2FindMoreInfo.txt
Logarchivedest_AffirmSync.txt Affirm/noaffirm vs. sync/async of log_archive_dest_n
Logmnr.txt LogMiner, IMU, supplemental logging in 10g
LUNsForFilesystems.txt
max_commit_propagation_delay.txt It's safe to lower it in RAC
MetalinkHacks.txt How to use Metalink more efficiently
MetalinkSRs.txt How to download Metalink SRs programmatically
minidbbk.sh
* Misnomers in Oracle
ModifiedBlockList.txt Modified Block List
MOS.html My Oracle Support tips and direct document access
MOS_SRs.txt How to download My Oracle Support SRs programmatically
MoveOraInventory.txt
Mview_exceptions.txt
NetworkTraceOfSession.txt Network operation trace of a session
NFS.txt
NumberDataStorageLength.txt Oracle documentation never got the number type storage calculation right
OCFS.txt Oracle Cluster File System
OCP-HumanEvaluation-Interview.txt
* ORA-600[kgeade_is_0].txt When to not focus on first argument of ORA-600
Oracle11.2.0.1Events.txt Oracle11.2.0.4Events.txt Oracle12.1.0.1Events.txt Oracle12.1.0.2Events.txt
OracleConnectionSetup.html Practical guide to setting up Oracle connection
oradebugpoke.txt
OrausmsbContention.txt oraus.msb contention
ParallelRollback.txt
ParamChange10.2.0.3To10.2.0.4.txt
parse_failure.txt Catch errors after schema change before end users
* PasswordRetrieval.txt Legitimate, ethical use of this technology.
PasswordProfile.txt
PasswordSelfService.txt
* Perfmon.html Process-Oriented Perfmon
PGA_and_PrivateMemViewedFromOS.txt
PGAIncreaseWithPLSQLTable.txt
PivotQueryResult.txt
PortalLibraryCacheLatchContention.txt
PortsFindAll.txt Find all ports open
PrivsRecreate.txt
* processstatedumpnotes.txt
product_user_profile.txt
ProxyUser.txt
PseudoSQLs_table_x_x_x_x_x_x.txt
PSP_process.txt PSPn background process
QIO.txt Veritas Quick I/O
QueryWithRedo.txt
RACKillSessionTest.txt
RACWhat2Do.txt
RAC_OCR_Cleanup.txt
RawDatafileCreate.txt
RawDiskSize.txt
RedoWriteParallelOrNot.txt
RedoWriteSyncWrite.txt
Redo,Invalidation.txt
RefreshGroup.txt A question about refresh group, unanswered
ReportServer.txt
rkillsession.txt Restricted kill session script
RmanBackupPieceSize.txt
RmanCreateHistoricalSubsetData.txt
RollbackCommitStats.txt
RollbackSegmentQuirk.txt
RownumOptimization.txt
RowWaitObj#NotUpdated.txt
SCAN Single Client Access Name, new in 11gR2
ScatteredChanged2SequentialWhen.txt When does db file scattered read change to sequential read?
Schema Cleanup Fast way to recreate user objects
ScrollOnScreen.txt How to let query output continuously scroll up in sqlplus
SDUinSQLNet.txt Oracle Net session data unit
Security10gEnhanced.txt Security enhanced in 10g
Security12cEnhanced.txt Security enhanced in 12c
SegmentHeaderCR.txt Segment header read is CR not CU from 9iR2 on
sequence.txt
Service.txt Proper way to create a service in RAC
* SessionCursorCache.txt Session cursor cache
SGAGranuleSize.txt
SharedMemAndISMIssue.txt
SharedPoolChunkSize.txt
* SharedServerConfig.txt
ShortCircuitSQLEvaluation.txt
ShutdownHangsWaiting4Logins2Complete.txt
SingleClientAccessName.txt SCAN, new in 11gR2
SoftHardParse.txt
SparseFiles.txt
SqlHashValueAndPrevHashValue.txt sql_hash_value and prev_hash_value confusion
SqlldrDirectPath.txt
SqlnetAuthenticationServices.txt
* SqlplusSetup.html How to setup sqlplus in Windows command console for most efficient use
* SQLsFreqUsed.txt Frequently used SQLs and shell commands
* sql_shared_cursor.txt v$sql_shared_cursor and why cursors are not shared even if bind variables are used (see also BindLength.txt)
srvctl_crs_x.txt Notes on srvctl and crs_* commands
StandbyCreateFromRACASM.txt Managed standby: RAC ASM to RAC ASM
StreamsReplicationNotes.txt 10g Streams replication notes
StubbornParameters.txt Static parameters that must have the same values on all instances
SystemStats.txt
TableKeptInMemory.txt
TablespaceFreespace.txt Easy to miss something in this simple script
TablespaceInBackupMode.txt About a few misconceptions
TAF(Fake).txt
TempSpaceInRAC.txt
TextIndex.txt
TimeOverDBLink.txt Current time over DB Link
tmp.txt [Space holder for not yet named study]
TnsTimeout.txt
* ToadAndAlternatives.html
TOLocks.txt Lock type TO
TriggerFiringOrder.txt
UndoHeaderDump.txt Undo header dump and checking max TXs in one undo segment
UnitForBufferGetsDiskReads.txt
UnixStartupScripts.txt
User_tablesVsAll_tables.txt Buffer gets: user_tables > all_tables (or dba_tables) where owner='XXX' > tab
ViewDefinitionSearch.txt
v$log.status=INVALIDATED.txt
v$osstat
VotingDisk.txt
v$sort_usage.txt v$sort_usage or v$tempseg_usage
WaitedTooLongForARowCacheEnqueueLock.txt Waited Too Long for a Row Cache Enqueue Lock
WebutilNotes.txt Forms 10g WebUtil notes
WindowsStartupScripts.txt How does Windows run startup scripts in order?
* WinMemUsedByOracle.txt Windows memory used by Oracle
XWindow.txt


To my Computer Page