Database Administration (MOSC)

MOSC Banner

oracle 18C - setting db_files parameter at PDB level

edited May 10, 2019 12:42PM in Database Administration (MOSC) 5 commentsAnswered

Hello ,

Regarding db_files limit setting at PDB level. From 12c we can set db_files limit at every individual PDB level which is more than the limit set at CDB level.

Am currently working with 18C version (18.3.0) where db_files limit is set to high at PDB level to accommodate more datafiles. Post that when i try to add datafiles at PDB level the limit is being inherited from the db_limit set at CDB level and throwing an ORA-00059: maximum number of DB_FILES exceeded. My query is if we can able to increase the db_files limit at PDB level ( i.e more than that of CDB level) why it is still taking that from CDB level. Do we need to set any additional parameters at PDB level to get that work

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center