Management of Oracle databases

--View of database name

Select name from V$database;

650) this.width=650; "src="%5c "alt=" spacer.gif\\ "\" "/>

--View of instance name

Show parameter instance_name;

650) this.width=650; "src="%5c "alt=" spacer.gif\\ "\" "/>

--Data files

Select name from V$datafile;

--Log file

Select name from V$logfile;

--Control files

Select name from V$controlfile;

--Archive file

Select name from V$archived_file;

--Parameter file

Select value from V$parameter where name= ' SPFile '

/*PGA official explanation is the program global area */

--View PGA

Show PGA;

--View SGA

Show SGA;

Oracle 8i with SGA Static management

Oracle 9i dynamic management with SGA

The internal components of the SGA can be dynamically adjusted or automatically managed by the database, and when the memory size is set, the basic unit of memory size is granularity;

Oralce 10i with SGA Automatic management

SGA is not automatically managed except Log_buffer

The other can be automatically managed (db_cache_size,stream_pool_size,shared_pool_size,java_pool_size,large_pool_size);

--java Pond

alter system set JAVA_POOL_SIZE=32M;

Sga_max_size= (80%MEM) *2/3

Uninstallation of/*oracle software */

1.rm/etc/ora*

2.rm/usr/local/bin

--one instance can access only one database

Once the table in the database is locked, the unlock commit transaction is automatically unlocked;

Creation of Oracle Databases

1.create dir

mkdir $ORACLE _base/admin/ulp/{a,b,c,u,dp}dump-p

mkdir $ORACLE _base/oradata/ulp

2.CD $ORACLE _home/dbs

VI Initulp.ora

Orapwd File=orapwulp password=oracle

Export Oracle_sid=ulp

Sqlplus "/as sysdba"

Sql>startup Nomount

Sql>create SPFile from Pfile

3.create Database Ulp

Sql>create Database Ulp

Sql>create tablespace user;

Sql>create temporary tablespace temp;

Sql>alter database default tablespace user;

Sql>alter database default temporary tablespace temp;

4.catalog Catproc Pupbld

Sql>@/u01/oracle/10g/rdbms/admin/catalog.sql

Sql>@/u01/oracle/10g/rdbms/admin/catproc.sql

Sql>conn system/oracle

Sql>@/u01/oracle/10g/rdbms/admin/pupbld.sql

5.restart Database

Sql>shutdown

Sql>startup

6.dbca

Root-->vi/etc/oratab

EMCA--repos Create

EMCA--config Dbcontrol DB

7.oem--

8.net

This article from the "User Churn Statistics" blog, declined reprint!

Management of Oracle databases