Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Unused tables

2 posts in General Discussion Last posting was on 2010-11-25 12:54:47.0Z
Dan Daradan Posted on 2010-11-25 10:38:50.0Z
From: "Dan Daradan" <x@invalid.invalid>
Newsgroups: sybase.public.ase.general
Subject: Unused tables
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4cee3cba$1@forums-1-dub>
Date: 25 Nov 2010 02:38:50 -0800
X-Trace: forums-1-dub 1290681530 10.22.241.152 (25 Nov 2010 02:38:50 -0800)
X-Original-Trace: 25 Nov 2010 02:38:50 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29728
Article PK: 78961

I have a database Sybase ASE 15.0.3
I am sure that many tables are unused since many years. But there are also
many undocumented applications, so I cannot be sure what they really do.
Is there a way to find out when a table was last accessed? Or the username
who used it last? Or how many times the table is accessed since a specific
time?


Rob V [ Sybase ] Posted on 2010-11-25 12:54:47.0Z
Message-ID: <4CEE5C9A.1030904@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: Dan Daradan <x@invalid.invalid>
Subject: Re: Unused tables
References: <4cee3cba$1@forums-1-dub>
In-Reply-To: <4cee3cba$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 25 Nov 2010 04:54:47 -0800
X-Trace: forums-1-dub 1290689687 10.22.241.152 (25 Nov 2010 04:54:47 -0800)
X-Original-Trace: 25 Nov 2010 04:54:47 -0800, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29729
Article PK: 78956


On 25-Nov-2010 11:38, Dan Daradan wrote:
> I have a database Sybase ASE 15.0.3
> I am sure that many tables are unused since many years. But there are
> also many undocumented applications, so I cannot be sure what they
> really do.
> Is there a way to find out when a table was last accessed? Or the
> username who used it last? Or how many times the table is accessed
> since a specific time?

You can use auditing for this.

You can also use the MDA table monOpenObjectActivity (see
www.sypron.nl/mda for example).
But be careful to monitor this over a long period of time. Also be
careful to have enough 'number of open object' configured, or otherwise
the counters in the MDA tables may be zeroed out at unexpected moments.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------