Tuning the oracle shared server

Xem 1-4 trên 4 kết quả Tuning the oracle shared server
  • After completing this lesson, you should be able to do the following: Identify issues associated with managing users in an Oracle Shared Server environment Configure the Oracle Shared Server environment to optimize performance Diagnose and resolve performance issues with Oracle Shared Server processes

    ppt14p trinh02 28-01-2013 24 4   Download

  • Oracle Server Configuration Options Oracle creates server processes to handle the requests of user processes connected to an instance. A server process can be either a dedicated server process, where one server process services only one user process, or it can be a shared server process, where a server process can service multiple user processes. Shared server processes are a part of Oracle Shared Server architecture.

    ppt30p trinh02 28-01-2013 21 4   Download

  • Defined by SHARED_POOL_SIZE Library cache contains statement text, parsed code, and execution plan. Data dictionary cache contains definitions for tables, columns, and privileges from the data dictionary tables. UGA contains session information for Oracle Shared Server users when a large pool is not configured.

    ppt50p trinh02 28-01-2013 25 3   Download

  • Profiles A profile is a named set of the following password and resource limits: Password aging and expiration Password history Password complexity verification Account locking CPU time Input/output (I/O) operations Idle time Connect time Memory space (private SQL area for Shared Server only) Concurrent sessions After a profile has been created, the database administrator can assign it to each user. If resource limits are enabled, the Oracle server limits the database usage and resources to the defined profile of the user....

    ppt38p trinh02 28-01-2013 19 3   Download

Đồng bộ tài khoản