Backend table usage logic of Custom Objects and high data volume usage

Summary:

Backend table usage logic of Custom Objects and high data volume usage

Content (required):

Hi Team,

According to this post: https://community.oracle.com/customerconnect/discussion/comment/808677#Comment_808677

Which shows while creating Custom Objects, data will store into those 9 backend tables, may I know the logic of which table will be used?

For the Custom Objects created using Application Composer in ERP Cloud, will oracle manage auto-tuning on the db level?

Does Oracle provide any guideline to handle high volume data in Custom Objects (e.g. 10m records)?

Thank you.

Version (include the version you are using, if applicable):