Managing Database Objects
Managing database objects in an Oracle RAC environment is similar to managing them in a single-instance environment. In this section, we point out particular items to which you should pay special attention in the Oracle RAC environment.
Managing Tablespaces
To alleviate any concern for contention in an Oracle RAC environment, you should use all tablespaces with Automatic Segment Space Management (ASSM). ASSM was introduced in Oracle 9i and eliminates the need to define freelists, freelist groups, and so on, in an Oracle RAC environment.
Use the following SQL command to verify whether all your tablespaces are using ASSM:
By default, the “create tablespace” command creates a tablespace with ASSM. All you need to do is ...
Get Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
