Oracle Database Discussions

hi tuning gurus!

End users phasing very slow response time from the oracle server.i have attached statspack report below:

pls give a suggestion to increase the performance.

oracle server : AIX 5.3


Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 12,288M Std Block Size: 16K
Shared Pool Size: 2,016M Log Buffer: 256,000K

Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 854,198.68 3,161.13
Logical reads: 68,547.89 253.68
Block changes: 4,425.20 16.38
Physical reads: 1,664.99 6.16
Physical writes: 309.80 1.15
User calls: 16,590.14 61.40
Parses: 685.28 2.54
Hard parses: 0.56 0.00
Sorts: 16.67 0.06
Logons: 0.45 0.00
Executes: 7,697.94 28.49
Transactions: 270.22

% Blocks changed per Read: 6.46 Recursive Call %: 3.93
Rollback per transaction %: 83.32 Rows per Sort: 9210.22

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 97.78 In-memory Sort %: 99.98
Library Hit %: 99.99 Soft Parse %: 99.92
Execute to Parse %: 91.10 Latch Hit %: 99.80
Parse CPU to Parse Elapsd %: 2.64 % Non-Parse CPU: 99.93

Shared Pool Statistics Begin End
------ ------
Memory Usage %: 16.39 19.55
% SQL with executions>1: 91.66 84.00
% Memory for SQL w/exec>1: 81.35 68.12

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
SQL*Net message from client 88,126,574 1,090,543 91.02
rdbms ipc message 525,868 41,249 3.44
jobq slave wait 10,680 31,448 2.62
db file sequential read 2,102,593 7,275 .61
smon timer 19 5,335 .45
-------------------------------------------------------------
Wait Events for DB: TEST Instance: TEST Snaps: 6075 -6078
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)

Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
SQL*Net message from client 88,126,574 0 1,090,543 12 60.3
jobq slave wait 10,680 10,233 31,448 2945 0.0
db file sequential read 2,102,593 0 7,275 3 1.4
wakeup time manager 171 171 5,114 29906 0.0
enqueue 4,540 1,176 5,055 1113 0.0
db file scattered read 409,679 0 554 1 0.3
log file sync 242,609 1 516 2 0.2
db file parallel write 41,272 0 370 9 0.0
log file parallel write 245,240 223,644 341 1 0.2
direct path read 48,237 0 276 6 0.0
db file parallel read 23,446 0 165 7 0.0
local write wait 31,302 6 84 3 0.0
direct path write 77,110 0 63 1 0.1
SQL*Net message to client 88,126,640 0 35 0 60.3
buffer busy waits 13,014 0 33 3 0.0
SQL*Net more data from clien 501,560 0 30 0 0.3
SQL*Net more data to client 1,422,271 0 15 0 1.0
direct path read (lob) 192,767 0 15 0 0.1
control file parallel write 2,813 0 14 5 0.0
latch free 3,164 3,112 4 1 0.0
log file switch completion 189 0 3 17 0.0
sort segment request 2 2 2 1000 0.0
control file sequential read 3,477 0 0 0 0.0
direct path write (lob) 5,427 0 0 0 0.0
SQL*Net break/reset to clien 501 0 0 1 0.0
LGWR wait for redo copy 1,331 0 0 0 0.0
log file single write 92 0 0 1 0.0
library cache lock 4 0 0 5 0.0
log file sequential read 92 0 0 0 0.0
library cache pin 3 0 0 1 0.0
-------------------------------------------------------------

