These Oracle notes may be the most visited on my Web site so I added a search box for your convenience. (The one in beige is for a wider scope. Groups.google.com stores newsgroup messages, ideal to search for an answer to a question you would ask. Altavista sometimes complements Google's search results.)

 
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
4031OnExport.txt ORA-4031 on export
AdvancedQueueing.txt
ArraysizeAndConsistentGets.txt
ASM
AsyncSystemTrap.txt
audit.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)
BlockingSessionInRAC.txt
BufferHeaderLkLst.txt Buffer header link list
CacheSegmentSpaceAlert.txt
CharAndVarchar2.txt
CheckpointCounterDiffForEachDatafile.txt
CheckpointQueue.txt
CompileInvalidObjects.txt
CorruptTempDatafileDBVReports.txt
* CreateDirectoryInPlaceOfUtl_file_dir.txt CreateDirectory in place of utl_file_dir
CursorImplicitExplicitCommit.txt
Datafile1stBlock.txt Datafile first block
DatafileSizeHeaderOverhead.txt Datafile size header overhead
* DataGuardNotes.txt 10g Data Guard notes
DataGuardPerformance.txt
DataObjectId.txt
DataPump.txt
DbBlockBucketAndLatch.txt
Dbms_Space.txt
Dbms_statsThenAnalyze.txt Less known differences between dbms_stats and analyze
DBMSJOBRemoveFromSystem.txt
DBVFoundFracturedBlock.txt
DCD Dead Connection Detection
* DirectIO.txt Direct I/O
* Driving_siteAndRemoteView.txt
EnqueuesDumpNotes.txt
EventSet.txt Miscellaneous notes about setting events
ExportTablesWithRLSPolicy.txt
FilesystemBlockSize.txt
FreelistBlocks.txt
hexstr.pl
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
ifile.txt
ImpExpThruPipe.txt Old trick, new twists
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
LargePoolMtsPga.txt
LatchGetMissSleep.txt
LatchLevel.txt
* Ldap2Tnsnames.txt How to dump LDAP TNS entries to tnsnames.ora file
LdapInsteadOfTnsnames.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
Logmnr.txt
LUNsForFilesystems.txt
max_commit_propagation_delay.txt It's safe to lower it in RAC
MetalinkSRs.txt How to download Metalink SRs programmatically
minidbbk.sh
Misnomers in Oracle
MoveOraInventory.txt
Mview_exceptions.txt
NumberDataStorageLength.txt Oracle documentation never got the number type storage calculation right
* OCFS.txt Oracle Cluster File System
* OracleStudy.txt How to get started on Oracle
OracleStudy2.txt
oradebugpoke.txt
OrausmsbContention.txt oraus.msb contention
ParamChange10.2.0.3To10.2.0.4.txt
* PasswordProfile.txt
Perfmon.html Process-Oriented Perfmon
PGAIncreaseWithPLSQLTable.txt
PortalLibraryCacheLatchContention.txt
PortsFindAll.txt Find all ports open
PrivsRecreate.txt
* processstatedumpnotes.txt
product_user_profile.txt
QIO.txt Veritas Quick I/O
RACWhat2Do.txt
RAC_OCR_Cleanup.txt
RawDatafileCreate.txt
RawDiskSize.txt
RedoWriteParallelOrNot.txt
RedoWriteSyncWrite.txt
Redo,Invalidation.txt
rkillsession.txt Restricted kill session script
RmanBackupPieceSize.txt
RollbackCommitStats.txt
RollbackSegmentQuirk.txt
RowWaitObj#NotUpdated.txt
ScatteredChanged2SequentialWhen.txt When does db file scattered read change to sequential read?
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
Service.txt Proper way to create a service in RAC
* SessionCursorCache.txt Session cursor cache
sequence.txt
SGAGranuleSize.txt
sgastat.txt
SharedMemAndISMIssue.txt
SharedPoolChunkSize.txt
* SharedServerConfig.txt
ShortCircuitSQLEvaluation.txt
* ShutdownHangsWaiting4Logins2Complete.txt
SoftHardParse.txt
* SparseFiles.txt
spotlight_eval.txt
SqlHashValueAndPrevHashValue.txt sql_hash_value and prev_hash_value confusion
SqlldrDirectPath.txt
SqlnetAuthenticationServices.txt
* SqlplusSetup.html How to setup sqlplus in DOS 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)
* StreamsReplicationNotes.txt 10g Streams replication notes
SystemStats.txt
TablespaceFreespace.txt Easy to miss something in this simple script
TAF(Fake).txt
TempSpaceInRAC.txt
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
UsersCleanoutCreate.txt Fast way to recreate user objects
User_tablesVsAll_tables.txt user_tables > all_tables (or dba_tables) where owner='XXX' > tab in buffer gets
v$log.status=INVALIDATED.txt
v$osstat
v$sort_usage.txt
WebutilNotes.txt Forms 10g WebUtil notes
WindowsStartupScripts.txt How does Windows run startup scripts in order?
* WinMemUsedByOracle.txt Windows memory used by Oracle


To my Computer Page