OCM 11g Preparation - Choose the appropriate tablespace type for the intended use

It's interesting to see this topic inside the "Enterprise Manager Grid Control" skillset.

As the topic "Create and manage temporary, permanent, and undo tablespaces", you must know all the options while creating a tablespace, but the keyword here is "for intended use". What does that mean? That not always the classic LMT with ASSM is the best approach.

In this topic, be prepared to read a question with something like "100 concurrent sessions inserting into a table" and give the best performance mode.

Path to Documentation:

Oracle Database Administrator’s Guide -> Managing Tablespaces


Click here to go back to the Main OCM 11g Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!