tailieunhanh - Optimizing Sort Operations

After completing this lesson, you should be able to do the following: List the operations that use temporary space Create and monitor temporary tablespaces Identify actions that use the temporary tablespace Describe the use of disk and memory for sorting Identify the SQL operations that require sorts Differentiate between disk and memory sorts List ways to reduce total sorts and disk sorts Determine the number of memory sorts performed Set parameters to optimize sorts | Optimizing Sort Operations Objectives After completing this lesson, you should be able to do the following: List the operations that use temporary space Create and monitor temporary tablespaces Identify actions that use the temporary tablespace Describe the use of disk and memory for sorting Identify the SQL operations that require sorts Differentiate between disk and memory sorts List ways to reduce total sorts and disk sorts Determine the number of memory sorts performed Set parameters to optimize sorts Automatic Sort Area Management Parameters for automatic sort area management: PGA_AGGREGATE_TARGET (Ranges from 10 MB to 4000 GB) WORKAREA_SIZE_POLICY AUTO | MANUAL Replaces all *_AREA_SIZE parameters Automatic Sort Area Management PGA_AGGREGATE_TARGET Specifies the target aggregate PGA memory of all server processes attached to the instance. The value of this parameter can range from 10 MB to 4000 GB. When setting this parameter, you should examine the total memory on your system that is available to the Oracle instance, subtract the SGA, and then assign the remaining memory to PGA_AGGREGATE_TARGET. WORKAREA_SIZE_POLICY Accepted values are: Auto: You can specify Auto only when PGA_AGGREGATE_TARGET is defined. Manual: The sizing of work areas is manual and based on the values of the *_AREA_SIZE parameters corresponding to the operation (for example, a sort uses SORT_AREA_SIZE). Specifying MANUAL may result in suboptimal performance and poor PGA memory utilization. PGA Management Resources Statistics to manage the PGA_AGGREGATE_TARGET initialization parameter Views for monitoring the PGA work area include: v$sql_workarea_histogram v$pgastat v$sql_workarea_active v$sql_workarea v$tempseg_usage Views to assist in sizing the PGA work area are: v$pga_target_advice v$pga_target_advice_histogram PGA Management Resources During the execution of SQL statements, server processes consume memory for various operations. Part of this memory is assigned to work areas for . | Optimizing Sort Operations Objectives After completing this lesson, you should be able to do the following: List the operations that use temporary space Create and monitor temporary tablespaces Identify actions that use the temporary tablespace Describe the use of disk and memory for sorting Identify the SQL operations that require sorts Differentiate between disk and memory sorts List ways to reduce total sorts and disk sorts Determine the number of memory sorts performed Set parameters to optimize sorts Automatic Sort Area Management Parameters for automatic sort area management: PGA_AGGREGATE_TARGET (Ranges from 10 MB to 4000 GB) WORKAREA_SIZE_POLICY AUTO | MANUAL Replaces all *_AREA_SIZE parameters Automatic Sort Area Management PGA_AGGREGATE_TARGET Specifies the target aggregate PGA memory of all server processes attached to the instance. The value of this parameter can range from 10 MB to 4000 GB. When setting this parameter, you should examine the total memory on your system .

• Cơ sở dữ liệu
• Optimizing Sort Operations
• Oracle XML Applications
• database
• data management
• Oracle XML
• Performance Tuning
• XML Data
• Administration
• Handbook of comparative public administration
• Comparative public administration
• Development public administration
• Public administration
• Developed nations
• History public administration
• Contemporary bureaucratic politics
• Administrative theory
• Ketoprofen co administration
• Febrile state on pharmacokinetics
• Pharmacokinetics of levofloxacin
• Goats following intravenous administration
• Pharmacokinetic parameters following co administration
• Doctoral thesis
• Administration management
• State Administration
• Commercial banks
• Current period
• Doctoral dissertation
• Institutionnal capacity
• State administration adapting
• Market economy development
• International intergration
• Elements of development administration
• Development administration
• Peoples particjpation
• Decision making process
• Administration of law and order
• Public policy
• Nuclear engineering and technology
• Tissue distribution of tritium following oral administration to rats
• Excretion of tritium following oral administration to rats
• Effects on genotoxicity of tritium following oral administration to rats
• Tritium following oral administration to rats
• Tax administration in ethiopia the case kolfe keranio sub
• City administration revenue office
• Kolfe Keranio Sub City
• Non probability technique
• Capital and time resources
• Business administration
• Master of Business administration thesis
• Business administration thesis
• Hypercompetition the case of VMS
• Mobile sector
• Lecture Principles of network and system administration
• Principles of network and system administration
• Bài giảng Nguyên lý quản trị mạng và hệ thống
• Distinguished names
• System administration directories
• Network information service
• Doctoral thesis summary Business administration
• Master thesis Business Administration
• Supply chain social sustainability
• Supply chain integration
• Supply chain performance
• Modern Administration
• Indian Legacy
• Building Blocks
• Profound Puzzle
• BUREAUCRATIC POLITICS
• Enhanced Administration
• Lesson Vietnam U
• Relations
• Policy Initiatives During the Carter Administration
• Developments During the
• Reagan and Bush Administrations
• Developments During the Clinton Administration
• During the Carter Administration policy
• The Clinton administration
• Ecology of development
• Planning and development
• Planning and development administration
• The use of accounting services by micro
• Small business enterprises in dembi dollo town administration
• Dembi dollo town administration
• Inventory turnover period
• Doctoral thesis summary
• Quality of bachelor training
• Bachelor training
• Microsoft Exchange Server 2003
• Administration Guide
• Exchange administration
• Exchange Server architecture
• configuring global
• manageability
• Policy Making
• Inlergavernmentztl Relations
• Bureaucracy
• Organization Behavior
• Performance Management
• Financial Management
• production management
• project management
• management experience
• methods of administration
• management know how
• personnel administration
• administration skills
• controlling personnel
• corporate control
• management tips
• managing corporate governance
• organisational levels
• theoretical frameworks
• civil service
• Flemish administration
• administration practice
• pioneering discovery
• combat infections
• genes including Toll
• different non linear
• optimization techniques
• illegal adulterant
• Public administration management
• Head of state administrative agency
• Public administration reform process
• Linux system administration
• The benefits of Linux
• System administration
• Installing Linux
• Startup and shutdown
• Tools of the trade
• LPI 101 Junior Level Administration
• Junior Level Administration
• Linux Fundamentals
• Hardware & Architecture
• Install a Linux system
• Process text streams using filters
• LPI 102 Junior Level Administration
• The Linux Documentation
• Managing Users
• Shells Scripting
• Shutdown and Runlevels