Oracle - Could you explain the areas where tuning of database is required?
posted by Babu Kunwar
Could you explain the areas where tuning of database is required?
The following are the areas of concern for tuning:
-
Memory Usage
-
Data Storage
-
Data Manipulation
-
Physical Storage
-
Logic Storage
-
Network Traffic
Tuning Memory Usage: In Oracle 10g, we can use the Automatic
Workload Repository (AWR) toolset to gather and manage statistical data but in
case of Oracle 11g, we can use new initialization parameters such as
MEMORY_TARGET to further control the overall memory used by Oracle. It helps us
to tune the database automatically when we don’t have time to read the AWR
report.
Tuning Data Manipulation: There are two ways to tune Data
manipulation in Oracle one way is through Conventional Path mode and second is
Direct Path mode.
Tuning Physical Storage: We need to tune the physical storage
because it limits the disk in database. This can be done by: Distributing I/O,
Striping and Mirroring.
More links
What is oracle forms and what is it used for?
Explain how to iterate through items and records in a specified block in oracle
form.
How to bypass the oracle login screen......... .
|
