10-26-2005 01:58 AM
"set file _$3$DKD103:[DB.FMS_MTHEND]*.*;*/CACHING_ATTRIBUTE=
A subsequent DIR/FUL of the files reveals that caching IS turned off:
FMS_MTHEND.RDB;1 File ID: (388,39,0)
Size: 286/546 Owner: [MIS,WIRT]
Created: 1-OCT-2005 06:00:22.34
Revised: 26-OCT-2005 08:44:06.01 (116)
File organization: Sequential
Shelved state: Online
Caching attribute: No_caching
File attributes: Allocation: 546, Extend: 0, Global buffer count: 0, No version limit, Contiguous best try, Backups disabled
Record format: Undefined, maximum 0 bytes, longest 0 bytes
Record attributes: None
RMS attributes: None
Journaling enabled: None
File protection: System:RWED, Owner:RW, Group:, World:
Access Cntrl List: (IDENTIFIER=[SYSTEM],ACCESS=READ+WRITE+CONTROL+BIT
Client attributes: None
But the SHOW MEM command seems to indicate that the files are still being cached!?
System Memory Resources on 26-OCT-2005 08:53:39.22
Extended File Cache File Statistics:
Caching is enabled, active caching mode is No Caching
Allocated pages 0 Total QIOs 45
Read hits 0 Virtual reads 32
Virtual writes 13 Hit rate 0 %
Read aheads 0 Read throughs 0
Write throughs 0 Read arounds 32
Write arounds 13
These are Oracle Rdb database files and I have closed and opened the database after issuing the SET FILES command, but the SH MEM still shows cache activity on the files.
Can anyone explain this behaviour?
Am I not doing something correctly?
Thanks for your help,
Solved! Go to Solution.
10-26-2005 02:14 AM
I'm not sure what you are seeing as the problem -- active caching mode is "No Caching" and allocated pages is 0. This means there are no system resources allocated to caching for the file in question.
The "Caching is enabled" I believe indicates only that caching is enabled at the system level.
10-26-2005 02:20 AM
You might get the same effect if you can do a shared open against it with Oracle up and running, but if Oracle has it open for exclusive access you won't be able to pull that off.
10-26-2005 04:50 AM
from your Forum Profile:
I have assigned points to 5 of 22 responses to my questions.
Some of those are quite old.
Maybe you can find some time to do some assigning?
Mind, I do NOT say you necessarily need to give lots of points. It is fully up to _YOU_ to decide how many. If you consider an answer is not deserving any points, you can also assign 0 ( = zero ) points, and then that answer will no longer be counted as unassigned.
Consider, that every poster took at least the trouble of posting for you!
To easily find your streams with unassigned points, click your own name somewhere.
This will bring up your profile.
Near the bottom of that page, under the caption â My Question(s)â you will find â questions or topics with unassigned points â Clicking that will give all, and only, your questions that still have unassigned postings.
Thanks on behalf of your Forum colleagues.
PS. â nothing personal in this. I try to post it to everyone with this kind of assignment ratio in this forum. If you have received a posting like this before â please do not take offence â none is intended!
Have one on me.