sqlplus list all databases

The DML, DDL, and DCL statements we usually call are SQL * plus statements. After they are executed, they can be stored in a memory area called SQL buffer, in addition, only one SQL statement can be saved recently. We can modify the SQL statement

Databases in the production environment cannot directly use development tools (such as toad and PL/SQL developer) to connect and perform data operations, because they have strict permission control (for DB security considerations ), the only tool

1. IntroductionThere are many backup methods for Oracle databases, regardless of the backup method used, to restore the system at the lowest possible time and cost in the event of a failure. For example, exporting database objects using the Export

  Preface This article describes DBA's daily responsibilities in monitoring Oracle databases and how to use shell scripts to perform repeated monitoring. This article first reviews some common DBA Unix Commands and explains how to regularly execute

The path to installing and detaching Oracle databases: The Path to oracle databases ========================================================== ============================================== ====================================== 1. If there are two

The management framework includes: database instance, listener, Management Interface (databasecontrol, management proxy, used by Gridcontrol) Management databasecontrol ( The management framework includes: database instance, listener, and Management

The management framework includes: database instance, listener, and Management Interface (database control, management proxy, which is used by Grid control)Manage database control (Oracle provides a Database control console for databases that are

 This article describes eight common shell scripts for monitoring data. First, I reviewed some common DBA Unix Commands and explained how to regularly execute DBA scripts through UNIX cron. There are also a lot of similar articles on the Internet,

In the first two articles, we described the backup and recovery solutions for Small and Medium databases using RMAN catalog, all related scripts are provided to simulate Oracle Data guard to a certain extent in a car to reduce database losses on the

1. Introduction There are many ways to backup Oracle databases, regardless of which backup method is used, and the purpose of the backup is to recover the system as little time and cost as possible after a failure. For example, using the Export