Oracle

How the procedure is called Declare Realsal Emp.sal%type; Realname varchar (40); Realjob varchar (40); Begin//Stored procedure call start realsal:=1100; Realname:= '; realjob:= ' clerk '; Runbyparmeters (Realsal,realname,realjob); --Must be

Physical Standby and logical standby Log application services are divided into two types, one is the physical standby redo applications, similar to media recovery, its advantage is fast, but 10g case standby must be in the Mount State, Unable to

CRS provides a number of commands to manage and view the status of the Cluster service, commonly used in Crs_stat, Crs_start, Crs_stop, CRSCTL, etc., which are described in turn. 1, view the status of the cluster The Crs_stat command allows you to

1. Definition Package: (1) A collection of related objects that are grouped together, and the package is loaded into memory when any function or stored procedure in the package is invoked. (2) The subroutine access speed of any function or stored

The basic usage of grouping functions is described earlier, and several more advanced uses of group by are described below. 1, rollup in Oracle database with the GROUP BY command, you can provide summary of information functions (similar to

Today found an Oracle test library of the set of incorrect character sets, the original character set is UTF-8, the correct character set should be ZHS16GBK, because UTF-8 is a ZHS16GBK superset, can not modify, can only rebuild the database,

1, the control document function and characteristic 1 Define the current physical state of the database 2 Maintain data consistency: if the checkpoint in the control file is consistent with the data file, the data is consistent and can be started

Control file Diversity: Copying multiple control files and putting them on different disks. 1, the use of SPFile diversified control documents 1) View Control file information and spfile information 05:55:48 sql> select name from V$controlfile;

When we look up the Chinese dictionary, we can quickly find the word we are looking for because the dictionary is indexed. Similarly, in order to get data efficiently, we need to index a column in a table when the volume of data is large. The role

1, the role of statistical information Oracle's CBO optimizer relies heavily on statistics when generating execution plans, you can interpret the CBO as a complex mathematical model, and statistics is its primary input, the execution plan is output,

First, let's talk about what they have in common: they are essentially exclusive locks on resources that are caused by concurrency (if the database has only one session, it's not locked). Then focus on the different points: First of all, their

--New test table Create Tablespace Test DataFile ' E:\APP\ADMINISTRATOR\ORADATA\ORCL\test01. DBF ' Size 500m Autoextend on Next 100m MaxSize Unlimited Extent Management Local Autoallocate Segment Space management auto; CREATE TABLE T1 (

Conn System/manager ----------------------------Create a user, assign quotas, and create a table--------------------- DROP USER test2 CASCADE; Create user test2 identified by Test2; Select Username,password,profile,default_tablespace from

In order to do this experiment I first create a user, user name: 111 Password: 111 Sql> create user identified by 111; User created. Sql> Grant connect to 111; Grant succeeded. Test on the client link $ sqlplus 111/111 Sql> select Sysdate

There is a problem that has been puzzling for a long time, in case of a failure when upgrading CRS. The RAC is a joke that can't be easily opened. This test is done on the Linux platform, and the production library operations need to be cautious. 1

A system that, after a long period of operation, maintenance, and versioning, may produce a large number of indexes, even though the index occupies far more space than the data. Many indexes are useful for systems in the initial design. However,

--View the low-efficiency SQL method as follows Select A.sql_text, A.executions, A.disk_reads, A.buffer_gets, Round ((a.buffer_gets-a.disk_reads)/a.disk_reads,2) Hit_radio, Round (a.disk_reads/a.executions,2) Read_per_run From V$sqlarea A

/* Before creating a tablespace under the server directory/optoracle/oradata/etld, manually build the Etld directory and use root to give the Etld directory the appropriate permissions, such as 777 */ --Create a table space Create Tablespace Tbs_

Test Table name: D 1, to determine whether a table has been analyzed: Select T.num_rows,t.avg_row_len from User_tables t where T.table_name = ' D ', If the result is empty, it means that the table has not been parsed; 2, the table has not been

MySQL: How to transfer millions data from Oracle to MySQLhttp://blog.csdn.net/hwhua1986/article/details/53257427Oracle to MySQL migration steps and a variety of considerationsHttp://www.2cto.com/database/201305/210248.htmlMySQL vs. Oracle diff data