Hello,
I need some guideline or idea regarding database slow or database user management.
Problem : sometimes database is working too much slow
Actually,
I am using Oracle Database 10g R2 on Windows Server 2003, I have installed only one database on server (VM Server)
VM Configuration is :
16 GB RAM
3.2Ghz 8 Core Processor
1TB space
We have developed an ERP for our company and some other applications. All applications are using only 1 database with multiple users so I've created 11 users for different application / modules.
eg. HR, Inventory etc.
We are using Oracle Forms 6i/10g and .Net for user view.
we have atleast 300+ users in our company from multiple cities.
when all users are trying to connect at a time sometimes my database connection are overflow and it'll show TNS errors and sometimes my database goes down(slow).
we have at least 30K daily transactions on HR module, 20K on inventory modules and 10K for other applications.
what would you like to suggest for me ?
01- Install separate database for HR and Inventory? (create database link to connect Inventory and HR)
02- Physical server required ?
03- Enhance VM ware configuration ?
04- Network problem ?
05- Application (ERD) issue ?
06- Other (Your suggestion is required)
Please give my guideline it's urgent.
Thanks