 oracle 9i database performance tuning [message #409056] |
Fri, 19 June 2009 02:02  |
aqsharief
Messages: 1
Registered: August 2006
Location: Karachi
|
Junior Member |
|
|
Can any one share the important SGA parameters along with their values to make the system perform faster.
My system config. is as follows on which Sales & Distribution system is runing, its purely web based & on the backend, database used if oracle 9i.
after doing gigantic transaction over it, the system performace get too slow. The environment is as follows:
OS Platform: Microsoft Windows XP Professional Version 2002 Service Pack 2
Hardware Configuration: Intel(R) Pentium(R) 4 CPU 3.00GHz 2.99 GHz, 0.99 GB of RAM
Oracle 9i Database: 9.0.1.1.1
Kindly suggest the paramaters along with their values for tuning.
I am sending you the autotrace for the table which is being accessed frequebtly. Kinldy provide your opinion on this.
SQL> set autotrace on;
SQL> set autotrace traceonly;
SQL> select * from cashmemo;
175878 rows selected.
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1590 Card=175878 Byt es=30778650)
1 0 TABLE ACCESS (FULL) OF 'CASHMEMO' (Cost=1590 Card=175878 B
ytes=30778650)
Statistics
----------------------------------------------------------
0 recursive calls
8 db block gets
21473 consistent gets
10063 physical reads
0 redo size
36620578 bytes sent via SQL*Net to client
1536478 bytes received via SQL*Net from client
11727 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
175878 rows processed
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
