Re: Newbie question .....

From: Liggs <liggs_at_hotmail.com>
Date: Tue, 4 Jun 2002 16:45:34 +0000 (UTC)
Message-ID: <adiqrd$g0r$1@knossos.btinternet.com>

See below :-

"Mahesh Hardikar" <hardikarm_at_yahoo.com> wrote in message news:4a1c57c2.0206040130.1d896974_at_posting.google.com...
> Hello ,
>
> I am a Newbie in Oracle . How do I find out table related information
> like :
>
> Current Size of Table & its related Index

dba_tables
dba_indexes

> Dependencies of / upon Table

dba_dependencies

> Index columns of table

dba_ind_columns

> Permissions on the table

dba_tab_privs

>
> Also I want to find out currently connected users to Oracle Instance &
> the last command run by those users.

    v$session
    v$open_cursor
    v$process

Received on Tue Jun 04 2002 - 11:45:34 CDT