Oracle

Why System/undo/temp is MMSM management? Advantages and disadvantages of ASSM and MSSM. ASSM: Advantages that can support large concurrent inserts : Disadvantage, the index of the clustering factor will be very poor-you can use the Reverse key

1.1.1. RMAN-08138 Date: 2014-05-21 14:36 Environment: Test environment "Story description" On the tester, when you use Rman to delete the archive log file, you are prompted to warning the warning and the archive log cannot be deleted. "Error

If you change the NIC before and after the network card name, IP, gateway, subnet mask will not change, the cluster level is not allowed to do additional operations! To use the new NIC name after replacing the NIC 1, to ensure that all cluster

1. Oracle Clusterware supports up to nodes in a cluster on configurations running Oracle Database 10grelease 2 (10.2) A nd later releases. After the 10.2 version began Oracle's cluster supports clusters of up to 100g nodes. 2. Network

[Oracle@ggos ~]$ Rman Target/ Recovery manager:release 11.2.0.4.0-production on Fri Dec 6 00:17:59 2013 Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved. Connected to target Database:oraprod (dbid=9124528) Rman> Show All;

Recently because of the upgrade of Mac OS X 10.10 Yosemite, suddenly a few days ago one night, the boot found on the boot interface, it seems that beta is not reliable, and then think of their own this day just backed up a few days ago, nothing,

SELECT * FROM ( select A.id,a.oacode,a.custid,a.custname,a.xsz,a.salename,a.communicationtheme, A.communicationproperty,a.communicationtime,a.productmanager,a.creator,a.createdate from Technology_flow a where a.oastate= ' normal end ' Union

Oracle Server Automatic Backup1.$sqlplus/nolog$conn sys/as sysdbasql> Create directory Expdata as '/home/oracle/oraclebak ';D irectory created.  Sql> Grant Read,write on the directory expdata to public; Sql> exit2.$mkdir/home/oracle/oraclebak3.

I. Oracle's physical structure (file structure) there are three types of files in Oracle: Control files, data files, log files, and log files into two categories: online log files, Archived log files There is also a parameter file: The parameter

Plsql Developer 11.0.0.1762 Chinese Green Registration version (free oracle11g client) free of installation of Oracle client, green pollution-free. Note: 1, click "Start PLSQL.exe" can be installed without Oracle use PLSQL or use Qidong.bat boot, 2,

1.1 Stored proceduresA stored procedure is a named PL/SQL program block that can have parameters and can have several input and output parameters. You can even have multiple arguments that do input and output, but none of them return a value. The

Today I attended the OCP training to listen to the teacher told a little skill about Oracle, the feeling is very useful to record.This in the official website of the document also has everyone interested in also can go to see, official website

Lowering the water level lineAs the database table space is used for a long time, the amount of data continues to increase, and periodically delete some unimportant data informationOf course, the data can be deleted using the DELETE statement, but

Organize some sql&plsql statements as AliasSelect X as Y from ...//use Y to display the X column nameDISTINCT to remove duplicate rowsSelect DISTINCT x from ...//table to filter x rows of data that are not duplicated in range filteringSelect X from

1. Nested loop coupling (NESTED LOOPS)2, Hash junction (hash join)3. Sorting merge joins (merge JOIN)4, Semi-junction (In/exists)5. Anti-coupling (not in/not exists)6. Descartes Junction (MERGE JOIN Cartesian)7, connecting the outer connectionLeft

SQL language is a high-level structured query language, which greatly reduces the burden on users. Currently the query language is divided into four types, data definition language (DDL), Data Manipulation language (DML),Transaction Control Language

Should have written yesterday, forget today, probably account for a moment.1, first of the next database, I was a colleague to the 11g, decompression is two unpacking, together extract to a folder, and then follow the steps to go down, the password

--Create users and groupsUser Oracle (attached to Oinstall and DBA Group)Group Oinstall DBA--Create the installation directory and set permissionsMkdir-p/u01/app/oracleChown-r oracle:oinstall/u01Chmod-r 775/u01--Modify the system kernel

Create Table usertable ( intprimarykey, varchar( not NULL , birthday date, char(1), varchar( ));Create TableOrders (IDint Primary Key, user_id int not NULL, Numberidvarchar( +) not NULL, Createtime date,

Query and delete duplicate records of SQL statement 1, find redundant records in the table, duplicate records are based on a single field (ID) to determineSelect * from where inch (Selectfromgrouphavecount>1)2, delete redundant records in the table,