Oracle release 11.2 has introduced nee dnfs (direct NFS or Direct
Network File System) for information about process connections to
NFS filesystems.
v$dnfs_channels: The channels dedicated to each direct
NFS mount
v$dnfs_files: This displays all process files that are opened
through direct NFS.
v$dnfs_servers: These are the NFAS
servers connected via direct NFS and includes information on server
name (hostname) mount point and directory name.
v$dnfs_stats:
Here are the Direct BFS stats columns kept for each AWR snapshot:
pnum
Oracle process number that statistics are relevant to
nfs_null
Null
nfs_getattr Get
attributes
nfs_setattr
Set attributes
nfs_lookup
Lookup object
nfs_access
Access object
nfs_readlink Read link
nfs_read
Read file
nfs_write
Write file
nfs_create
Create file
nfs_mkdir
Make directory
nfs_symlink Symbolic link
nfs_mknod Make node
nfs_remove Remove file
nfs_rmdir
Remove directory
nfs_rename Rename
nfs_link
Link
nfs_readdir Read
directory
nfs_readdirplus Read directory plus
nfs_fsstat
File system status
nfs_fsinfo
File system information
nfs_pathconf Path
configuration
nfs_commit Commit
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
