8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Multitenant : Memory Resource Management for PDBs in Oracle Database 12c Release 2 (12.2)


Anonymous said...

I think the use of "dba_hist" views requiers to get the diagnostic pack licence; the use of these views without licence could lead to Oracle fines....

Tim... said...

Hi.

I've put a warning in there. Thanks for the heads-up!

Cheers

Tim...

JMH said...

sga_target can't be changed on PDB :

ALTER SYSTEM SET sga_target=1400M SCOPE=BOTH
Rapport d'erreur -
Erreur SQL : ORA-65040: opération non autorisée à partir d'une base de données pluggable
65040. 00000 - "operation not allowed from within a pluggable database"

Tim... said...

Hi.

It looks like you are attempting this on a 12.1 instance. It works fine on 12.2 onward, which is why the article says Oracle Database 12c Release 2 (12.2).

Cheers

Tim...

Mohamed Amin said...

"noisy neighbour" excellent expression thanks for it.

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.