Comments? Email me at
yong321@yahoo.com
, or fill in the
contact form
.
Enter your search terms
Submit search form
Web
yong321.freeshell.org
groups.google.com
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