Background Wait Events for DB: TEST Instance: TEST Snaps: 6075 -6078
-> ordered by wait time desc, waits desc (idle events last)

Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
rdbms ipc message 524,648 233,552 35,803 68 0.4
smon timer 19 16 5,335 ###### 0.0
pmon timer 1,833 1,833 5,278 2879 0.0
db file parallel write 41,272 0 370 9 0.0
log file parallel write 245,242 223,646 341 1 0.2
control file parallel write 2,813 0 14 5 0.0
direct path write 3,358 0 1 0 0.0
db file scattered read 58 0 1 9 0.0
direct path read 6,118 0 0 0 0.0
control file sequential read 2,540 0 0 0 0.0
db file sequential read 58 0 0 7 0.0
LGWR wait for redo copy 1,331 0 0 0 0.0
log file single write 92 0 0 1 0.0
log file sequential read 92 0 0 0 0.0
rdbms ipc reply 4 0 0 0 0.0
latch free 3 0 0 0 0.0
-------------------------------------------------------------
Rollback Segment Storage for DB: TEST Instance: TEST Snaps: 6075 -6078
->Optimal Size should be larger than Avg Active

RBS No Segment Size Avg Active Optimal Size Maximum Size
------ --------------- --------------- --------------- ---------------
0 442,368 0 442,368
1 486,653,952 8,351,035 724,680,704
2 385,990,656 8,246,498 583,122,944
3 234,995,712 7,423,825 444,710,912
4 344,047,616 21,594,405 460,439,552
5 151,109,632 5,666,225 411,156,480
6 254,918,656 1,564,802 347,193,344
7 251,772,928 5,463,678 251,772,928
8 109,166,592 3,811,163 317,833,216
9 84,000,768 2,291,141 159,563,776
10 233,947,136 4,777,584 233,947,136
11 250,724,352 4,376,360 284,278,784
12 251,772,928 4,777,584 251,772,928
13 201,441,280 4,777,584 201,441,280
14 141,672,448 3,930,555 259,112,960
-------------------------------------------------------------
Undo Segment Summary for DB: TEST Instance: TEST Snaps: 6075 -6078
-> Undo segment block stats:
-> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
-> eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo Undo Num Max Qry Max Tx Snapshot Out of uS/uR/uU/
TS# Blocks Trans Len (s) Concurcy Too Old Space eS/eR/eU
---- -------------- ---------- -------- ---------- -------- ------ -------------
1 120,149 2,160,685 4,268 9 0 0 0/0/0/0/0/0
-------------------------------------------------------------


Undo Segment Stats for DB: TEST Instance: TEST Snaps: 6075 -6078
-> ordered by Time desc

Undo Num Max Qry Max Tx Snap Out of uS/uR/uU/
End Time Blocks Trans Len (s) Concy Too Old Space eS/eR/eU
------------ ------------ -------- ------- -------- ------- ------ -------------
23-Jan 10:57 10,339 379,825 4,268 6 0 0 0/0/0/0/0/0
23-Jan 10:47 14,261 350,224 147 9 0 0 0/0/0/0/0/0
23-Jan 10:37 16,024 309,751 148 5 0 0 0/0/0/0/0/0
23-Jan 10:27 14,339 268,845 421 4 0 0 0/0/0/0/0/0
23-Jan 10:17 15,106 227,595 251 3 0 0 0/0/0/0/0/0
23-Jan 10:07 15,602 189,807 148 4 0 0 0/0/0/0/0/0
23-Jan 09:57 13,537 147,060 83 8 0 0 0/0/0/0/0/0
23-Jan 09:47 11,190 111,627 1,676 4 0 0 0/0/0/0/0/0
23-Jan 09:37 5,256 92,124 164 5 0 0 0/0/0/0/0/0
23-Jan 09:27 4,495 83,827 102 7 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity for DB: TEST Instance: TEST Snaps: 6075 -6078
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

