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.

How to find which objects are "open" ?

4 posts in General Discussion Last posting was on 2011-10-16 10:19:33.0Z
Yaniv C Posted on 2011-10-16 09:25:43.0Z
Sender: 36e4.4e9aa1f9.1804289383@sybase.com
From: Yaniv C
Newsgroups: sybase.public.ase.general
Subject: How to find which objects are "open" ?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e9aa317.3726.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Oct 2011 02:25:43 -0700
X-Trace: forums-1-dub 1318757143 10.22.241.41 (16 Oct 2011 02:25:43 -0700)
X-Original-Trace: 16 Oct 2011 02:25:43 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30596
Article PK: 73487

Hi
My ASE 15.5 configure with "number of open objects" 50,000.

sp_monitorconfig "number of open objects" tells that 25,000
are active.
From sysmon, metedata cache chapter, number of objects
active 25,000.

sp_countmetadata "open objects" tells that ~1500 objects are
active.
Running select count(*) from sysobjects from all databases
and temp databases are more like 1500 rather 25,000.

How to find which "open objects" are active/open/in use" ?

Thanks,
Yaniv


Rob V Posted on 2011-10-16 10:04:17.0Z
From: Rob V <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: How to find which objects are "open" ?
References: <4e9aa317.3726.1681692777@sybase.com>
In-Reply-To: <4e9aa317.3726.1681692777@sybase.com>
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
Message-ID: <4e9aac21$1@forums-1-dub>
Date: 16 Oct 2011 03:04:17 -0700
X-Trace: forums-1-dub 1318759457 10.22.241.152 (16 Oct 2011 03:04:17 -0700)
X-Original-Trace: 16 Oct 2011 03:04:17 -0700, vip152.sybase.com
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30597
Article PK: 73488


On 16-Oct-2011 11:25, Yaniv C wrote:
> Hi
> My ASE 15.5 configure with "number of open objects" 50,000.
>
> sp_monitorconfig "number of open objects" tells that 25,000
> are active.
> From sysmon, metedata cache chapter, number of objects
> active 25,000.
>
> sp_countmetadata "open objects" tells that ~1500 objects are
> active.
> Running select count(*) from sysobjects from all databases
> and temp databases are more like 1500 rather 25,000.
>
> How to find which "open objects" are active/open/in use" ?
>
> Thanks,
> Yaniv

Keep in mind that when you use the statement cache or dynamic SQL, or
when you execute a stored proc, you need to count each of those cache
entities as an 'open object' as well.
If you want to see which objects are currently 'open', run 'dbcc des'
and grep for 'objname='.


--
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
-----------------------------------------------------------------


Yaniv C. Posted on 2011-10-16 10:19:33.0Z
Sender: 3957.4e9aab35.1804289383@sybase.com
From: Yaniv C.
Newsgroups: sybase.public.ase.general
Subject: Re: How to find which objects are "open" ?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e9aafb5.3a69.1681692777@sybase.com>
References: <4e9aac21$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Oct 2011 03:19:33 -0700
X-Trace: forums-1-dub 1318760373 10.22.241.41 (16 Oct 2011 03:19:33 -0700)
X-Original-Trace: 16 Oct 2011 03:19:33 -0700, 10.22.241.41
Lines: 55
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30599
Article PK: 73490

dbcc des results ~25,000
this one helped.

Thanks,
Yaniv

\> On 16-Oct-2011 11:25, Yaniv C wrote:
> > Hi
> > My ASE 15.5 configure with "number of open objects"
> 50,000. >
> > sp_monitorconfig "number of open objects" tells that
> > 25,000 are active.
> > From sysmon, metedata cache chapter, number of objects
> > active 25,000.
> >
> > sp_countmetadata "open objects" tells that ~1500 objects
> > are active.
> > Running select count(*) from sysobjects from all
> > databases and temp databases are more like 1500 rather
> 25,000. >
> > How to find which "open objects" are active/open/in use"
> ? >
> > Thanks,
> > Yaniv
>
> Keep in mind that when you use the statement cache or
> dynamic SQL, or when you execute a stored proc, you need
> to count each of those cache entities as an 'open object'
> as well. If you want to see which objects are currently
> 'open', run 'dbcc des' and grep for 'objname='.
>
>
> --
> 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
> ----------------------------------------------------------
> -------
>


Yaniv C. Posted on 2011-10-16 10:06:55.0Z
Sender: 3957.4e9aab35.1804289383@sybase.com
From: Yaniv C.
Newsgroups: sybase.public.ase.general
Subject: Re: How to find which objects are "open" ?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e9aacbf.39b9.1681692777@sybase.com>
References: <4e9aa317.3726.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Oct 2011 03:06:55 -0700
X-Trace: forums-1-dub 1318759615 10.22.241.41 (16 Oct 2011 03:06:55 -0700)
X-Original-Trace: 16 Oct 2011 03:06:55 -0700, 10.22.241.41
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30598
Article PK: 73489

One more thing to add:
master.dbo.monOpenObjectActivity count is ~900 records.
~900 open objects.

So now, I am total confused...

Is someone has idea how to detece those 25,000 objects?

> Hi
> My ASE 15.5 configure with "number of open objects"
> 50,000.
>
> sp_monitorconfig "number of open objects" tells that
> 25,000 are active.
> From sysmon, metedata cache chapter, number of objects
> active 25,000.
>
> sp_countmetadata "open objects" tells that ~1500 objects
> are active.
> Running select count(*) from sysobjects from all databases
> and temp databases are more like 1500 rather 25,000.
>
> How to find which "open objects" are active/open/in use" ?
>
> Thanks,
> Yaniv