Oracle Intelligent Storage Protocol (OISP) enables the Oracle direct NFS (dNFS) client to encode and pass attributes associated with I/O requests to the appliance. These attributes contain such information as the type of database file that the I/O request is targeting, the record size of the file, whether to cache the I/O data, and the identity of the database issuing the I/O request.
The appliance decodes these attributes, using them to simplify database configuration, increase database performance, and provide observability into the source of I/O workloads being generated by database clients.
The Oracle dNFS client can pass the optimal record size based on the type of file for each I/O request. If a record size is passed, it overrides the "Database record size" property setting on the share or project. The record size can only be set for newly created files. If a file already exists, the record size is not changed.
The Oracle dNFS client can pass a write bias "hint" associated with write I/O requests that prompts the appliance to treat I/O requests as either latency sensitive or throughput oriented. If the hint is passed, it overrides the "Synchronous write bias" property setting on the share or project.
The Oracle Database 12c dNFS client can pass the identification of the database (SID) or container database and pluggable database (SID:SID) responsible for issuing I/O requests. Oracle ZFS Storage Appliance analytics can display I/O statistics broken down by the SID name(s) of the database by selecting breakdown or drill by "Application ID."
With OS8.7 and later firmware on Oracle ZFS Storage Appliance, additional OISP database analytics may be displayed. OISP operations by client, file name, database name, database file type, database function, share, project, size file offset and latency are all available.
The Oracle Database 12.2 or later dNFS client includes caching hints on I/O requests. Negative caching hints are included on I/O requests that do not expect to soon reference the data read or written again, such as datafile blocks read, and backup pieces written as part of Oracle Recovery Manager (Oracle RMAN) backup. This assists the appliance in making the best use of available memory in caching filesystem data. The main negatively cached operations are: Oracle RMAN reads and writes, Oracle Database datafile and redo log file creation, and Oracle Database Archiver reads and writes.
Protocols: NFSv4.0 and NFSv4.1
Clients: Oracle Database NFS (dNFS) client