In many companies the DBAs – and not only them – are working with the user “SYSTEM“. Is that wrong? Not necessarily but you might what to check “who did what?” for auditing purposes. And the GDPR is pushing you to thing about if using build in users or security relevant build in objects is helpful.
Who is SYSTEM? Blogbeitrag lesen »
If you create a database using dbca (Database Configuration Assistant) step 3 allows you to select one of two templates (Data Warehouse or General Purpose or Transaction Processing). Both of them have the checkbox Include datafiles enabled. If you choose one of them the database creation is easy and within less that 5 minutes the new database is up and running.
Are Database Templates useful? Blogbeitrag lesen »
Since Oracle 18 (with some restrictions) it’s possible to set the Oracle software installation directory <ORACLE_HOME> into read only. And with Version 21 this will be the default. So it’s time to get used with it – not with version 18c of course but with 19c and the patch set from october 2020 (19.9).
Read-Only Oracle Home Blogbeitrag lesen »
