Re: WHAT ARE THESE FRIGGING FILES? oipsr1,oipsr2, etc...

don_ashworth_at_bmc.com wrote in message <7b175c$lrs$1_at_remarQ.com>...
>WHAT ARE THESE FRIGGING FILES? oipsr1,oipsr2, etc...
>_________________________________________________________
>
>They keep appearing in my NT C:\TEMP directory. I'm using OOO (Oracle
>Object for OLE)...and am assuming that these are some form of debug log.
At
>one point they consumed 2.9gig of disk space.
>
>What are they?
>Can I turn them off?
>Can I limit them?
>
>Don_Ashworth_at_bmc.com
>
>

Hi,

These files are used as cache.

A number of working parameters of Oracle Objects for OLE can be customized. Access to these parameters is provided through the Windows Registry or the Oracle initialization file, by default named ORAOLE.INI. For Windows 3.1, the parameters can also be set in the ORACLE.INI file (though it will still work on NT and Windows 95).The section name is "OO4O" for all parameter values (when using ORACLE.INI) and value strings remain the same. If the values cannot be found in ORACLE.INI, they are obtained from ORAOLE.INI under the original section names for backward compatibility. The complete order for determining the parameter values is: 1) Registry, 2) ORACLE.INI file, 3) file specified by ORAOLE environment variable (default is ORAOLE.INI). Tuning and Customization using Oracle Initialization file

The location of the ORAOLE.INI (default file) file is specified by the ORAOLE environment variable. Note that this variable should specify a full pathname to the Oracle initialization file, which is not necessarily named ORAOLE.INI. If this environment variable is not set, or does not specify a valid file entry, then Oracle Objects for OLE looks for a file named ORAOLE.INI in the Windows directory. If this file does not exist, all of the default values listed will apply.

[Cache Parameters]

A cache consisting of temporary data files is created to manage amounts of data too large to be maintained exclusively in memory. This cache is needed primarily for dynaset objects, where, for example, a single LONG RAW column can contain more data than exists in physical (and virtual) memory.

The default values have been chosen for simple test cases, running on a machine with limited Windows resources. Tuning with respect to your machine and applications is recommended.

Note that the values specified below are for a single cache, and that a separate cache is allocated for each object that requires one. For example, if your application contains three dynaset objects, three independent data caches are constructed, each using resources as described below.

SliceSize = 256 (default)

This entry specifies the minimum number of bytes used to store a piece of data in the cache. Items smaller than this value are allocated the full SliceSize bytes for storage; items larger than this value are allocated an integral multiple of this space value. An example of an item to be stored is a field value of a dynaset.

PerBlock = 16 (default)

This entry specifies the number of Slices (described in the preceding entry) that are stored in a single block. A block is the minimum unit of memory or disk allocation used within the cache. Blocks are read from and written to the disk cache temporary file in their entirety. Assuming a SliceSize of 256 and a PerBlock value of 16, then the block size is 256 * 16 = 4096 bytes.

CacheBlocks = 20 (default)

This entry specifies the maximum number of blocks held in memory at any one time. As data is added to the cache, the number of used blocks grows until the value of CacheBlocks is reached. Previous blocks are swapped from memory to the cache temporary disk file to make room for more blocks. The blocks are swapped based upon recent usage. The total amount of memory used by the cache is calculated as the product of (SliceSize * PerBlock * CacheBlocks).

Recommended Values: You may need to experiment to find optimal cache parameter values for your applications and machine environment. Here are some guidelines to keep in mind when selecting different values:

The larger the (SliceSize * PerBlock) value, the more disk I/O is required for swapping individual blocks.
 The smaller the (SliceSize * PerBlock) value, the more likely it is that blocks will need to be swapped to or from disk.  The larger the CacheBlocks value, the more memory is required, but the less likely it is that swapping will be required.

A reasonable experiment for determining optimal performance might proceed as follows:

Keep the SliceSize >= 128 and vary PerBlock to give a range of block sizes from 1K through 8K.
 Vary the CacheBlocks value based upon available memory. Set it high enough to avoid disk I/O, but not so high that Windows begins swapping memory to disk.
 Gradually decrease the CacheBlocks value until performance degrades or you are satisfied with the memory usage. If performance drops off, increase the CacheBlocks value once again as needed to restore performance.

[Fetch Parameters]

FetchLimit = 20 (default)

This entry specifies the number of elements of the array into which data is fetched from Oracle. If you change this value, all fetched values are immediately placed into the cache, and all data is retrieved from the cache. Therefore, you should create cache parameters such that all of the data in the fetch arrays can fit into cache memory. Otherwise, inefficiencies may result.

Increasing the FetchLimit value reduces the number of fetches (calls to the database) calls and possibly the amount of network traffic. However, with each fetch, more rows must be processed before user operations can be performed. Increasing the FetchLimit increases memory requirements as well.

FetchSize = 4096 (default)

This entry specifies the size, in bytes, of the buffer (string) used for retrieved data. This buffer is used whenever a long or long raw column is initially retrieved.

[General]

TempFileDirectory = [Path]

This entry provides one method for specifying disk drive and directory location for the temporary cache files. The files are created in the first legal directory path given by:

1. The drive and directory specified by the TMP environment variable (this method takes precedence over all others);
2. The drive and directory specified by this entry (TempFileDirectory) in the [general] section of the ORAOLE.INI file;
3. The drive and directory specified by the TEMP environment variable; or
4. The current working drive and directory.

HelpFile = [Path and File Name]

This entry specifies the full path (drive/path/filename) of the Oracle Objects for OLE help file as needed by the Oracle Data Control. If this entry cannot be located, the file ORACLEO.HLP is assumed to be in the directory where ORADC is located (normally \WINDOWS\SYSTEM).

Tuning and Customization using Windows Registry

For Windows NT and Windows 95, the Registry key is HKEY_LOCAL_MACHINE and the subkey is software\oracle\OO4O. For Windows 3.1, the parameters can also be set in the ORACLE.INI file (though it will still work on NT and Windows 95). For Windows NT and Windows 95, OO4O installation will create the following section in the Registry.

 "TempFileDirectory" =
 "Helpfile" = "oracleo.hlp"
 "FetchLimit" = 20
 "FetchSize" = 4096

"PerBlock" = 16
 "CacheBlocks" = 20
 "SliceSize" = 256 Received on Thu Feb 25 1999 - 06:47:06 CST