Pct Avg Wait Pct
Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
Consistent RBA 245,333 0.0 0.0 0 0
FIB s.o chain latch 232 0.0 0 0
FOB s.o list latch 5,472 0.0 0.0 0 0
JOX SGA heap latch 1,086 0.0 0 0
SQL memory manager latch 3 0.0 0 1,755 0.0
SQL memory manager worka 147,471 0.0 0.0 0 0
active checkpoint queue 82,349 0.2 0.0 0 0
archive control 5 0.0 0 0
begin backup scn array 22,225 0.0 0 0
cache buffer handles 21,557 0.0 0 0
cache buffers chains 687,377,775 0.3 0.0 0 14,752,744 0.0
cache buffers lru chain 977,350 0.0 0.0 0 17,857,376 0.0
channel handle pool latc 4,242 0.0 0 0
channel operations paren 10,373 0.1 0.0 0 0
checkpoint queue latch 8,689,548 0.0 0.0 0 460,515 0.0
child cursor hash table 39,462 0.0 0 0
commit callback allocati 564 0.0 0 0
dml lock allocation 1,338,727 0.0 0.0 0 0
dummy allocation 4,776 0.1 0.0 0 0
enqueue hash chains 2,449,156 0.0 0.0 0 0
enqueues 2,223,266 0.0 0.0 0 0
event group latch 2,159 0.0 0 0
event range base latch 1 0.0 0 0
global tx hash mapping 26,130 0.0 0 0
hash table column usage 690 0.0 0 78,259 0.0
hash table modification 1 0.0 0 0
job workq parent latch 0 0 532 4.1
job_queue_processes para 358 0.0 0 0
ktm global data 21 0.0 0 0
kwqit: protect wakeup ti 171 0.0 0 0
lgwr LWN SCN 246,171 0.0 0.0 0 0
library cache 108,333,456 0.1 0.0 0 435 0.0
library cache load lock 2,662 0.0 0 0
library cache pin 97,568,906 0.0 0.0 0 0
library cache pin alloca 13,022,740 0.0 0.0 0 0
list of block allocation 50,978 0.0 0 0
loader state object free 230,888 0.0 0.0 0 0
longop free list parent 354 0.0 0 120 0.0
messages 1,419,496 0.0 0.0 0 0
mostly latch-free SCN 246,361 0.1 0.0 0 0
multiblock read objects 1,198,262 0.0 0.0 0 0
ncodef allocation latch 87 0.0 0 0
object stats modificatio 168 0.0 0 0
post/wait queue 365,418 0.0 0.0 0 242,811 0.0
presentation list 86 0.0 0 0
process allocation 2,159 0.0 0.0 0 2,158 0.0
process group creation 4,242 0.0 0 0
redo allocation 12,585,412 0.2 0.0 0 0
redo copy 0 0 12,095,732 0.0
redo writing 822,107 0.0 0.0 0 0
Latch Activity for DB: TEST Instance: TEST Snaps: 6075 -6078
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

Pct Avg Wait Pct
Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
resumable state object 1 0.0 0 0
row cache enqueue latch 5,038,214 0.0 0.0 0 0
row cache objects 5,108,220 0.1 0.0 0 0
sequence cache 8,234 0.0 0 0
session allocation 4,224,392 0.1 0.0 0 0
session idle bit 181,534,255 0.0 0.0 0 0
session switching 87 0.0 0 0
session timer 1,834 0.0 0 0
shared pool 48,805,127 0.1 0.0 0 0
sim partition latch 0 0 3,182 0.0
sort extent pool 60,817 0.0 0 0
spilled msgs queues list 171 0.0 0 0
trace latch 80 0.0 0 0
transaction allocation 49,842 0.0 0.0 0 0
transaction branch alloc 26,217 0.0 0 0
undo global data 1,390,663 0.0 0.0 0 0
user lock 8,986 0.6 0.0 0 0
-------------------------------------------------------------
Latch Sleep breakdown for DB: TEST Instance: TEST Snaps: 6075 -6078
-> ordered by misses desc

