Home » Infrastructure » Windows » oracle 9i database performance tuning (9.2.0)
icon8.gif  oracle 9i database performance tuning [message #409056] Fri, 19 June 2009 02:02 Go to next message
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
Re: oracle 9i database performance tuning [message #409106 is a reply to message #409056] Fri, 19 June 2009 07:21 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For this statement? None.

Regards
Michel
Previous Topic: Window command line mail
Next Topic: ODBC Connectivity problem in Windows XP
Goto Forum:
  


Current Time: Thu Mar 28 14:57:46 CDT 2024