I have several application which currently running on my local. I have installed oracle 11g and create a global database name as oracle11. Now should i create again different database for each application using Database configuration assistance or should i create different users for each application under that global database? What would be the best practice? If i create different users its also behave same as creating different databases right?
What if in a production environment where server house for couple of application? Do i need to do the same as my local by creating one database and different users for each application?