Get Spin &
Latch Name Requests Misses Sleeps Sleeps 1->4
-------------------------- -------------- ----------- ----------- ------------
cache buffers chains 687,377,775 2,163,430 3,049 0/0/0/0/0
library cache 108,333,456 130,314 14 130300/14/0/
0/0
shared pool 48,805,127 38,947 10 38937/10/0/0
/0
redo allocation 12,585,412 28,087 4 28083/4/0/0/
0
library cache pin 97,568,906 21,466 4 21462/4/0/0/
0
session idle bit 181,534,255 16,562 80 0/0/0/0/0
enqueues 2,223,266 1,111 1 1110/1/0/0/0
cache buffers lru chain 977,350 258 2 256/2/0/0/0
-------------------------------------------------------------
Latch Miss Sources for DB: TEST Instance: TEST Snaps: 6075 -6078
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
cache buffers chains kcbchg: kslbegin: bufs not 0 1,916 1,272
cache buffers chains kcbchg: kslbegin: call CR 0 498 1,295
cache buffers chains kcbgtcr: kslbegin excl 0 361 246
cache buffers chains kcbgtcr: fast path 0 148 70
cache buffers chains kcbgcur: kslbegin 0 73 54
cache buffers chains kcbrls: kslbegin 0 17 115
cache buffers chains kcbzgb: scan from tail. no 0 13 0
cache buffers chains kcbcge 0 6 11
cache buffers chains kcbzib: multi-block read: 0 5 0
cache buffers chains kcbget: pin buffer 0 5 1
cache buffers chains kcbzwb 0 4 1
cache buffers chains kcbget: exchange rls 0 1 0
cache buffers lru chain kcbzgb: multiple sets nowa 2,993 1 0
cache buffers lru chain kcbbiop: lru scan 198 1 0
enqueues ksqies 0 1 1
library cache kglupc: child 0 6 1
library cache kglpnc: child 0 5 8
library cache kgldte: child 0 0 2 3
library cache kglhdgn: child: 0 1 5
library cache pin kglupc 0 2 2
library cache pin kglpnc: child 0 2 4
redo allocation kcrfwr 0 4 2
session idle bit ksupuc: set busy 0 52 39
session idle bit ksupuc: clear busy 0 28 39
shared pool kghupr1 0 10 11
-------------------------------------------------------------
Dictionary Cache Stats for DB: TEST Instance: TEST Snaps: 6075 -6078
->"Pct Misses" should be very low (< 2% in most cases)
->"Cache Usage" is the number of cache entries being used
->"Pct SGA" is the ratio of usage to allocated size for that cache

Get Pct Scan Pct Mod Final
Cache Requests Miss Reqs Miss Reqs Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_global_oids 176 0.0 0 0 26
dc_histogram_defs 885,416 0.6 0 6,062 56,698
dc_object_ids 495,803 0.0 0 0 3,796
dc_objects 9,997 5.5 0 0 7,735
dc_profiles 2,416 0.0 0 0 1
dc_rollback_segments 6,017 0.0 0 4 105
dc_segments 498,871 0.1 0 5 6,484
dc_sequences 133 0.0 0 133 6
dc_tablespace_quotas 5 100.0 0 5 5
dc_tablespaces 339,265 0.0 0 0 43
dc_user_grants 35,290 0.0 0 0 23
dc_usernames 7,609 0.0 0 0 19
dc_users 277,007 0.0 0 2 53
-------------------------------------------------------------


Library Cache Activity for DB: TEST Instance: TEST Snaps: 6075 -6078
->"Pct Misses" should be very low

Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
SQL AREA 2,492,314 0.1 48,468,994 0.0 684 1,233
TABLE/PROCEDURE 201,893 0.2 238,202 0.5 0 0
BODY 3,694 0.2 3,694 0.2 0 0
TRIGGER 18,574 0.0 18,574 0.0 0 0
INDEX 28,249 0.2 27,959 0.3 0 0
CLUSTER 221 0.5 214 0.9 0 0
JAVA SOURCE 12 0.0 12 0.0 0 0
JAVA DATA 24 0.0 180 0.0 0 0
-------------------------------------------------------------
Shared Pool Advisory for DB: TEST Instance: TEST End Snap: 6078
-> Note there is often a 1:Many correlation between a single logical object
in the Library Cache, and the physical number of memory objects associated
with it. Therefore comparing the number of Lib Cache objects (e.g. in
v$librarycache), with the number of Lib Cache Memory Objects is invalid

