Oracle database common operation

xiaoxiao2021-03-06  105

[Original] Oracle Database Usage

Author: Huang Lin --ZDNet readerThursday, August 19 2004 1:58 PM

For DBA, familiar with the common operation methods of Oracle have a very important role in which few aspects are listed below:

I. Several closing methods of Oracle Database

For Oracle, there are three ways to close:

Enter the following statement under SVRMGRL, you can turn off the database, but each statement has its own role, some statements must also be used with caution

1. Shutdown Normal (from the literally understand this is a normal way to turn off the database.)

2, shutdown immediate (turn off the database immediately.)

When Shutdown Immediate, the database does not turn off immediately, but it is only turned off after Oracle's necessary work, Shutdown Immediate can complete the shutdown that cannot be turned off on the database. It is recommended that DBA usually use this method to close the database.

3, Shutdown Abort (directly to close the database)

This stop method is not recommended because the session that is being accessed is suddenly terminated, may cause data loss of the database, and if there is a lot of operation in the database is being executed, then after executing Shutdown Abort, restart the database needs a long time. time.

for example:

1, stop Oracle

# su - oracle

$ LSNRCTL STOP

$ SVRMGRL

> Connectinternal

> shutdown immediate

> EXIT

The corresponding method of starting Oracle is as follows:

# SU - Oracle enters the Oracle user

$ SVRMGRL Opens Oracle Manager

> Connectinternal build library connection

> Startup boot database

> EXIT Exit Manager

$ LSNRCTL Start Launched

$ LSNRCTL status View the status of the listener

Second, some related commands and methods for Oracle 8i database server operations:

1. SAR This command can help see which buffer cache usage, let us decide which needs to increase, which needs to be reduced:

SAR -B: We can use it to see the cache cache activity;

SAR-W: We can use it to view memory exchange activities;

SAR -U: We can use it to view CPU utilization;

SAR -R: We can use it to view memory utilization;

SAR -P: Report Solaris Memory Paging Event, this command is: a part of the VMSTAT command,

For example, the following command is used to display 10 paging activities every 5 seconds: $ SAR -P 5 10

% Vmstat 5

This command will display the outline of the system every 5 seconds, including the activity of the process, virtual memory, disk, pagination, and CPU.

2, iostat, monitor disk activity

3, SWAP, monitor exchange space

Responsible Editor: Li Ning

Welcome comments or contributions

转载请注明原文地址:https://www.9cbs.com/read-125004.html

New Post(0)