Oracle

Common maintenance commands for Oracle 10g RAC: status of all instances and services [oracle @ vzwc1 ~] $ Srvctl status database-d zwc Instance zwc1 is running on node vzwc1 Instance zwc2 is running on node vzwc2 status of a single Instance [oracle @

Oracle Database SQL --- one of selectPrefaceI have already explained in the previous article that the best learning is practice! Therefore, my learning is based on practice. In all SQLThe most basic statement is the query statement. Therefore, I

Query statement related to oracle tablespace -- merge tablespace size alter tablespace users coalesce -- query data file select file_name, file_id from dba_data_files -- query database object space size select owner, segment_name, sum (bytes) from

SQL single row function in Oracle Database --- to_date to_charDate display formatFirst, let's take an example of the date display format ("19:35:35 ")Year:Yy: show two years show 13Yyy: show three years display 013Yyyy: Display four-digit year

After the Oracle database is created, the System user sys or sysdba cannot log on to sqlplus. The system user sys or sysdba cannot log on to sqlplus to run-> cmd. Enter sqlplus/nolog and press Enter. Enter conn/as sysdba and press Enter. Drop user

Automatic Generation of batch execution of SQL scripts for batch processing scenarios: DBA has exported all the creation scripts for storage, functions, and other objects to me, with thousands of files. now, how do I import these object creation

Oracle Database-Table connection method (hash, merge, nest loop) nested loop is a good choice for a small subset of connected data. The nested loop is used to scan a table. Every time a record is read, it is searched in another table based on the

Oracle OWI wait Event History View and related views the wait event view provided by Oracle allows us to obtain detailed information about the specified session and instance-level wait events. These views are v $ session_wait, respectively, v $

Oracle users01.dbf is getting bigger and bigger. After oracle deletes data, the tablespace is not released, and the dbf file is getting bigger and bigger. You can use: SQL> ALTER DATABASE DATAFILE 'C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \

Sqlldr Load file, ORA-01722: invalid number solve dos2unix file: convert file into unix mode (internal for text) Case: csv file sqlldr. control File load datainto table totofields terminated by ',' (BALL_No, MAIN_BALL_FREQUENCY,

Import and export of a single data table in oracle 10 GB 1. Export tool exp is an executable file in the bin folder under the oracle root directory. The specific directory is/ORACLE_HOME/BIN/exp. This tool can be used to export tables in the

Count the number of tables in the system and query the field information of all tables -- count the number of tables in the system: -- table description field: -- required field: Name, Code, Commente select lower (. TABLE_NAME) | '-' | B. comments,

Greenplum db configuration 1. adjust the kernel Parameter kernel. sysrq = 1fs. file-max = 101365kernel. shmmax = 5001000000kernel. shmall = 4000000000kernel. msgmni = 2048kernel. sem = 250 512000 100 2048kernel. shmmni = 4096net. core.

Oracle backup recovery overview introduces that backup recovery is an important technology of oracle. Of course, we 'd better not use this technology, just as we do not need to go to the hospital. When you open the database, oracle compares the

Postgresql pgbench tool pgbench is a benchmarking tool for PostgreSQL. pgbench is a performance benchmark tool provided by postgresql. You can use pgbench -- help to check the parameter Usage: pgbench [OPTIONS]... [DBNAME] Initialization options:-I

Oracle tune v $ UNDOSTAT a 11g database running on an 18-touch AIX database. During the check, it is found that the data in view V $ UNDOSTAT is very strange, 1st records have never been cut. the start time is 09:52:08 and the end time is 15:20:34.

Dataguard Online redo log and Standby redo log Dataguard classification: Physical Standby (Redo Apply) Logical Standby (SQL Apply) Dataguard protection mode: maximize performance (maximum performance mode) maximize availability (maximum available

[Solution] win7 x64 vs SQL statement connection ora-12154: tns: unable to resolve the specified connection identifier first vomit slot: win7 x64 special, many places are very special, therefore, installing a lot of software is useless. Background:

EXP/IMP data migration recently, all data of a user in a small database needs to be migrated to another one. Now, we first simulate that the data volume is not large, use exp to export all data objects of the User: [SQL] [lubinsu @ localhost orcl] $

All running concurrent requests and current Request status on an EBS Single Instance [SQL] --- summary of all concurrent requests running on an instance and their current status and waiting status select w. seconds_in_wait "Secondswait", w. event