Oracle

Create Public database link Link_mm_devConnect to STL identified by FosssitUsing ' (DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.111) (PORT = 1521)))(Connect_data =(service_name = FOSSDBSB)))‘;--1 Link_mm_dev dblink

This is my third blog ~Today, we mainly talk about the impact of database commit on execution efficiency.Congo: When you write 800W of data, the period of commit and final commit time difference of one hours. Specific is not so I do not research,

After the ORACLE database is started. This statement enables you to see all the parameters used by the Oracle database using the SELECT * from V$parameter . For Oracle 's parameter files, it is divided into spfile binaries and pfile text files.

This article copyright belongs to the distant wind Lyh and the blog garden altogether, welcome reprint, but must retain this paragraph statement, and gives the original text link, thanks cooperation.Since I have been using MySQL for some of the

Tag: Start Lin Lis height port top for optimized address1. After restarting listener, the remote client can not login, only a new start Oralce service can be normal, after analysis, with net Manager to increase the server's IP address

Installing Oracle-database-server-12cr2-preinstallwget http://public-yum.oracle.com/public-yum-ol7.repo-o/etc/yum.repos.d/ Public-yum-ol7.repowget http://public-yum.oracle.com/rpm-gpg-key-oracle-ol7-o/etc/ Pki/rpm-gpg/rpm-gpg-key-oracleYum Clean

1. Open PL/SQL DeveloperIf PL/SQL developer is installed on the machine, open the PL/SQL Developer interfaceEnter the user name, password, and host name, which is exactly the same as configured in Web. config in the program, click OKLocate the

First, install the software package required by Oracle (depending on the Oracle official documentation)can use# yum-y Install binutils* compat-lib* gcc-* glibc-* ksh libgcc-* libstdc++-* libaio-* make-* sysstat*For installation.Ii. creating user

--Jobbegin sys.dbms_scheduler.create_job (job_name = "SSS. P_trms_car_task_job ', Job_type = ' Plsql_block ', job_action = ' BEGIN proc_tt_trms_car_task; END; ', start_date = to_date (' 21

When debugging code encountered such a problem, the program run to the SQL statement to throw invalid character exception, then I had to copy the SQL statement, in Oracle to execute, but there is nothing wrong, this can be difficult for me, so I can

Open instance, database to Nomount state:Startup Nomount;Parameter fileMemory, ProcessSpecifying control filesThe database opens to the Mount State:Alter Datatbase Mount;Control filesWhat data files are included, what log filesBackup-related

--based on SQL query for specific SQL sql_idSELECT * from Dba_hist_sqltext t where t.sql_text like ' INSERT all into tt_deduct_scat_deduct_result% ';--View execution plan based on SQL ID aanqrwv9p5x5sSELECT * FROM table (dbms_xplan.display_cursor ('

Flashback recovering dataPreparatory work:1. Create a table spaceCreate tablespace zxq datafile ' d:\zxq.dbf ' size 2m;2. Create a userCreate user Zxq identified by zxq default Tablespace zxq;3. Create a test tableCREATE TABLE Zxq.zxq as SELECT *

Note: When you write the stored procedure again, begin and end are written in the For loop, so that you can write exception, let the error data roll back, log the error logs, commitKeywords: Oracle stored procedures1. Basic structureCREATE OR

Notice several small details of Oracle database installation at 12c Release 2 Oui, which are recorded as follows:1. In the DBCA Wizard, it is specified by default to create a ORCL CDB database and a orclpdb pluggable database. In the previous

The amount of space (table capacity) of statistical tables/* Generally, the table occupies three parts: Table data, table index, table blob field data */--1 Statistics the space occupied by a single table with (BLOB field)SELECT table_name, SUM

How does Oracle work? Select ID , name from the T order by ID; –sql parsing (see if the syntax is incorrect, if there are no errors, parse the semantics, execute permissions on this statement)– Execution Plan (howORACLE accesses data

return in conditional processing methodpublic static string InsertParameters (ref list orclparameters, int[] lsids, String uniqueparname ){String Strparametros = String. Empty;for (int i = 0; I {Strparametros + = i = = 0? ":" + uniqueparname + I: ",:

Ora-27101:shared Memory Realm does not exist workaround:1. Use cmd to enter the command line2, Sqlplus/nolog3, Conn/as SYSDBA4. StartupFirst, introduce the four categories of SQL92/99 standardDML (Data Manipulation

Wind Brother Linux system Oracle 12CR2 RAC cluster installation and maintenance Management (12.2) topics include:Oracle Database 12CR2 (one of the project combat): Install Oracle12.2 on WindowsOracle Database 12CR2 (Project Combat v): Oracle12.2 RAC