Re: What Views to Use?

From: Hakan <nvcinc_at_ibm.net>
Date: Fri, 29 Jan 1999 23:28:50 -0500
Message-ID: <36B28A81.32958528@ibm.net>

In Oracle 8,

SQLWKS> SELECT * FROM V$SYSTEM_PARAMETER
     2>   WHERE num = 153
     3>
NUM        NAME

TYPE
VALUE
ISDEFAULT ISSES ISSYS_MOD ISMODIFI ISADJ DESCRIPTION

---------- ----------------------------------------------------------------
----------
--------------------------------------------------------------------------------

--------- ----- --------- -------- -----

---

       153
db_files                                                                  3
1020
FALSE     FALSE FALSE     FALSE    FALSE max allowable # db files

1 row selected.

SQLWKS> desc user_objects

Column Name                    Null?    Type
------------------------------ -------- ----
OBJECT_NAME                             VARCHAR2(128)
SUBOBJECT_NAME                          VARCHAR2(30)
OBJECT_ID                               NUMBER
DATA_OBJECT_ID                          NUMBER
OBJECT_TYPE                             VARCHAR2(15)
CREATED                                 DATE
LAST_DDL_TIME                           DATE
TIMESTAMP                               VARCHAR2(19)
STATUS                                  VARCHAR2(7)
TEMPORARY                               VARCHAR2(1)
GENERATED                               VARCHAR2(1)

Not last accessed but it helps

Hakan

Van Messner wrote:

> Can anyone tellme what V$ or dba objects to look at to find the value
> for MAXDATAFILES which was set when a dtabase was first created?
> Also is there a way I can see when an object was last accessed? I'm
> trying to find out if some databases have objects which haven't been used
> for years.

>

> Thanks,

>
> Van
Received on Fri Jan 29 1999 - 22:28:50 CST