Comments? Email me at yong321@yahoo.com, or fill in the contact form.

 
 
 
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
Autotask_SchedJob.txt
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
BufferPinAndCBCLatch.txt
CamelCase.txt
CacheSegment.txt Disappeared with v$compatseg and v$compatibility in 10g
CharAndVarchar2.txt
CharShouldBeVarchar2.txt
CheckpointCounterDiffForEachDatafile.txt
Checkpoint.txt
clean_patch_storage.txt
CompileInvalidObjects.txt
conn2host.txt "Convert" connect identifier to hostname
ConstraintLateCheck.html Late check of constraint
CorruptTempDatafileDBVReports.txt
Create11gStandby.txt (oudated)
Create12cStandby.txt (superceded by Duplicate18cDB.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
CssFailsToStartUnableToChangeToRealtime.txt
CursorImplicitExplicitCommit.txt
cx_Oracle.txt
Datafile1stBlock.txt Datafile first block
DatafileSizeHeaderOverhead.txt Datafile size header overhead
DataGuardMonitoringScripts.txt
DataGuardNotes.txt
DataMigration.txt Data Migration: Summary of a Case
DataObjectId.txt
* DataPump.txt
DataTypeChoice.txt Char or varchar2? When to use CLOB? Plus: store file data in DB?
Datatime.txt
DayOfWeekInQuarterOfAllTime.txt
DbBlockBucketAndLatch.txt
DBLink.txt
Dbms_Job.txt
DBMS_SET_PDB_And_LogShipping.txt
Dbms_Space.txt
Dbms_statsThenAnalyze.txt Less known differences between dbms_stats and analyze
DbParam_CompTimeConst_Map.txt DB Parameter to Oracle Compile-Time Constant Mapping
DbStat_SGAVar_Map.txt DB Statistics to SGA Variable Mapping
DBVFoundFracturedBlock.txt
DCD Dead Connection Detection (or Terminated Connection Detection in 12c)
DDLsNotUpdatingLast_ddl_time.txt
DecommissionAccountWithCaution.txt
DefaultRole.txt Default roles
DirectIO.txt Direct I/O
DmuCharacterSetTool.txt
Driving_siteAndRemoteView.txt
Duplicate18cDB.txt
EnqueuesDumpNotes.txt
Event.txt Miscellaneous notes about setting events
ExadataAfterPatchAction.txt Work to do after Exadata patching
ExportTablesWithRLSPolicy.txt
FilesystemBlockSize.txt
Flush_Cache.txt
fmt_sql.txt Format a long SQL statement
ForceSCN.txt Force SCN in RAC
FormsServerSessionMonitor.txt Fusion Middleware Forms server session monitor
* FormsServerSessionTimeout.txt Fusion Middleware Forms server session timeout
FreelistBlocks.txt
GIMR or -MGMTDB
GoldenGateAdminclient.txt
GoldenGate Replication Check Script
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
LdapConnectIdentifierUsedByWhatClients.txt Find Oracle clients using a specific connect identifier resolved by Oracle LDAP
LdapInsteadOfTnsnames.txt
LibraryCacheLoadReload.txt
LibraryCachePinLockHowToFindBlocker.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
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
NetworkACL.txt
NetworkInstabilityCausedbyIPConflict.txt Unstable private interconnect caused by IP conflict
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
ORA-46952: standby database format mismatch for password file
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 Oracle12.2.0.1Events.txt
OracleBinaryGroupOwnership.txt
OracleConnectionSetup.html Practical guide to setting up Oracle connection
oradebugpoke.txt
OrausmsbContention.txt oraus.msb contention
OuterJoin.txt
ParallelRollback.txt
ParamChange10.2.0.3To10.2.0.4.txt
parse_failure.txt Catch errors after schema change before end users
PasswordCaseSensitivity.txt
* PasswordRetrieval.txt Legitimate, ethical use of this technology.
PasswordProfile.txt
PasswordSelfService.txt
PDBRunPLSQLWithoutSetContainer.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
RamaVelpuriOnRecovery.html
RawDatafileCreate.txt
RawDiskSize.txt
RedoWriteParallelOrNot.txt
RedoWriteSyncWrite.txt
Redo,Invalidation.txt
RefreshGroup.txt A question about refresh group, unanswered
ReportServer.txt
ResumableSession.txt
rkillsession.txt Restricted kill session script
RmanBackupPieceSize.txt
RmanCreateHistoricalSubsetData.txt
RmanSlowDueToCompression.txt
RollbackCommitStats.txt
RollbackSegmentQuirk.txt
RownumOptimization.txt
RowWaitObj#NotUpdated.txt
SCAN Single Client Access Name, new in 11gR2
SCANListenerLosesServiceRemoteListenerORA-132.txt
ScatteredChanged2SequentialWhen.txt When does db file scattered read change to sequential read?
Schema Cleanup Fast way to recreate user objects
SchemaUserAccount.txt Schema, User, Account: different or same?
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 Miscellaneous notes about services on RAC
SessionCursorCache.txt Session cursor cache
SGAGranuleSize.txt
SharedMemAndISMIssue.txt
SharedPoolChunkSize.txt
SharedPoolDuration.txt
SharedServerConfig.txt
ShortCircuitSQLEvaluation.txt
ShutdownHangsWaiting4Logins2Complete.txt
SingleClientAccessName.txt SCAN, new in 11gR2
SoftHardParse.txt
SparseFiles.txt
SQLDeveloper.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)
SQLTuningCases.html
srvctl_crs_x.txt Notes on srvctl and crs_* commands
StaticInstanceNonmodifiableParameters.txt Static parameters that must have the same values on all instances: caution for RAC DBAs
StreamsReplicationNotes.txt 10g Streams replication notes
SynonymTranslationInCursor.html
SysauxPurge.txt
SystemStats.txt
SystemTapToProbeUserProcess.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
UnindexedForeignKey.txt
UnitForBufferGetsDiskReads.txt
UnixStartupScripts.txt
Use_Sid_As_Service_listener.html
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