Oracle 10g: How to drop Oracle database

Dropping database from sqlplus

1. Shutdown the database

SQL> shutdown immediate;

2. Mount exclusive and put in restricted mode

SQL> startup nomount;

SQL> alter database mount exclusive;

SQL> alter system enable restricted session;

3. Drop database

SQL> drop database;

Oracle 10g: Oracle automatic memory management

In Oracle10g memory can be managed automatically by setting parameter sga_target. Oracle will then manage parameters like: db_cache_size, shared_pool_size, java_pool_size, large_pool_size. You will see new '__' parameters created by Oracle:
__db_cache_size, __shared_pool_size, __java_pool_size, __large_pool_size, these are now dynamically managed.

Check what sga_target is set to:

SQL> sho parameter sga_target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_target                           big integer 1216M

To change sga_target:

$ sqlplus "/ as sysdba"

SQL> alter system set sga_target = 2000M scope = spfile;

System altered.

SQL> shutdown immediate

SQL> startup

To disable Oracle automatic memory management:

SQL> alter system set sga_target = 0 scope = spfile;

System altered.

SQL> shutdown immediate

SQL> startup


Subcategories