![create database oracle 10g express create database oracle 10g express](https://technology.amis.nl/wp-content/uploads/2019/04/image-2.png)
Use Manual shared Memory Management: You can allocate the memory to the various component of memory.Automatic memory management: You can allocate the memory to the SGA and PGA.You can choose any of the following options: Here you can allocate the memory to the individual component.
![create database oracle 10g express create database oracle 10g express](https://1.bp.blogspot.com/-JWYC9PTyNrE/XivJki5trHI/AAAAAAAABiA/6ciunrHuJ-AN2zNhLB_zukUaPq9r37TfQCLcBGAsYHQ/s1600/Screenshot%2B2020-01-25%2Bat%2B9.32.26%2BAM.png)
You can manage the memory component of the database. On Specify configuration options screen, you can configure the following options. You can read Configuring and Administering Oracle Net Listener to learn more about the Oracle listeners. I have chosen the pre-configured listener. We can create multiple LISTENER for their respective database or use the existing listener to connect to the database. It accepts the incoming client connection and redirects them to their respective database. The LISTENER is an important component of the database. On the Specify Network Configuration Details screen, you can specify the LISTENER details of the Oracle database.
![create database oracle 10g express create database oracle 10g express](https://i.stack.imgur.com/IB24B.png)
I have chosen file system as storage type, D:\Oracle\EltechDB\FastecoveryArea as a recovery area, and allocated 8256 MB to store the recovery files. On the Select Fast Recovery Option screen, you can provide the location and size of the recovery area used to store the recovery files.
Create database oracle 10g express how to#
In this article, we understand how to create a new database in Oracle 19c using a database configuration assistant.