Re: How to clear UNDOTBS- Slightly OT

From: Rich Jesse <>
Date: Tue, 19 Jan 2010 09:20:05 -0600 (CST)
Message-ID: <>

Hey Kerry,

I'll have to give that a shot here.

Ain't this list great?! :)

Thanks for the improvements!!!

> Hi Rich,
> That's a pretty useful idea and script. I think the sql_id of v
> $sort_usage view reports the prev_sql_id and not the current sql_id
> though (at least it appears so in and in the quick
> test I did). Maybe that was intentional. Anyway, the following select
> gives me the sql statement causing the temp usage while it is happening.
> SELECT sysdate "TIME_STAMP", vsu.username, vs.sql_id,


Received on Tue Jan 19 2010 - 09:20:05 CST

Original text of this message