An example

You can allocate different disk partitions to different stable queues. You could, for example, make partitions of different sizes available to different database connections. In this example, we add partitions of 10MB and 20MB to the Replication Server and specify allocation hints for the TOKYO_DS and SEATTLE_DS data servers. The procedure is:

1. Make the partitions P1 and P2 on the device named /dev/rds0a available to Replication Server, enter:

   create partition P1 on '/dev/rds0a' with size 20
   

   create partition P2 on '/dev/rds0a' with size 10
   

2. Suspend the connection to the TOKYO_DS and SEATTLE_DS data servers, enter:

   suspend connection to TOKYO_DS
   

   suspend connection to SEATTLE_DS
   

3. Specify allocation hints for the connection to the TOKYO_DS and SEATTLE_DS data servers, enter:

   alter connection to TOKYO_DS.db1
   set disk_affinity to 'P1'
   

   alter connection to SEATTLE_DS.db5
   set disk_affinity to 'P2'
   

4. Resume the connections to the TOKYO_DS and SEATTLE_DS data servers, enter:

   resume connection to TOKYO_DS
   

   resume connection to SEATTLE_DS