Oracle Learning-----Management One

The command we met today

IPCs

Show SGA

Select Component,granule_size from V$sga_dynamic_components;

Alter system set shared_pool_size=64m;-->64m can be changed to change the size of the shared pool.

The SGA mainly includes the following:

Shared pool:library cache and data dictionary cache

Database buffer cache:

Redo Log Buffer:

Large pool

Java Pool

Pga

Oracle 9i DBA Fundamentals I (Administration 1 042)

Progress:

No. 01 Lecture

No. 02

This article is from the "You Devil" blog, please be sure to keep this source http://599184429.blog.51cto.com/5147223/1530298