Creating instances or just tablespaces in Oracle ?

Question

I'm new to oracle, but our admin ask us, if i want to create new database for new apps create new instance instead of new tablespace. What is the differences

Answer 1

A collection of tables and other objects that support an application is called a schema.

A database is a collection of system and schema data stored in files. The files are organized into tablespaces for ease of reference.

An instance is the collection of processes that open the database and provide services to other programs and users by communicating with user sessions.



- If you select a tablespace of an existing database for your application, you need to know what other applications are using that database instance. Your performance will depend on how much resources of that database are already tied up by the other application schemas and sessions. Your application will also have to shut down when those other applications need downtime for maintenance. When the other users of that database upgrade to another version of oracle, you will have to upgrade with them.

- If you select another database, the server that your database will run on needs to have enough resources to support two SGA memory structures. You would be able to have that database tuned specifically for your database and to keep it running when the other database is down. However, if the server is not large enough for two databases, your performance will suffer.

Answer 2

Choose tablespace - cause of performance

For good explanation check the second link

Answer 3

how to link all my works to oracle database ?