| Finding Idle Table [message #284550] |
Fri, 30 November 2007 01:01  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Dear All,
I want to know some idle tables in some of my production Schema
For Example
i want to search those tables on which no activity (select,insert,update,delete) for the last 2-months.
Auditing is available for this task but i don't have auditing enabled ,is there any other option except auditing ?
Please suggest!
|
|
|
|
| Re: Finding Idle Table [message #284552 is a reply to message #284550] |
Fri, 30 November 2007 01:05  |
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
|
Senior Member |
 
|
|
SQL> desc user_objects
Name Null? Type
----------------------------------------- -------- ----------------------------
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(18)
CREATED DATE
[B] LAST_DDL_TIME DATE[/B]
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1) [Updated on: Fri, 30 November 2007 01:06] Report message to a moderator |
|
|
|
| Re: Finding Idle Table [message #284559 is a reply to message #284550] |
Fri, 30 November 2007 01:20 |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
but by using this view we can only find out the ddl statements (alter,drop,truncate etc ) executed but i want to know about other activity like select,insert,update,delete
is it possbile without auditing?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
