Comments? Email me at
yong321@yahoo.com
.
Enter your search terms
Submit search form
Web
yong321.freeshell.org
groups.google.com
altavista.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
4031OnExport.txt
ORA-4031 on export
AdvancedQueueing.txt
aq_tm_processes.txt
ArraySize.txt
ASM
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
)
* BlockingSessionInRAC.txt
BufferHeaderLkLst.txt
Buffer header link list
CacheSegment.txt
Disappeared with v$compatseg and v$compatibility in 10g
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
10gR1 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
DDLsNotUpdatingLast_ddl_time.txt
DirectIO.txt
Direct I/O
Driving_siteAndRemoteView.txt
EnqueuesDumpNotes.txt
EventSet.txt
Miscellaneous notes about setting events
ExportTablesWithRLSPolicy.txt
FilesystemBlockSize.txt
Flush_Cache.txt
ForceSCN.txt
Force SCN in RAC
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
HugePages.txt
Linux HugePages
ifile.txt
ImpExpThruPipe.txt
Old trick, new twists
IMU.txt
In-memory undo
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
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
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
MOS.txt
My Oracle Support tips
MoveOraInventory.txt
Mview_exceptions.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
* OracleStudy.txt
How to get started on Oracle
OracleStudy2.txt
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
* Perfmon.html
Process-Oriented Perfmon
PGAIncreaseWithPLSQLTable.txt
PivotQueryResult.txt
PortalLibraryCacheLatchContention.txt
PortsFindAll.txt
Find all ports open
PrivsRecreate.txt
* processstatedumpnotes.txt
product_user_profile.txt
PseudoSQLs_table_x_x_x_x_x_x.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
SegmentHeaderCR.txt
Segment header read is CR not CU from 9iR2 on
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
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 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
)
* StandbyCreateFromRACASM.txt
Managed standby: RAC ASM to RAC ASM
StreamsReplicationNotes.txt
10g Streams replication notes
SystemStats.txt
TablespaceFreespace.txt
Easy to miss something in this simple script
TAF(Fake).txt
TempSpaceInRAC.txt
TextIndex.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
Buffer gets: user_tables > all_tables (or dba_tables) where owner='XXX' > tab
ViewDefinitionSearch.txt
v$log.status=INVALIDATED.txt
v$osstat
v$sort_usage.txt
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