When are IOTs a bad thing? - Ask TOM
Tom - in your experience, what are the common errors where people have used IOTs in the wrong situation? Thanks. When they have lots of secondary indexes on them in an environment where the IOT is constantly in a state of flux. The secondary indexes (indexes on non-primary key columns) have rowid 'guesses' in them and if the guess is correct - the efficiency of the secondary index is about as good
INITRANS Cause of deadlock - Ask TOM
Thanks for the question, Yves. Asked: October 18, 2002 - 2:01 pm UTC Last updated: January 04, 2013 - 10:40 am UTC Version: 9.2.0.1.0 Viewed 50K+ times! This question is Hi Tom. I am getting the following errors in my alert log: ORA-000060: Deadlock detected. More info in file d:\oracle\admin\vndb\udump\vndb_ora_1620.trc. The first few lines of the above trace file are as follows: Dump file d:\ora
Ask Tom
Times are East coast times (GMT-4:00) In the last 4 weeks, I've taken 106 new questions, read 560 followups, and responded to 406 of the followups
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
soft parse - Ask TOM
Ask Tom "Archive Log Cleaning"
Ask Tom "using explain plan"
Ask Tom "Questions on Locking"
