Memory Structures and parameters |
Progress |
Example |
Oracle |
Example |
Database Buffer |
-B 125000 |
Database Buffer Cache |
db_cache_size=2400M |
|
Before-Image Buffers |
-bibufs 25 |
LOG Buffer |
log_buffer=1048576 |
database name |
-db sports |
database name |
db_name=SID |
Connections |
-n 200 |
User and System Sessions |
processes=200 |
Max Client Servers |
-Mn |
Max Shared Servers |
max_shared_servers (default 1/8 processes param) |
Other Client Server param |
-Ma, -Mi |
Other Shared Servers param |
dispatchers,shared_servers |
spin on a latch |
-spin 2000 |
spin on a latch |
spin_count=2000 |
Lock Table |
-L 100000 |
maximum number of DML locks |
dml_locks=100000 |
I18N |
cp-* |
National Language Support |
nls_* |
Date Format |
-d dmy |
Date Format |
nls_date_format=DD-MON-RR |
Background Processes |
---|
|
Asynhronous Page Writer |
APW |
Database Writer |
DBWn |
|
Before Image Writer |
BIW |
Log Writer |
LGWR |
|
After-Image Writer |
AIW |
Archive Process |
ARCn |
|
Watch Dog |
WDOG |
Process Monitor |
PMON |
|
Database Broker |
_mproserv |
System Monitor |
SMON |
|
Other Processes |
---|
Login Broker |
_mproserv |
Listener |
lsnrctl help |
|
Disk Files |
---|
Database File |
sports.db |
Control File(s) |
control01.ctl |
System Area |
sports.d1 |
System Tablespace |
system01.dbf |
D Files |
area.d |
Datafiles |
tablespace.dbf |
Before-Image File |
sports.b1 |
Redo Log and Undo tablespace (1) |
redo01.log and undotbs.dbf (1) |
After-Image File in use |
sports.a1 |
Redo Log (1) |
redo01.log (1) |
Copy of After-Image File |
sports.date_time_etc |
Archive Log |
SID.date_time_etc (2) |
Log File |
sports.lg |
Alert Log |
alert_SID.log (2) |
Parameter File |
sports.pf |
pfile (or spfile) |
initSID.ora (2) |
(1) Progress and Oracle are quite different in transaction processing. No direct map of .bi and .ai
Logical Structures |
Progress |
Example |
Oracle |
Example |
Area |
Schema Area |
Tablespace |
System Tablespace |
|
Area consists of objects |
Objects are Tables or Indexes |
Tablespace consists of segments |
Segments: Tables, Indexes, Undo, etc |
|
Each Object has one or more Clusters (SAT2) |
Clusters size could be 8,64 or 512 blocks |
Each Segment has one or more Extents |
An extent is a series of blocks that are consecutivly numbered within a datafile |
|
Clusters consist of blocks |
blocks 1,2,4 or 8K |
Extents consist of blocks |
blocks 2,4,8,16,32 or 64K |
|
Attributes |
Validation Expression |
field-name > 0 |
Constraint |
column_name > 0 |
Unknown value |
? |
NULL |
blank varchar2 '' is null |
|
Mandatory |
field-name <> ? |
NOT NULL |
column_name is not null |
|
Inactive index |
proutil -C idxbuild inactiveindexes |
Unusable index |
alter table rebuild unusable indexes; |
|