"V$RESOURCE_LIMIT" Reference Note
Oracle9i Information
- This view displays information about global resource use for some of the system resources. Use this view to monitor the consumption of resources so that you can take corrective action, if necessary.Some resources, those used by DLM for example, have an initial allocation (soft limit), and the hard limit, which is theoretically infinite (although in practice it is limited by SGA size). During SGA reservation/initialization, a place is reserved in SGA for the
本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1277550
