O'Reilly logo

Managing Multimedia and Unstructured Data in the Oracle Database by Marcelle Kratochvil

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tuning trend

Over the last 20 years, there has been a noticeable trend when it comes to improving database performance. Techniques are developed which sacrifice storage to improve performance. The common index is the first example of this. The index is much smaller in size and can dramatically improve performance of queries. Materialized views are copies of the data stored optimally to improve performance. Locally managed tablespaces reduce fragmentation but can waste storage. A very large UNDO tablespace can enable flash back recovery, saving time when recovering from user errors. Database flashback consumes a large amount of storage and enables faster database rollback capabilities. Recovery performance is improved at the expense of an increase ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required