Oracle Cloud Infrastructure Documentation

Database Sizing Templates

When you create a database using the dbcli create-database command, you can specify a database sizing template with the --dbshape parameter. The sizing templates are configured for different types of database workloads. Choose the template that best matches the most common workload your database performs:

  • Use the OLTP templates if your database workload is primarily online transaction processing (OLTP).
  • Use the DSS templates if your database workload is primarily decision support (DSS) or data warehousing.
  • Use the in-memory (IMDB) templates if your database workload can fit in memory, and can benefit from in-memory performance capabilities.

The following tables describe the templates for each type of workload.

OLTP Database Sizing Templates

Template

CPU Cores

SGA (GB)

PGA (GB)

Flash (GB)

Processes

Redo Log File Size (GB)

Log Buffer (MB)

odb1s

1

2

1

6

200

1

16

odb1

1

4

2

12

200

1

16

odb2

2

8

4

24

400

1

16

odb4

4

16

8

48

800

1

32

odb6

6

24

12

72

1200

2

64

odb8

8

32

16

n/a

1600

2

64

odb10

10

40

20

n/a

2000

2

64

odb12

12

48

24

144

2400

4

64

odb16

16

64

32

192

3200

4

64

odb20

20

80

40

n/a

4000

4

64

odb24

24

96

48

192

4800

4

64

odb32

32

128

64

256

6400

4

64

odb36

36

128

64

256

7200

4

64

DSS Database Sizing Templates

Template

CPU Cores

SGA (GB)

PGA (GB)

Processes

Redo Log File Size (GB)

Log Buffer (MB)

odb1s

1

1

2

200

1

16

odb1

1

2

4

200

1

16

odb2

2

4

8

400

1

16

odb4

4

8

16

800

1

32

odb6

6

12

24

1200

2

64

odb8

8

16

32

1600

2

64

odb10

10

20

40

2000

2

64

odb12

12

24

48

2400

4

64

odb16

16

32

64

3200

4

64

odb20

20

40

80

4000

4

64

odb24

24

48

96

4800

4

64

odb32

32

64

128

6400

4

64

odb36

36

64

128

7200

4

64

In-Memory Database Sizing Templates

Template

CPU Cores

SGA (GB)

PGA (GB)

In-Memory (GB)

Processes

Redo Log Lile Size (GB)

Log Buffer (MB)

odb1s

1

2

1

1

200

1

16

odb1

1

4

2

2

200

1

16

odb2

2

8

4

4

400

1

16

odb4

4

16

8

8

800

1

32

odb6

6

24

12

12

1200

2

64

odb8

8

32

16

16

1600

2

64

odb10

10

40

20

20

2000

2

64

odb12

12

48

24

24

2400

4

64

odb16

16

64

32

32

3200

4

64

odb20

20

80

40

40

4000

4

64

odb24

24

96

48

48

4800

4

64

odb32

32

128

64

64

6400

4

64

odb36

36

128

64

64

7200

4

64