Online Mind Mapping and Brainstorming

Create your own awesome maps

Online Mind Mapping and Brainstorming

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account? Log In

ORACLE UTILITIES by Mind Map: ORACLE UTILITIES
0.0 stars - 0 reviews range from 0 to 5

ORACLE UTILITIES

Data Pump

Export

Import

based on

Data Pump API

DBMS_DATAPUMP

Metadata API

Retrieve an object's metadata as XML

Transform the XML in a variety of ways, including transforming it into SQL DDL

Submit the XML to re-create the object extracted by the retrieval

to use

SQL*Loader

loads data

External Tables

complement

LogMiner

query

Performance tuning and capacity planning through trend analysis

You can determine which tables get the most updates and inserts. That information provides a historical perspective on disk access statistics, which can be used for tuning purposes.

Performing post-auditing

The redo log files contain all the information necessary to track any DML and DDL statements run on the database, the order in which they were run, and who executed them

DBVERIFY Utility

external command-line utility

perform

only for use

not work

DBNEWID Utility

change