Estd
Shared Pool SP Estd Estd Estd Lib LC Time
Size for Size Lib Cache Lib Cache Cache Time Saved Estd Lib Cache
Estim (M) Factr Size (M) Mem Obj Saved (s) Factr Mem Obj Hits
----------- ----- ---------- ------------ ------------ ------- ---------------
1,200 .6 231 44,792 9,588 1.0 6,351,081
1,408 .7 231 44,792 9,588 1.0 6,351,081
1,616 .8 231 44,792 9,588 1.0 6,351,081
1,824 .9 231 44,792 9,588 1.0 6,351,081
2,032 1.0 231 44,792 9,588 1.0 6,351,081
2,240 1.1 231 44,792 9,588 1.0 6,351,081
2,448 1.2 231 44,792 9,588 1.0 6,351,081
2,656 1.3 231 44,792 9,588 1.0 6,351,081
2,864 1.4 231 44,792 9,588 1.0 6,351,081
3,072 1.5 231 44,792 9,588 1.0 6,351,081
3,280 1.6 231 44,792 9,588 1.0 6,351,081
3,488 1.7 231 44,792 9,588 1.0 6,351,081
3,696 1.8 231 44,792 9,588 1.0 6,351,081
3,904 1.9 231 44,792 9,588 1.0 6,351,081
4,112 2.0 231 44,792 9,588 1.0 6,351,081
-------------------------------------------------------------
SGA Memory Summary for DB: TEST Instance: TEST Snaps: 6075 -6078

SGA regions Size in Bytes
------------------------------ ----------------
Database Buffers 12,884,901,888
Fixed Size 773,376
Redo Buffers 262,418,432
Variable Size 8,355,053,568
----------------
sum 21,503,147,264
-------------------------------------------------------------


SGA breakdown difference for DB: TEST Instance: TEST Snaps: 6075 -6078

Pool Name Begin value End value % Diff
------ ------------------------------ ---------------- ---------------- -------
java free memory 261,480,448 261,480,448 0.00
java memory in use 6,955,008 6,955,008 0.00
large free memory 134,217,728 134,217,728 0.00
shared 1M buffer 1,056,768 1,056,768 0.00
shared Checkpoint queue 10,252,800 10,252,800 0.00
shared DML lock 1,133,624 1,133,624 0.00
shared FileIdentificatonBlock 449,664 449,664 0.00
shared FileOpenBlock 15,934,416 15,934,416 0.00
shared KGK heap 13,400 13,400 0.00
shared KGLS heap 36,221,072 39,052,192 7.82
shared KQR L PO 11,185,448 11,808,072 5.57
shared KQR M PO 29,630,632 32,522,304 9.76
shared KQR S SO 5,888 5,888 0.00
shared KSXR pending messages que 853,952 853,952 0.00
shared KSXR pending reply queue 98,680 98,680 0.00
shared KSXR receive buffers 1,034,000 1,034,000 0.00
shared LRMPD SGA Table 94,976 94,976 0.00
shared MTTR advisory 346,392 346,392 0.00
shared PL/SQL DIANA 2,824,544 3,059,224 8.31
shared PL/SQL MPCODE 1,260,776 2,048,464 62.48
shared PLS non-lib hp 2,088 2,088 0.00
shared SEQ S.O. 190,800 190,800 0.00
shared Temporary Tables State Ob 311,096 311,096 0.00
shared UNDO INFO SEGMENTED ARRAY 262,368 262,368 0.00
shared branch 474,792 474,792 0.00
shared channel handle 312,416 312,416 0.00
shared character set object 162,720 162,720 0.00
shared constraints 333,024 333,024 0.00
shared db_block_hash_buckets 27,197,744 27,197,744 0.00
shared db_handles 1,392,000 1,392,000 0.00
shared dictionary cache 3,229,952 3,229,952 0.00
shared enqueue 2,220,432 2,220,432 0.00
shared enqueue resources 813,968 813,968 0.00
shared enqueue_hash 128,880 128,880 0.00
shared errors 78,352 78,352 0.00
shared event statistics per sess 14,914,200 14,914,200 0.00
shared fixed allocation callback 1,456 1,456 0.00
shared free memory 1,865,654,896 1,795,081,816 -3.78
shared joxlod: in ehe 392,296 392,296 0.00
shared joxlod: in phe 9,664 9,664 0.00
shared joxlod: init s 10,200 10,200 0.00
shared joxs heap init 4,240 4,240 0.00
shared kglsim hash table bkts 4,194,304 4,194,304 0.00
shared kglsim heap 2,171,520 2,645,760 21.84
shared kglsim object batch 2,237,760 2,761,920 23.42
shared kglsim sga 137,544 137,544 0.00
shared ksm_file2sga region 370,496 370,496 0.00
shared ktlbk state objects 780,952 780,952 0.00
shared latch nowait fails or sle 67,136 67,136 0.00
shared library cache 68,933,360 90,562,496 31.38
shared log_buffer 8,200,224 8,200,224 0.00
shared message pool freequeue 566,184 566,184 0.00
shared messages 249,600 249,600 0.00
shared miscellaneous 16,303,536 17,846,608 9.46


