Re: Questions for DBAs

Here are a few that I find useful:

select sql_text,disk_reads,buffer_gets,rows_returned,executions from v$sqlarea
where users_executing > 0;

select owner,tablespace_name,sum(bytes) from dba_segments
group by owner,tablespace_name;

select tablespace_name,sum(bytes)
from dba_free_space
group by tablespace_name;

select tablespace_name,sum(bytes)
from dba_data_files
group by tablespace_name;

There are heaps more than can be used, but these will give you the basics.

HTH
--
Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
Is there a nospam domain?
http://www.users.bigpond.net.au/the_Den <argosy22_at_my-deja.com> wrote in message news:7l0kfr$d0b$1_at_nnrp1.deja.com...
> Hi all,
>
> I have been querying the data dictionary, finding
> out lots about it.
>
> I'm still trying to figure out:
> - what is the query to find out which queries
> are currently running
> - what is the query to find out how much "space"
> a user currently available to them (or is left for
> everyone)
> ??
>
> Can anyone tell me?
>
> Thanks in advance,
>
> Argosy
>
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sat Jun 26 1999 - 04:38:33 CDT