- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: VIOC, XFC and applications.
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2005 01:11 AM
06-27-2005 01:11 AM
VIOC, XFC and applications.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2005 03:39 AM
06-27-2005 03:39 AM
Re: VIOC, XFC and applications.
See http://dba.openvms.org/phorum/read.php?17,23
Purely Personal Opinion
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2005 11:09 PM
06-27-2005 11:09 PM
Re: VIOC, XFC and applications.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2005 08:19 AM
06-28-2005 08:19 AM
Re: VIOC, XFC and applications.
_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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2005 12:39 PM
06-28-2005 12:39 PM
Re: VIOC, XFC and applications.
fwiw,
Hei
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2005 06:25 PM
06-28-2005 06:25 PM
Re: VIOC, XFC and applications.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2005 07:43 PM
06-28-2005 07:43 PM
Re: VIOC, XFC and applications.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2005 10:51 PM
06-28-2005 10:51 PM
Re: VIOC, XFC and applications.
Wim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2005 09:18 PM
07-01-2005 09:18 PM
Re: VIOC, XFC and applications.
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.