Skip to content

dbca

Oracle 21c : Create a New Database

By Mouhamadou Diaw Oracle 21c is now released on the cloud. And in this blog I am just testing my first database creation . As earlier release dbca is still present. Just launch it 1 [oracle@oraadserver admin]$ dbca After The creation some query to verify 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15… 

8 + 1 = 9, yes, true, but …

Btw: If you really would do that (the screen shot is from 12.1.0.2): SQL> alter system set sga_target=210m scope=spfile; System altered. SQL> alter system set sga_max_size=210m scope=spfile; System altered. SQL> alter system set pga_aggregate_target=16m scope=spfile; System altered. SQL> select banner from v$version; BANNER ——————————————————————————– Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production PL/SQL Release 12.1.0.2.0 – Production CORE… 

Oracle Cloud Services DBaaS and dbi services best practices

By Franck Pachot . When we give our trainings (dbi services workshops) we signal our best practices with this logo. It’s our know-how, acquired through experience, consulting, service desk, exchange at events, beta testing, etc. that we share with our customers. Let’s have a look at a few points that we recommend to change if you provision a database with…