Sybex OCA Oracle 10g Administration I Study Guide phần 6

Hoạt động mà bạn có thể cần phải thực hiện trên datafiles bao gồm: Thay đổi kích thước họ cân nhắc kỹ chúng Di chuyển tuyến hoặc trực tuyến (đổi tên) họ Phục hồi Một kỹ thuật hữu ích để quản lý không gian đĩa được sử dụng bởi datafiles là cho phép AUTOEXTEND, mà nói với cơ sở dữ liệu để tự động phóng to một datafile khi tablespace chạy ra khỏi không gian trống. Các thuộc tính AUTOEXTEND áp dụng. | 288 Chapter 5 Oracle Shared Server Managing Shared Server After you configure the Oracle Shared Server parameters you need to understand how to view information about Oracle Shared Server. Oracle provides a set of dynamic performance views that you can use to gather information about the Oracle Shared Server configuration and the performance of the Oracle Shared Server. You can also gather information about Oracle Shared Server connections by using the lsnrctl utility. In the following sections we will explain how to display information about Oracle Shared Server connections using the listener utility and discuss the various dynamic performance views used to manage Shared Server. Displaying Information about Shared Server Connections Using the Listener Utility You can use the Isnrctl command-line listener utility to display information about the dispatcher processes. Remember from the previous section that the Oracle background process PMON registers dispatcher information with the listener. The listener keeps track of the current connection load for all the dispatchers. Use the lsnrctl services query to view information about dispatchers. The following example shows a listener listening for two TCP IP dispatchers D lsnrctl services LSNRCTL for 32-bit Windows Version - Production on 21-APR-2004 20 50 35 Copyright c 1991 2004 Oracle. All rights reserved. Connecting to DESCRIPTION ADDRESS PROTOCOL TCP HOST MJW01 PORT 1521 Services Summary. Service PLSExtProc has 1 instance s . Instance PLSExtProc status UNKNOWN has 1 handler s for this service. Handler s DEDICATED established 0 refused 0 LOCAL SERVER Instance MJW status READY has 3 handler s for this service. Handler s DEDICATED established 0 refused 0 state ready LOCAL SERVER Managing Shared Server 289 D001 established 11 refused 1 current 1 max 1002 state ready DISPATCHER machine MJW01 pid 504 ADDRESS PROTOCOL tcp HOST MJW01 PORT 4152 D000 established 15 refused 3 current 2 max 1002 state ready .