>Can someone please tell me the pro&cons of using one Database and all tables belonging to this Database against spliting the tables to few Databases container?

I usually use one database per application for the application specific tables. I also have one database for the control files tables.

But, if you are in an environment where multiple applications are in production, you will probably find a situation where the same databases may be used by more than one application.