Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

VIOC, XFC and applications.

 
Wim Van den Wyngaert
Honored Contributor

VIOC, XFC and applications.

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
Wim
8 REPLIES
Ian Miller.
Honored Contributor

Re: VIOC, XFC and applications.

I'm told that setting DSM files nocache is a good thing.
See http://dba.openvms.org/phorum/read.php?17,23
____________________
Purely Personal Opinion
Wim Van den Wyngaert
Honored Contributor

Re: VIOC, XFC and applications.

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
Wim
Lawrence Czlapinski
Trusted Contributor

Re: VIOC, XFC and applications.

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
Hein van den Heuvel
Honored Contributor

Re: VIOC, XFC and applications.

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
Wim Van den Wyngaert
Honored Contributor

Re: VIOC, XFC and applications.

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
Wim
Wim Van den Wyngaert
Honored Contributor

Re: VIOC, XFC and applications.

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
Wim
Wim Van den Wyngaert
Honored Contributor

Re: VIOC, XFC and applications.

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

Wim
Wim
comarow
Trusted Contributor

Re: VIOC, XFC and applications.

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.