减少oracle 数据文件,怎么减少oracle所占内存？

oracle内存结构介绍：

Introduction to Oracle Memory Structures

Oracle uses memory to store information such as the following:

Program code

Information about a connected session, even if it is not currently active

Information needed during program execution (for example, the current state of a query from which rows are being fetched)

Information that is shared and communicated among Oracle processes (for example, locking information)

Cached data that is also permanently stored on peripheral memory (for example, data blocks and redo log entries)

The basic memory structures associated with Oracle include:

System Global Area (SGA), which is shared by all server and background processes.

Program Global Areas (PGA), which is private to each server and background process; there is one PGA for each process.

官档：http://docs.oracle.com/cd/B19306 ... mory.htm#sthref1228