Oracle

RAC Split-Brain resolution voting algorithm learned that Split Brain is a kind of surgery for epilepsy. Doctors believe that epilepsy is caused by the brain's "abnormal discharge. To prevent "abnormal discharge" from spreading to the entire brain

Oracle deletes tables starting with Bin to delete tables starting with Bin, that is, tables that are already DROP but exist in the recycle Bin: --> www.2cto.com query all such tables SQL> SELECT * from recyclebin where type = 'table'; Delete All

In Oracle sorting, the first data entry needs to update the large unit of the set group. The rule is to obtain the unit information of the first student (minimum set ID. Sort by SUITEID to obtain the first method. Www.2cto.com SQL code UPDATE

Pay attention to one issue when calculating the value of a DATE caused by a month or a problem */SQL> www.2cto.com SQL> SELECT date' 2012- 30th day of last month, DATE '2017-11-30 'Today, add_months(DATE '1970-10-30 ', 1) increased by 2012 last

The RAC cache fusion mechanism is introduced in a single instance. to modify a data block, the process must be in the Current copy) the same is true for modifying the RAC environment on www.2cto.com. This involves a series of questions: how to

ORA-03113: end-of-file on communication channel address the loss of an INACTIVE log group simulation on www.2cto.com today, encountering ORA-03113 SQL> select group #, archived, status from v $ log; GROUP # arc status ---------- --- ----------------

Oracle Data Pump import/export Syntax 1. first create a directory: www.2cto.com create directory name as 'a directory on the database server ', such as: create directory alias as 'd: \ Server Directory name'; put the imported or exported files in

Insert into select batch loading error solution when using insert into select to batch load data, the entire insert statement cannot be executed because some data does not meet the loading conditions, all rollback. In this case, you can use the DML

Oracle table delete restores data through the flash back function Step 1: Determine the deletion time point and locate the SCN. Then, we need to follow the SCN to make the table flash back to the state of the SCN point www.2cto.com SQL code select

Detailed description of indexes required for SQL optimization l it is more appropriate to add indexes to columns that are frequently queried. ② there are only a few values in the column data, which is not suitable for indexing. ③ The content changes

Query the number of transactions on the current day in the oracle sales table. create table t4 (id int, je int, time date); www.2cto.com insert into t4 values, to_date ('2017-11-25 15:12:00 ', 'yyyy-mm-dd hh24: mi: ss'); select id, je, to_char (time,

ORACLE Database Data File Location migration 1. there are two ways to move a data file www.2cto.com to move a data file: 1. Move SQL> select name from v $ datafile; ------ 2. shut down Database SQL> shutdown immediate Database closed. database

Uninstalling an Oracle database is not as simple as deleting other software. Especially for new employees, when the database is deleted and re-installed, it is often re-installed, some inexplicable errors will be reported, or the installation will

Exp + parfile export the qualified record exp parfile = d:/test. par file = d:/back. dmp filesize = 2000 M log = d :/**. the purpose of logfilesize is to prevent some operating systems from supporting files larger than 2 GB, and the I/O performance

PL/SQL PLS_INTEGER type provides some performance. If PLS_INTEGER is used, oracle uses the native machine algorithm. All other numeric data types are the same as the NUMBER data type. The result of using the C Language Algorithm Library is that the

Use spool tool to export oracle Text data 1. win next batch processing scheduling file data_spool.bat [SQL] F: \ oracle \ product \ 10.2.0 \ db_1 \ BIN \ sqlplus tax/tax @ orcl @ D: \ PDM_ SQL \ spool \ spool_ctl.spl> D: \ PDM_ SQL \ spool \

Oracle Database notes-oracleweb view usage process, and plsql installation 1. a. Enter the following when you first enter: http://127.0.0.1:1158/em/ Oracle Enterprise Manager: This is the title of the webpage. Enter the system account and password:

Modify the password of an oracle user and unlock the user in sqlplus. 1. log on to the oracle user and connect to the database www.2cto.com [oracle @ wuzj ~]. $ Sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Thu Feb 26 12:06:29 2009

Oracle block cleanout in short, there is a mark of active transactions on the oracle block. If a transaction commit, because some blocks have been written back to datafile before commit, or if the number of Blocks Affected by the transaction is too

Install oracle + asm in windows to open my computer, right-click the attribute and open diskpartLisk diskSelect disk 1 www.2cto.com in cmd to partition disk 1, split into four Create partition primary 1024 check whether the partition is correctly