2004 
  
Ifa 
cle 
E it. 
han 
call 
iin- 
llo- 
e- 
en 
ent 
| for 
s less 
ded 
ur 
ly 
by 
will 
'mmo- 
You 
"he 
is 
tedly 
lica- 
holds 
iggest 
0%) 
  
ater 
International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, Vol XXXV, Part B4. Istanbul 2004 
  
where Physical Reads, Db Block Gets and Consistent Gets 
are the keywords in the VSLIBRARYCACHE view. 
In this spatial database the initial parameter, shared pool size, 
is 13680. 
4.2.1.3 Redo log buffer: The Oracle server processes copy 
redo entries from the user's memory space to the redo log 
buffer for each data manipulation language (DML) or data 
definition language (DDL) statement. The redo log buffer is a 
circular buffer. Thus, server processes can copy new entries 
over the entries in the redo log buffer that have been written to 
disk. LGWR normally writes fast enough to ensure that space is 
always available in the buffer for new entries. The 
SECONDS, IN. WAIT value of the Log Buffer Space event in 
the v$session wait view indicates the time spent waiting for 
space in the redo log buffer because the log switch does not 
occur. The Redo Buffer Allocation Retries statistic in 
VSSYSSTAT view reflects the number of times a user process 
waits for space in the redo log buffer to copy new entries over 
the entries that have been written to disk. 
In this spatial database the initial parameter, log buffer, is 
512000 bytes. 
4.2.2 Program Global Area (PGA) 
A Program Global Area (PGA) is a memory region containing 
data and control information for a single process (server or 
background). PGA initial size is fixed and operating-system 
specific. The initialization parameters OPEN LINKS and 
DB_FILES affect the sizes of PGA. 
4.2.3 Sort Area 
As Oracle constructs an index, it writes the index blocks to the 
Sort Area. When the Sort Area becomes full, its contents are 
transferred to the temporary tablespace. The larger the sort area, 
the less frequently Oracle must write intermediate results to 
temporary ^ disk ^ space. You" can determine — if 
SORT. AREA, SIZE is large enough by comparing the value of 
sorts (memory) and sorts (disk) of the Oracle dynamic view 
VSSYSSTAT. If the sorts performed on disk are greater than 
10 percent of those performed in memory, consider increasing 
the sort area. 
In this spatial database the 
SORT AREA SIZE, is 65536 bytes 
initial ^ parameter, 
5. CONCLUSION 
In practical project we need a set of technics flow about the 
data preparing, database design, database configuration and 
tuning. The technics flow is complex. And every step is 
important in the flow. When the database application takes a 
change, the database configuration may take a change too. So 
we need more experimentation to do it better. 
REFERENCE 
[1] Enviromental Systems Research institute, inc. 1999, 
Modeling our world the ESRI Guide to Geodatabase design. 
ESRI Press, 
[2] Environmental Systems Research [nstitute, Inc., 1999, 
Managing ArcSDETM Services, ESRI Press 
375 
[3] ESRI, 2002, Arc$DE Configuration and Tuning Guide for 
Oracle 
[4] Kevin Loney, Li Jisong etc. Translate, 1998.10, Oracle8i 
DBA Handbook, China Machine Press 
[5] Oracle Corporation, 1999.9, Enterprise DBA Part 2: 
Performance and Tuning