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.

Finding object in a specific cache pool

3 posts in General Discussion Last posting was on 2009-12-31 13:44:15.0Z
Yaniv C. Posted on 2009-12-27 16:21:46.0Z
Sender: 308f.4b31e96a.1804289383@sybase.com
From: Yaniv C.
Newsgroups: sybase.public.ase.general
Subject: Finding object in a specific cache pool
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b37899a.75cc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Dec 2009 08:21:46 -0800
X-Trace: forums-1-dub 1261930906 10.22.241.41 (27 Dec 2009 08:21:46 -0800)
X-Original-Trace: 27 Dec 2009 08:21:46 -0800, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28806
Article PK: 78044

Hi
I am using ASE 15.0.2 ESD6
I have Two (small) questions regaring objects on pools in
caches
1. which SQL can I perform to determine which objects are
cached in a particular named cache pool?
I tried sp_sysmon "cache_wizard" and select from
monCachedObject, there are no way to know from which pool
the pages are.

2. If a table/index is cached in a 1p pool, is it always
used the same pool or an object can have some pages on 1P
pool and other pages on the other pool?

Thanks,
Yaniv


Rob V [ Sybase ] Posted on 2009-12-31 04:41:47.0Z
Reply-To: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.general
References: <4b37899a.75cc.1681692777@sybase.com>
Subject: Re: Finding object in a specific cache pool
Lines: 45
Organization: Sypron BV / TeamSybase / Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b3c2b8b@forums-1-dub>
Date: 30 Dec 2009 20:41:47 -0800
X-Trace: forums-1-dub 1262234507 10.22.241.152 (30 Dec 2009 20:41:47 -0800)
X-Original-Trace: 30 Dec 2009 20:41:47 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28812
Article PK: 78053


<Yaniv C.> wrote in message news:4b37899a.75cc.1681692777@sybase.com...
> Hi
> I am using ASE 15.0.2 ESD6
> I have Two (small) questions regaring objects on pools in
> caches
> 1. which SQL can I perform to determine which objects are
> cached in a particular named cache pool?
> I tried sp_sysmon "cache_wizard" and select from
> monCachedObject, there are no way to know from which pool
> the pages are.

I don't think you can get this information from anywhere.

>
> 2. If a table/index is cached in a 1p pool, is it always
> used the same pool or an object can have some pages on 1P
> pool and other pages on the other pool?

A table or index can very well have some pages cached in the 1p pool and
some others in the 8p pool for example; this woud be very normal.
In which pool a page is cached depends on a number of things, like the query
plan's access method (i.e. the intended buffer pool indicated in the plan),
but also, for an 8p extent, whether the pages are mutually linked and
whether they contiguous, and some other considerations. So the buffer pool
indicated in the plan may not be the one actually used in the end.

HTH,
-----------------------------------------------------------------
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"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------