What's the best approach for handeling about 1300 connections in Oracle.

What's the best approach for handling about 1300 connections in Oracle 9i/10g through a Java application?

1.Using separate schema s for various type users(We can store only relevant data with a particular schema.Then No. of records per table can be reduced by replicating tables but we have to maintain all data with a another schemaThen we need update two schema s for a given session.Because we maintain separate scheama for a one user and another schema for all data and then there may be Updating problems)

OR

2. Using single schema for all users.

Note: All users may access the same tables and there may be lot of records than previous case.

What is the Best case.

Please give Your valuable ideas

[746 byte] By [Suraweeraa] at [2007-11-27 6:49:46]