Oracle 23c: Managing Flashback Database Logs Outside the Fast Recovery Area
Overview: In previous Database releases, you could store flashback database logs only in the fast recovery area Oracle 23c Database introduces the ... Read More
Apprenez-en plus sur les raisons pour lesquelles Eclipsys a été certifié comme un excellent lieu de travail au Canada, les meilleurs lieux de travail en Ontario et en technologie, et a été nommé le meilleur employeur de PME au Canada pendant 3 ans !
En savoir plus !In this blog, I’ll demonstrate the steps to create MySQL configuration using OCI console for MySQL.VM.Standard.E3.1.8GB shape, then create a new MySQL standalone DB system using the new configuration.
Prerequisites:
1. Sign in to the OCI console
2. Open the navigation menu and navigate to “Databases -> Configurations“
3. The list of configurations is displayed. Choose your compartment
4. Click the “Create Configuration” button
5. In the “Create Configuration” window, enter and select the below options, then click the “Create” button
– Enter name and description
– Select compartment
– Click the “Change shape” button and select MySQL.VM.Standard.E3.1.8GB shape from the list
– Under the “User variables” section, add below variables:
– max_connections = 200
– sort_buffer_size = 500000
– time_zone = -5:00
6. Once create configuration finishes, the configuration details page is displayed
7. We can now use the new configuration when creating the MySQL DB system. In the “Create DB System” wizard:
– Under the “Configure Hardware” section, make sure to select “MySQL.VM.Standard.E3.1.8GB” shape
– Click “Show advanced options“, select the “Configuration” tab, click the “Select Configuration” button, then select “MyConfig” configuration from the available list
Overview: In previous Database releases, you could store flashback database logs only in the fast recovery area Oracle 23c Database introduces the ... Read More
Overview: Oracle 23c Database introduces a new feature to control whether a user or session is enabled for read-write operations, irrespective of the ... Read More