OraFAQ Forum: Windows » oracle 9i database performance tuning

Home » Infrastructure » Windows » oracle 9i database performance tuning (9.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator