Re: Questions for DBAs

From: ksjune <ksjune_at_sys.gsnu.ac.kr>
Date: Sat, 26 Jun 1999 10:00:37 +0900
Message-ID: <37742634.8C56A59D@sys.gsnu.ac.kr>

Hi!!!!
Here's some helpful idea...

> - what is the query to find out which queries
> are currently running

select a.sql_text
from v$session s, v$process p, v$sqlarea a

where s.paddr = p.addr
and   s.type != 'BACKGROUND'
and   s.process = [OS_PROCESS_NUMBER]
and   s.sql_address = a.address

and s.sql_hash_value = a.hash_value
and s.osuser = [OS_USERNAME]'

>
> - what is the query to find out how much "space"
> a user currently available to them (or is left for
> everyone)
> ??

What you mean "space"?

bye....

mailto:ksjune_at_sys.gsnu.ac.kr Received on Fri Jun 25 1999 - 20:00:37 CDT