Hot answers tagged oracle
Having been on the receiving end of this multiple times from COTS applications, I would choose multiple databases almost every time. In this case, I would still choose multiple databases over any other, and here is why: !This is for the SQL Server related tag and is not transferrable in logic to other RDBMSs! Standards - each database is setup the same ...
Your question is too broad and opinion based for this forum. There are too many permutations and combinations. Start with the Oracle docco. Don't forget OS metrics - sysstat for Linux or see here for ideas about Windows (you didn't even mention your OS). Are you running an OLTP or an OLAP system? Different answers! Do you have a on-premise or cloud system? ...
can you add more information about the second table (not the one with 10 rows). can you tall a litel more about the Activity on this table, the second one, a.are we talking about table with X rows ? b. How match of DML activity (inser/update/delete) ? c. How many batch request ? 10x itzik paz
Only top voted, non community-wiki answers of a minimum length are eligible