12c wrong result while playing with optimizer_adaptive_features in Singletenant

Hi there,

Db version: 12.1.0.2 in RAC on ODA X5-2 and Singletenant and VPD.

Test case query:

SELECT 
CLIENT_CODE,
CONS_CODE,
RES_DATE,
NAV_BEGIN,
NAV_END,
LEV1_NAME,
LEV2_NAME,
LEV3_NAME,
INSTR_NAME,
ASSET_CODE,
GR_RESULT,
MARK_RESULT,
FOREX_RESULT,
FEE_RESULT,
EXPOS_BEGIN,
EXPOS_END
FROM USER_XXX.DATAM_DAILY_INS
where
PER = 'E20D0A1159BC4627B1BE9EDAEAE42802';

Connected to cusarprd pdb using default service cusarprd.customer.com with user “myuser”  gives me datas.
Whatever the value of optimizer_adaptive_features.

Connected to cusarprd pdb using cusar_readwrite.customer.com with user “myuser” gives NO data.
With  optimizer_adaptive_features = false  -> no data
With  optimizer_adaptive_features = true  -> data

Differences:
The service cusarprd.customer.com is the default PDB service not created with grid infrastructure

alter session set container=cusarprd;
Session altered.

select name from dba_services;
NAME
----------------------------------------------------------------
cusarprd.customer.com
cusar_readwrite.customer.com
cusar_readonly.customer.com
cusar_snapshot.customer.com

The service cusar_readwrite.customer.com is the PDB service created with grid infrastructure

[oracle@cusoda01n1 ~]$ srvctl status service  -d arprd
Service cus_cdb_ar_readonly.customer.com is not running.
Service cus_cdb_ar_readwrite.customer.com is running on instance(s) carprd1,carprd2
Service cus_cdb_ar_snapshot.customer.com is not running.
Service cusar_readonly.customer.com is not running.
Service cusar_readwrite.customer.com is running on instance(s) carprd1,carprd2
Service cusar_snapshot.customer.com is not running.
The following two tabs change content below.

Jacques

I am Oracle Certified Master 11g & 12c database architect with significant experience in heterogeneous environments, and strong ability to lead complex and critical projects requiring multiple technical implementations. at Trivadis SA

Leave a Reply

Your email address will not be published. Required fields are marked *