DSXchange

Hi all,
I have a question.
Our jobs read/write data through an Oracle Connector from DB.
Due to security reasons, the access to table happens using synonyms and views.

Our DBA noticed many access to metadata table ALL_SYNONYMS, ALL_VIEWS, ALL_TABLES, done by user datastage.


About your opinion, is there some reason?
Is there some behavior related to Oracle Connectore DS?

Thanks in advance,
Sandro

From what I have heard, it is quite normal and expected for DataStage to read from various system tables no matter what database is being accessed.

Gathering metadata, as you noted.

Our dba complain of excessive use.
So I ty to understand the behavior and if there is some issue to avoid or mitigate it.
Thank you

I'm not sure what "excessive use" might mean... it's not like the tables will wear out or something. Or are you being billed for your access, hence the concern?

As noted it is normal, customary and I assume essential behavior and I'm not aware of any way to mitigate it. However, if you really need to pursue this, open up a support case and see if there is anything that can be done.

Every time you run a job, or use View Data, DataStage checks for metadata mismatch. It has to go to system tables in order to be able to do this.

Any database worth its salt should be able to handle large numbers of small select queries that don't require exclusive locks. Your DBA needs to be made aware of DataStage's behaviour and the reason for it. And of the fact that it cannot be disabled.

It's a DBA's role to provision a system that can do what its users require.

Thank you for your support.

Our DBA opened an SR to Oracle Support to verify presence of some problem on metadata management on 12C.

Cheers,
Sandro

Ah... 12c. Probably worth mentioning.

Oracle 12c Release 1 or Oracle 12c Release 2 ?