learn-oracle

Oracle DBA






Oracle DBA - Oracle Optimization


Page :  1  2  3  4  5  6  7  8  9  10  11

Oracle Tuning Parameters

This lists the Oracle tuning parameters, grouping them into general areas of use and then sorting them alphabetically within the group. The section headings are the syntax for the parameters. The syntax contains information in the following format: PARAMETER [option1, option2, option3, etc..] A value that is italicized indicates that the value should be replaced with one of your own. A value that is italicized and in CAPS indicates a choice of this keyword. The / character indicates an OR condition. A value enclosed in brackets (<>) indicates the default value for that parameter. These parameters are divided into sections based on whether the parameter affects performance, enables system analysis, is a general parameter, and so on. There might be some overlap, so if a parameter is not in the section you expected, keep looking.



Oracle's explain plan

Whenever you read or write data in Oracle, you do so by issuing an SQL Statement. One of Oracle's task when it receives such a statement is to build a statement execution plan. An execution plan defines how Oracle finds or writes the data. For example, an important decision that Oracle has to take is if it uses indexes or not. And if there are more indexes, which of these is used. All this is contained in an execution plan.

Oracle9i PGA Advice Utility

Oracle9i has introduced a new advisory utility dubbed v$pga_target_advice. This utility will show the marginal changes in optimal, one-pass, and multipass PGA execution for different sizes of pga_aggregate_target, ranging from 10% to 200% of the current value.



Oracle9i PL/SQL Transforms and Performs

In Oracle9i, PL/SQL performance is enhanced by native compilation and table functions, and the language becomes more efficient. PL/SQL has received significant upgrades in Oracle9i Database. This article reviews some of the most important of these new features and enhancements.

Partitioned Tables And Indexes

Maintenance of large tables and indexes can become very time and resource consuming. At the same time, data access performance can reduce drastically for these objects. Partitioning of tables and indexes can benefit the performance and maintenance in several ways: * Partition independance means backup and recovery operations can be performed on individual partitions, whilst leaving the other partitons available. * Query performance can be improved as access can be limited to relevant partitons only. * There is a greater ability for parallelism with more partitions. All the examples shown here use the users tablespace for all partitions. In a real situation it is likely that these partitions would be assigned to different tablespaces to reduce device contention.

Partitioning in Oracle. What? Why? When? Who? Where? How?

Pavi has produced an article for Oracle DBAs interested in finding ways of partitioning the tables as well showing a new form of partitioning using Oracle 9i.Business applications are growing at a faster rate than salaries, and so is the data supporting them, especially e-business applications where the data growth has been around 20-30 percent or more annually. Oracle came up with the idea of Partitioning the Tables.

Performance Tuning Enhancements in Oracle Database 10g

Oracle 10g includes many performance tuning enhancements including: Automatic Performance Diagnostic and Tuning Features Automatic Shared Memory Management Wait Model Improvements Automatic Optimizer Statistics Collection Dynamic Sampling CPU Costing Optimizer Hints Rule Based Optimizer Obsolescence Tracing Enhancements SAMPLE Clause Enhancements Hash Partitioned Global Indexes

Power Partitioning Made Easy

Oracle9i's new list-partitioning feature lets you organize large data sets more naturally, usefully, and easily.

Query and Current in tkprof

Setting up a demonstration environment A table is created to demonstrate the use of TKPROF. This PL/SQL Script will take care of this.

Redo Log File Sizing Advisor

Correctly sizing online redo log files is critical if you want to achieve ‘maximus database performis’. 10G Grid Control provides a redo log file sizing advisor that provides administrators with an initial sizing recommendation. I’ll begin this blog by showing you how to use the automatic sizing advisor and continue our discussion by explaining the manual process of determining the size of your online redo logs.

Page :  1  2  3  4  5  6  7  8  9  10  11

More Tutorials on Oracle dba ...


Liked it ? Want to share it ? Social Bookmarking

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information


Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info





   Oracle Jobs   

   Forum
Oracle Forum   
   Ask A Question   

Oracle DBA - Step 1
Oracle DBA - Step 2
Oracle DBA - Step 3
Oracle DBA - Step 4
Oracle DBA - Step 5
Oracle DBA - Step 6
Oracle DBA - Step 7
Oracle DBA - Step 8
Oracle DBA - Step 9
Oracle DBA - Step 10

SQL Statement Tuning
Backup and Recovery Concepts
Oracle 11g New Features
Oracle E Suite & Others
Oracle Data Guard
Oracle DBA FAQ