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:
[code language=”sql”]
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’;
[/code]
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
[code language=”sql”]
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
[/code]
The service cusar_readwrite.customer.com is the PDB service created with grid infrastructure

[code language="sql"]
[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.
[/code]


     

Leave a Reply

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