oracle commands

connected users. SHUTDOWN TRANSACTIONAL This option can only be used after Oracle 8i. This command is often used to plan to shut down the database. It completes the execution of active transactions that are currently connected to the system. After running this command, any new connections and transactions are not allowed. After any active transaction is completed, the database will be shut down in the same way as shutdown immediate. SHUTDOWN ABORT Th

Oracle starts listening, views listening, and stops listening commands, and oracle listens Start listening: lsnrctl start View listener: lsnrctl status Stop listening: lsnrctl stop 1. oracle data servers include instance processes and databases; Instance processes include: memory structure (sga), background process (p

Tags: character dev large database information Management DBA needs to run develop fromI. Classification of databases I. Classification of databases1. Small database: Access, Foxbase2. Medium database: Informix, SQL Server, MySQL3. Large database: Sybase, DB2, Oracle Second, how to reasonably use the database in the project, can be based on the following three aspects to start1, the size of the projectA, how much load, that is, the number of usersB,

Oracle environment variable commands and oracle environment variables Oracle environment variable commands Enter the command: ll-all Run vi. bash_profile. #. Bash_profile # Get thealiases and functions If [-f ~ /. Bashrc]; then .~ /. Bashrc Fi # Userspecific environment and

Oracle learning notes 4 SQL commands (2): SQL operation language category, oracle learning notes SQL is classified into the following language categories1. Data Definition Language (DDL)Create, Alter, Drop 2. Data manipulation language (DML)Insert, Select, Delete, Update 3. Transaction Control Language (TCL)Commit, Savepoint, and Rollback 4. Data Control Language

Oracle import and export, oracle Import and Export commands Oracle 10g has introduced the Data Pump (Click Data Dump) technology. What are the advantages of this technology and the previous exp/imp? in simple words, It is very fast to restore and back up; Before explaining how to use the data pump, let's first understa

Oracle learning notes 3 SQL commands, oracle learning notes SQLSQL introduction SQL supports the following types of commands: 1. data Definition Language (DDL) 2. data manipulation language (DML) 3. transaction Control Language (TCL) 4. the Data Control Language (DCL) is a detailed note of the four SQL languages: When

Table Space Basic Commands--Create TABLE space initialization size 10M auto grow 5M max 50MCreate tablespace Duan datafile ' F:\oracle\product\10.2.0\oradata\orcl\duan.dbf ' size 10MAutoextend on next 5M maxsize 50M;--Querying table space for address and space namesSelect File_name,tablespace_name from Dba_data_files order by file_name;--Create a multiple tablespace containing two data filesCreate tablespac

The Oracle database has a connection redo log, which records changes to the database, such as insertion, deletion, and data update. All these operations are recorded in the online redo log. The Oracle database has a connection redo log, which records changes to the database, such as insertion, deletion, and data update. All these operations are recorded in the online redo log. -- Connection recovery Manage

name, restart the machine, and then delete it. 6. Introduction of Oracle Management tools: 1.Oracle of the tool software, mainly for the execution of SQL statements and PL/n blocks; How to use: Sql*plus in the Start menu, or SQLPLUSW in the run bar, or Sql*plus Worksheet in the Start menu; 2.sqlplus DOS operation Oracle Tool, its func

A complete set of common Oracle commands A complete set of common Oracle commands The ORACLE tutorial is a complete set of common Oracle commands. Chapter 1: Log Management 1. forcing

-- Connection recovery ManagerC: \ Documents ents and Settings \ mengzhaoliang> rman target/-- Archive log listRMAN> list archivelog all;-- Delete archive logs that do not exist in the physical fileRMAN> delete expired archivelog all;-- Delete archived logs 7 days agoRMAN> delete archivelog all completed before 'sysdate-7 ';Oracle archiving Mode I. Check whether the oracle database is in archive mode:1. sel

Routine basic maintenance commands for Oracle RAC Status of all instances and services $ Srvctl status database-d orclInstance orcl1 is running on node linux1Instance orcl2 is running on node linux2 Status of a single instance $ Srvctl status instance-d orcl-I orcl2Instance orcl2 is running on node linux2 The status of the global Naming Service in the database $ Srvctl status service-d orcl-s orcltestServi