Home » RDBMS Server » Server Administration » Finding Idle Table
Finding Idle Table [message #284550] Fri, 30 November 2007 01:01 Go to next message
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 Go to previous messageGo to next message
babuknb
Messages: 1734
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 Go to previous messageGo to next message
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?

Re: Finding Idle Table [message #284561 is a reply to message #284550] Fri, 30 November 2007 01:21 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way.

Regards
Michel
Previous Topic: ORA-00060: Deadlock detected
Next Topic: oraparam.ini
Goto Forum:
  


Current Time: Thu Dec 08 08:16:13 CST 2016

Total time taken to generate the page: 0.04913 seconds