Re: How can you know if a file is BEING written ?

Spendius wrote:
>
> Hi,
> I'd just like to know if there are means of knowing
> if certain datafiles are being written or not just
> as you're querying the proper V$ view (but which one ?),
> whether they belong to normal permanent tbsps or to
> temporary ones...
>
> Thks for any help.
> Sp

v$tempstat and v$filestat will give you counts of IO - but not whether activity is *currently* occuring.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."