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
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
Migrate734To816.txt
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
PasswordLost.txt Rainbow etc.
* 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
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
TablespaceFreespace.txt Easy to miss something in this simple script
SystemStats.txt
TAF(Fake).txt
TempSpaceInRAC.txt
tmp.txt Temporary Research place holder
TnsTimeout.txt
ToadAndAlternatives.html
TOLocks.txt Lock type TO
UnitForBufferGetsDiskReads.txt
UnixStartupScripts.txt
UsersCleanoutCreate.txt Fast way to recreate user objects
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