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
4068.txt
ORA-4068/4061, existing state of packages has been discarded/invalidated
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
)
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
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
Datafile1stBlock.txt
Datafile first block
DatafileSizeHeaderOverhead.txt
Datafile size header overhead
* DataGuardNotes.txt
10gR1 Data Guard notes
* DataObjectId.txt
* DataPump.txt
DbBlockBucketAndLatch.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
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
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
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
* 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
PseudoSQLs_table_x_x_x_x_x_x.txt
PSP_process.txt
PSPn background process
QIO.txt
Veritas Quick I/O
QueryWithRedo.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?
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
sequence.txt
Service.txt
Proper way to create a service in RAC
* SessionCursorCache.txt
Session cursor cache
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 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
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
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
VotingDisk.txt
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