SGA breakdown difference for DB: TEST Instance: TEST Snaps: 6075 -6078

Pool Name Begin value End value % Diff
------ ------------------------------ ---------------- ---------------- -------
shared network connections 60,720 60,720 0.00
shared obj htab chunk 655,896 655,896 0.00
shared parameters 28,728 64,824 125.65
shared partitioning d 173,736 173,736 0.00
shared pl/sql source 7,456 7,456 0.00
shared processes 1,536,000 1,536,000 0.00
shared qmps connections 561,800 561,800 0.00
shared replication session stats 402,800 402,800 0.00
shared session param values 14,106,176 16,175,808 14.67
shared sessions 3,582,800 3,582,800 0.00
shared set_descriptor_array 129,280 129,280 0.00
shared sim trace entries 786,432 786,432 0.00
shared sql area 65,238,928 101,067,424 54.92
shared table definiti 49,776 52,512 5.50
shared trace buffer 6,799,360 7,897,088 16.14
shared transaction 2,385,888 2,385,888 0.00
shared trigger defini 11,720 11,720 0.00
shared trigger inform 1,880 1,880 0.00
shared trigger source 3,552 3,552 0.00
shared type object de 139,568 139,568 0.00
buffer_cache 12,884,901,888 12,884,901,888 0.00
fixed_sga 773,376 773,376 0.00
log_buffer 262,407,168 262,407,168 0.00
-------------------------------------------------------------
init.ora Parameters for DB: TEST Instance: TEST Snaps: 6075 -6078

End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
trace_enabled FALSE
control_files /oracle/oradata/TEST/control
db_block_size 16384
db_writer_processes 4
db_cache_size 12884901888
db_cache_advice OFF
compatible 9.2.0.0.0
log_archive_start FALSE
log_archive_dest /oracle/oraarch
log_archive_format LOG_TEST_%s_%t.ARC
log_buffer 262144000
log_checkpoint_interval 1000000000
db_files 400
db_file_multiblock_read_count 32
fast_start_mttr_target 300
undo_management AUTO
undo_tablespace UNDOTBS1
undo_retention 21600
remote_login_passwordfile EXCLUSIVE
db_domain
instance_name TEST
shared_servers 0
shared_server_sessions 0
local_listener TESTLSNR
session_cached_cursors 50
job_queue_processes 10
hash_join_enabled TRUE
background_dump_dest /oracle/admin/TEST/bdump
user_dump_dest /oracle/admin/TEST/udump
core_dump_dest /oracle/admin/TEST/cdump
sort_area_size 2097152
sort_area_retained_size 524288
db_name TEST
open_cursors 2000
star_transformation_enabled FALSE
optimizer_index_cost_adj 20
optimizer_index_caching 65
query_rewrite_enabled FALSE
pga_aggregate_target 4294967296
aq_tm_processes 1
processes 1200
timed_statistics TRUE
resource_limit TRUE
shared_pool_size 2113929216
sga_max_size 21503147264
large_pool_size 134217728
java_pool_size 268435456
-------------------------------------------------------------