Over the past days I exchanged several emails with a very important customer regarding Fixed Objects Stats gathering in relation to database upgrade. The customer found out that it takes very long in their environment – over an hour to be precise. Relaxing on the weekend helped me a bit. And this morning, it dawned me that I’ve had two similar cases before already. Plus I didn’t blog about it yet. Now it’s time to tell you a little but about Unified Auditing and the situation when Fixed Object Stats Gathering takes very long during upgrade …… Continue reading...
This is a strange behavior – but it seems as automatic maintenance jobs are enabled after upgrade. A customer (thanks Naveen!!) sent me an email the other week asking if there’s a flag in DBUA to prevent this enabling as on some of their databases the automatic maintenance jobs are disabled on purpose.
Automatic Maintenance Jobs are enabled after upgrade
It sounded kind of strange to me – and my first test was to use the catctl.pl instead of the DBUA.
First of all I did check the status of the Automatic Maintenance Jobs in my 184.108.40.206 database:
SELECT client_name,… Continue reading...
Yesterday I received an interesting customer question:
“Do we have to gather fixed objects stats inside a PDB as well or only in the CDB$ROOT?”
The customer told me he couldn’t find anything in the documentation. Neither could I. And I did check also the usual suspects this morning “Best Practices for Gathering Statistics” – but it does not say anything about PDBs and CDBs.
Therefore I did a short test:
- Create a PDB in my Oracle 220.127.116.11 CDB:
SQL> create pluggable database PDB3 admin user adm identified by adm file_name_convert=( '/u02/oradata/CDB1/pdbseed', '/u02/oradata/CDB1/pdb3');
- Open the PDB: