Reducing data store size

Once a data store has been defined with a particular size for the permanent partition (indicated by the PermSize DSN attribute), it cannot be loaded at a smaller size, even if tables or rows are deleted. A copy of the data store made with ttBackup also has the data store’s permanent partition size embedded in it.

To reduce the allocated size of the permanent partition of a data store, save a copy using the ttMigrate utility with the -noRepUpgradeoption. Then recreate the data store with a smaller permanent partition size and restore the data.

Note: The permanent partition size of a data store cannot be reduced below the size that is actually required by the data currently stored in the data store. This value can be determined by querying the perm_in_use_size column of the table sys.monitor.

Perform these steps to reduce the permanent partition size of a data store:

1.Back up the old data store with ttMigrate -c-noRepUpgrade.

2.Create a new DSN definition for the new copy of the data store with a smaller PermSize value.

3.Restore the backup with ttMigrate -r-noRepUpgrade.

Note: If you wish to use the original DSN rather than create a new one in Step 2, then you must first destroy the original data store files using the ttDestroy utility.

Here are the steps to reduce a data store’s allocated size from 400 MB to 100 MB. The data store is in /ds/Sales/Data and has the Data Source Name (DSN) salesdata.

1.ttMigrate -c DSN=salesdata -noRepUpgrade /tmp/salesbackup

2.ttDestroy /ds/Sales/Data

3.Update the DSN salesdata to have a size of 100 MB. See "Changing data store size" in the Oracle TimesTen In-Memory Database Operations Guide.

4.ttMigrate -r "DSN=salesdata;AutoCreate=1" -noRepUpgrade /tmp/salesbackup

100 Oracle TimesTen In-Memory Database Installation Guide

Page 107 Page 109
Page 108
Image 108
Oracle Audio Technologies B31679-01 manual Reducing data store size
Page 107 Page 109

B31679-01 specifications

Oracle Audio Technologies has long been known for its commitment to high-end audio equipment that delivers superb sound quality and innovative design. One standout product from the company is the Oracle B31679-01, a remarkable turntable that showcases their expertise in the audio domain.

The B31679-01 embodies advanced engineering principles and a passion for music reproduction. At the heart of its design is a highly rigid yet lightweight chassis that minimizes vibrations, ensuring that the audio signal remains pure and uncolored. This attention to vibration isolation is critical, as even the slightest interference can compromise the clarity and fidelity of the sound. The turntable is constructed using premium materials that enhance performance and aesthetic appeal, adding an element of sophistication to any audio setup.

One of the key features of the Oracle B31679-01 is its sophisticated suspension system. The innovative suspension technology helps decouple the turntable from external vibrations and resonances, creating a stable platform for vinyl playback. This is particularly important in environments with background noise or potential disturbances, allowing users to experience their music as intended.

Another notable characteristic of the B31679-01 is its precision-engineered tonearm. The tonearm is designed for optimal tracking, ensuring that the stylus maintains contact with the record groove, capturing every nuance of the music. By minimizing tracking error and optimizing weight distribution, the tonearm enhances overall soundstage and detail, allowing audiophiles to rediscover their vinyl collection with newfound appreciation.

In terms of motor technology, the Oracle B31679-01 features a high-torque, low-noise motor that provides reliable and consistent speed. This is crucial for vinyl playback, as variations in speed can lead to pitch inaccuracies and a less enjoyable listening experience. The motor's design is engineered to operate quietly, ensuring that no unwanted noise enters the audio signal.

The Oracle B31679-01 also stands out with its customizable features, allowing users to tailor their experience to their personal taste. From cartridge compatibility to adjustable settings, the turntable accommodates a wide range of preferences, making it a versatile choice for both casual listeners and serious audiophiles.

In summary, the Oracle B31679-01 combines advanced engineering, premium materials, and innovative technologies to create a turntable that excels in sound quality and performance. Its focus on vibration isolation, precise tonearm design, reliable motor operation, and customization options make it a distinguished choice for those seeking an exceptional vinyl experience. Oracle Audio Technologies continues to set high standards in the audio industry, and the B31679-01 is a testament to their dedication and expertise.
Top Page Image Contents