topic VIOC, XFC and applications. in Operating System - OpenVMS

VIOC, XFC and applications.

Wim Van den Wyngaert — Mon, 27 Jun 2005 08:11:43 GMT

The discussion of MVDB made me think. For which databases, applications, ... do you better do set file/cache=no_cache ?
I'm thinking of Oracle, Sybase, DSM, SAS .... are any of these not bypassing the cache while they should because they cache data themselves ?

Or did you experience big improvements when doing it for certain file activities ?

Wim

Re: VIOC, XFC and applications.

Ian Miller. — Mon, 27 Jun 2005 10:39:52 GMT

I'm told that setting DSM files nocache is a good thing.
See http://dba.openvms.org/phorum/read.php?17,23

Re: VIOC, XFC and applications.

Wim Van den Wyngaert — Tue, 28 Jun 2005 06:09:41 GMT

I can confirm that DSM is not bypassing the cache in XFC.

I also did some simple tests and found that Sybase 11 is not bypassing VIOC when doing simple operations (create/drop table, insert).

Could someone with XFC enabled and Oracle running check a disk with Oracle files on it with sh mem/cache=file=dev:*.*/out=xxx
and check xxx for presence of Oracle files (db, rollback segm, redo log) and report his findings (on my 7.3 the file selection of sh mem didn't work). Of course on a system where /cache=no has not been specified for the files.

Or post the findings (esp. the hit rate of these files).

Wim

Re: VIOC, XFC and applications.

Lawrence Czlapinski — Tue, 28 Jun 2005 15:19:41 GMT

Wim: Some of the Oracle V8.17 files are cached. Even if some files are set no_cache a lot of Oracle files are cached. For instance on just one of the disks used by Oracle:
_DSA10:[ORACLE_V817.DBJAVA.LIB]CLASSES111.ZIP;3 (closed)
_DSA10:[ORACLE_V817.NETCONFIG]BEQLSNR.EXE;2 _DSA10:[ORACLE_V817.DBJAVA]DBJAVAUSER.COM;1 (closed)
_DSA10:[ORACLE_V817.SVRMGR]SVRMGRL.EXE;2 (open)
_DSA10:[ORACLE_V817.INSTALL]FINDVMSV.COM;1 (closed)
_DSA10:[ORACLE_V817.UTIL]UTILUSER.COM;1 (closed)
_DSA10:[ORACLE_V817.SQLPLUS]GLOGIN.SQL;1 (closed)
_DSA10:[ORACLE_V817.OCOMMON.NLS]LX10001.NLB;1 (closed)
_DSA10:[ORACLE_V817.DBJAVA]DETERMINE_INSTALLED_JDK.COM;1 (closed)
_DSA10:[ORACLE_V817.SQLPLUS]CPYUS.MSB;1 (closed)
_DSA10:[ORACLE_V817.NETWORK.ADMIN]TNSNAMES.ORA;40 (closed)
_DSA10:[ORACLE_V817.NETCONFIG]TNSLSNR_64.EXE;2 (open)
_DSA10:[ORACLE_V817.NETCONFIG]TNSLSNR.EXE;2 (open)
_DSA10:[ORACLE_V817.RDBMS]SQLLDR.EXE;2 (open)
_DSA10:[ORACLE_DATA.PCP]ORA_CONTROL2.CON;1 (open)
_DSA10:[ORACLE_V817.NETCONFIG]NETCONFIGUSER.COM;1 (closed)
_DSA10:[ADABAS.DB013]PLOG.DAT;872 (open)
_DSA10:[ORACLE_V817.DBJAVA]JDBC_SETUP_JDK11.COM;1 (closed)
_DSA10:[ORACLE_V817.NETWORK.LOG]LISTENER.LOG;2 (open)
_DSA10:[ORACLE_V817.NETWORK.ADMIN]ORASRV_NETV2_PCP.COM;2 (open)
_DSA10:[ORACLE_V817.RDBMS]RDBMSCMD.COM;1 (closed)
_DSA10:[ORACLE_V817.RDBMS]OCIUS.MSB;1 (closed)
_DSA10:[ORACLE_V817.NETWORK]NLUS.MSB;2 (open)
_DSA10:[ORACLE_V817.RDBMS]RDBMSUSER.COM;1 (closed)
_DSA10:[ORACLE_V817.UTIL]ORAUSER.COM;3 (closed)
_DSA10:[ORACLE_V817.NETWORK]BEQLSNR0.COM;1 (open)
_DSA10:[ORACLE_V817.INSTALL]ORA_BEQ.DAT;1 (closed)
_DSA10:[ORACLE_V817.SQLPLUS]SQLPLUS.EXE;2 (open)
_DSA10:[ORACLE_V817.SVRMGR]SVRMGRUSER.COM;1 (closed)
_DSA10:[ORACLE_V817.OCOMMON.NLS]LX00001.NLB;1 (closed)
_DSA10:[ORACLE_V817.SQLPLUS]SQLPLUSUSER.COM;1 (closed)
_DSA10:[ORACLE_DATA.PCP]ORA_LOG1.RDO;1 (open)
Caching is enabled, active caching mode is _DSA10:[ORACLE_V817.NETWORK]ORA_FIND_BEQ_ID.COM;1 (closed)
_DSA10:[ORACLE_V817.RDBMS]ORACLIENT64_V817.EXE;2 (open)
_DSA10:[ORACLE_V817.NETWORK]TNSLSNR.COM;1 (open)
_DSA10:[ORACLE_V817.NETWORK]TNSUS.MSB;1 (open)
_DSA10:[ORACLE_V817.UTIL]ORACLIENT_V817.EXE;2 (open)
_DSA10:[ORACLE_V817.NETCONFIG]ANOUSER.COM;1 (closed)
_DSA10:[ORACLE_V817.NETWORK.ADMIN]SQLNET.ORA;58 (closed)
_DSA10:[ORACLE_V817.OCOMMON.NLS]LX20001.NLB;1 (closed)
_DSA10:[ORACLE_V817.INSTALL]INSTALLUSER.COM;1 (closed)
_DSA10:[ORACLE_V817.OCOMMON.NLS]LX1BOOT.NLB;1 (closed)
_DSA10:[ORACLE_V817.SQLPLUS]SP2US.MSB;1 (closed)
_DSA10:[ADABAS.DB013]CLOG.DAT;8 (open)
_DSA10:[ORACLE_V817.RDBMS]ORACLE.EXE;2 (open)
Lawrence

Re: VIOC, XFC and applications.

Hein van den Heuvel — Tue, 28 Jun 2005 19:39:52 GMT

All the files Lawrence shows should be cached. They do not contain data that Oracle woudl cache in its SGA. ThatÂ´s why Wim asked for dbf and redo files and such.

fwiw,
Hei

Re: VIOC, XFC and applications.

Wim Van den Wyngaert — Wed, 29 Jun 2005 01:25:06 GMT

Lawrence,

The file that are marked with no_cache are shown with "No Caching" on the 2nd line. So all files used are in the list.

Note that pagefile.sys, swapfile and ssys$errorlog are marked as no cache by VMS itself.

Could you check/post the redo log, rollback and database files ? Of course only files that have Total QIOs (in the output) at a high value.

Thx

Wim

Re: VIOC, XFC and applications.

Wim Van den Wyngaert — Wed, 29 Jun 2005 02:43:41 GMT

It might be a good idea on some systems to keep XFC active even if the db has a cache itself. E.g. on a system where there is a lot of free memory (e.g. for disaster reasons that everything must be able to run on 1 node of a 2 node cluster). Then a oracle cache of e.g. 100 MB would be extended by XFC to 600 MB.

Only, when everything would be running on 1 node, the extended cache would be gone and performance could be (very) bad. So, ... it all depends.

Wim

Re: VIOC, XFC and applications.

Wim Van den Wyngaert — Wed, 29 Jun 2005 05:51:54 GMT

Got information from Intersystems : DSM never bypasses XFC. SO, Ian was right.

Wim

Re: VIOC, XFC and applications.

comarow — Sat, 02 Jul 2005 04:18:38 GMT

Interestly, mumps limits their cache size to 1 gb, so customers have told me they got better results with XFC on.

The only way to know for sure is to test it.

XFC just keeps getting better and better. The major improvement is the speed it releases memory in tight situations.

I usually recommend setting the db files /nocache but leaving XFC on.

Warning XFC uses as much memory ss possible, so for best use, make sure you have a lot of memory.

The see how many I/Os XFC is saving you type
show mem/cache/full

and you will see the percentage of reads satisfied by cache.