'How to configure the optimization settings for Oracle Database 21c Express Edition?
Is there a similar program to PGTune but for the Oracle? Should I configure it in some file?
Solution 1:[1]
Oracle 21c XE has few installation options. Express Edition is free and is limited to a small amount of CPU threads, memory, and disk space. There's not a lot to optimize.
But if you use Enterprise or Personal edition, the Database Configuration Assistant that comes with the default installation download has several options that are kind of similar to what PGTune offers.
For example, while PGTune lets you select a database type from one of DW, OLTP, Web, Mixed, or Desktop, Oracle DBCA lets your choose between Data Warehouse, General Purpose or Transaction Processing, or Custom Database:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Jon Heller |