QuercusPlus 8.0 Installation Guide<>

Creation of QuercusPlus database instances

Create test, training and live databases

It is strongly recommended that three QuercusPlus 8.0 database instances be set up:

testing (TEST)

training (TRAINING)

production data (LIVE).

Set up tablespaces

Each database must have the following tablespaces along with the standard tablespaces. Associated datafiles should also be created:

Quercus_Data

Quercus_IDX

LOB_Data

An optional tablespace for APEX can be included if so desired:

APEX_Data

Space requirements

database instance

flashback/redo

backup area

total

small*

12

5

25

42

medium**

26

10

50

86

large***

30

10

50

90

All space in GB.

See table below for definition of ‘small’, ‘medium’ and ‘large’

small*

medium**

large***

number of concurrent QuercusPlus 8.0 users

10

30

70

number of concurrent QuercusLive users

5

10

20

number of concurrent Report users (Discoverer)

2

5

10

historic data (students /learners)

35,000

70,000

150,000

project annual intake

5,000

15,000

30,000

estimated five-year projection †

60,000

145,000

300,000

estimated ten-year projection ‡

85,000

220,000

450,000

† historic data + (projected annual × 5)

‡ historic data + (projected annual × 10)

Initialisation parameters

Each database should have the following initialisation parameters set up:

Parameter

Value

Open_Cursors

1000

Remote_Dependencies_Mode

Signature

Max_Enabled_Roles

150