This content has been marked as final. Show 10 replies
HINT: use a HINT
but my real response would be "why?"
I want to demonstrate that we can use single table hash clusters for look up tables to solve this wait event. Pls correct me if i am wrong.
I don't want to use hint.
I don't want to use hint.I don't want to use SQL.
now, we're even.
If you are doing a demonstration of something, why don't you want to use a hint?
If we have to use a hint to simulate the problem, it means that we won't have any problem if we don't use hint.
Then there is no need to resolve it.
You said "I'm trying to demonstrate something"
That's a perfectly valid reason to use a hint.
I want to demonstrate resolving a problem. But if the problem is not there, there is no need to demonstrate.
Looks like your job is done. If you try to simulate a problem and it doesn't happen, then life is happy.
Thanks ! No problem - No solution !
And don't propose a blanket solution. Did you think about how much CPU would be used to compute the hashing if the tables are exceptionally large?
why that wait event over any of the others? youre either getting it in a real world situation and it fixed in which case we would suggest posting it here so that we can help or if youre not, run the following and start at the top
SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;