administration guide 11g(6)

oracle 11g管理篇

getenv................................................................................................................................................4-47 modify...............................................................................................................................................4-49 remove..............................................................................................................................................4-53 setenv................................................................................................................................................4-56 start....................................................................................................................................................4-58 status.................................................................................................................................................4-62 stop....................................................................................................................................................4-65 unsetenv............................................................................................................................................4-69 CRSCTL Command Reference...........................................................................................................4-71 check..................................................................................................................................................4-72 config.................................................................................................................................................4-73 disable...............................................................................................................................................4-74 enable................................................................................................................................................4-75 start....................................................................................................................................................4-76 stop....................................................................................................................................................4-77 5 Managing Processes

About Dedicated and Shared Server Processes.................................................................................. 5-1 Dedicated Server Processes.............................................................................................................. 5-1 Shared Server Processes.................................................................................................................... 5-2 About Database Resident Connection Pooling.................................................................................. 5-4 Comparing DRCP to Dedicated Server and Shared Server......................................................... 5-5 Restrictions on Using Database Resident Connection Pooling................................................... 5-6 Configuring Oracle Database for Shared Server............................................................................... 5-6 Initialization Parameters for Shared Server................................................................................... 5-6 Memory Management for Shared Server....................................................................................... 5-7 Enabling Shared Server..................................................................................................................... 5-7 Configuring Dispatchers................................................................................................................5-10 Disabling Shared Server.................................................................................................................5-14 Shared Server Data Dictionary Views..........................................................................................5-15 Configuring Database Resident Connection Pooling....................................................................5-15 Enabling Database Resident Connection Pooling......................................................................5-16 Configuring the Connection Pool for Database Resident Connection Pooling.....................5-17 Data Dictionary Views for Database Resident Connection Pooling........................................5-19 About Oracle Database Background Processes...............................................................................5-19 Managing Processes for Parallel SQL Execution............................................................................5-20 About Parallel Execution Servers.................................................................................................5-21 Altering Parallel Execution for a Session.....................................................................................5-21 Managing Processes for External Procedures..................................................................................5-22 About External Procedures............................................................................................................5-22 DBA Tasks to Enable External Procedure Calls..........................................................................5-23 Terminating Sessions............................................................................................................................5-23 Identifying Which Session to Terminate......................................................................................5-24 Terminating an Active Session......................................................................................................5-24 Terminating an Inactive Session...................................................................................................5-25 Process and Session Data Dictionary Views....................................................................................5-25

vii