Oracle

First, understand under what circumstances Oracle will produce ORA-01555 errors: Suppose there is a table1 table with 60 million rows of data, assuming that the full table Scan 1 times takes 2 hours, from the process: 1. At 1 o'clock, User a

By default, if you type data that violates a constraint rule when you perform a DML operation, the error message is immediately prompted. In some cases, you might want to check for constraints at the end of a transaction, such as cascading updates

1, modify the user (1) Modify password 09:57:30 sql> alter user tiany identified by Tianya; User altered. (2) Modify table space quotas Table space quotas are used to limit the maximum space that a user object can occupy on a table space. 09:59

First look at when to use dynamic performance view: (1) Nomount When you start the routine, Oracle opens the parameter file, assigns the SGA, and starts the background process. Therefore, when the routine is in the Nomount state, only access to

One, sum and seek average 1. What is a group function The group function is the multiline function that we talked about earlier. It operates primarily on tables. Because there are only a few rows of data in the table. Let's take the two group

A brief introduction of conditionsUnderstand the general form of conditionsThe most common condition is the following form: Gyj@ocm> Select * from t1 where name= ' gyj2 '; ID NAME SALARY---------- ---------- ----------2 Gyj2 8000Criteria can be

In Oracle/plsql, the SUBSTR functions allows you to extract a substring a string. The syntax for the SUBSTR function is: substr (String, start_position, [length]) Description The string is the source string. Start_position is the position for

1. Status of all instances and services $ srvctl Status database-d ORCL Instance ORCL1 is running on node linux1 Instance Orcl2 is running on node linux2 2, the status of a single instance $ srvctl Status instance-d orcl-i Orcl2 Instance Orcl2

The data de-duplication technology can provide more backup capacity, achieve longer data retention, maintain continuous verification of backup data, improve the level of data recovery service, and facilitate data disaster tolerance. Duplicate data

Next, we will parse the parsing function syntax format (syntax format diagram refer to: http://blog.csdn.net/yidian815/article/details/12709223). Function name When it comes to it people, it's a simple thing, not a description. Function arguments:

Recently, read some of the data on the hash join, the summary is summarized as follows, in case of forgetting. A HASH join is a table join method that Oracle introduced in version 7.3 to complement the nested LOOP and the sort merge. A HASH join

1, set up concurrent to perform Rman backup 1) Manual Configuration run{ Allocate channel C1 type disk; Allocate channel C2 type disk; Allocate channel C3 type disk; Backup database format ' C:\rman\d_%U_%p.bak ' tag= ' Xifenfei '; } 2)

If we now use a SELECT statement to query data from a database, how does the Oracle database work? What can we learn from it? Below, combine a simple SELECT statement to see the operating mechanism of Oracle database backstage. This is very helpful

In Oracle sequence is called the serial number, each time it will automatically increase, generally used in the need to order by serial number of places. 1, Create Sequence You must first have create sequence or create any sequence permissions,

1 Introduction Oracle database, as a large relational database with high reliability, high security and high compatibility, has been widely used in the fields of finance, communication, medical care, manufacturing and so on, and has gradually

In the process of using Oracle, we will often encounter some Oracle errors, this article analyzes the use of the more frequent error code one by one, hoping to help you find a reasonable way to solve these errors, but also hope you can put forward

A Database is composed of one or more logical storage units called tablespace (tablespace). The logical storage units in the Tablespace are segments (segment), and segments can continue to be partitioned into data extensions (extent). The data

RAC is a cluster of Oracle companies, and there are many articles on the web that introduce the RAC configuration. But holding these wonderful documents doesn't necessarily make the RAC configuration successful. Because RAC is a very complex

Partitioning pruning Partitioning pruning means that for partitioned tables or partitioned indexes, the optimizer can automatically extract the partitions that need to be scanned from the from and where words according to the partitioning key, thus

The following is the process of adding a new hard disk to the virtual machine and creating an LVM bare device to use with Oracle, and we learn together, there is not the right place to guide, thank you. Linux system is AS4 update 7 Before the