Oracle

The role and principle of Redo in Oracle: Oracle uses Redo to ensure that database transactions can be replayed, so that data can be restored after a fault occurs. Redo is crucial for Oracle databases. In the database, the Redo function is mainly

Oracle uses Sequence and triggers to automatically increase IDs. Many companies use Oracle databases and require automatic increase of IDs. However, there is no ready-made method to use auto_increatment like SQL Server. Under www.2cto.com, I wrote a

PL/SQL Chinese display is displayed as "?" Problem encountered: Chinese Characters in PLSQL are garbled, and if the SQL statement contains Chinese characters, an error is reported during execution. In fact, the system cannot recognize Chinese

Set the SQL * PLUS startup environment variable to d: \ oracle \ product \ 11.1.0 \ db_1 \ sqlplus \ admin \ glogin. SQL (the path of the above file depends on ORACLE_HOME), you need to find the file according to different versions. Www.2cto.com

In oracle, the v $ session_longops view describes the operations that DBAs often need to monitor databases that take a lot of time, such as backup recovery, collection of statistics, and sorting. This view mainly shows the status of database

Today, due to the working relationship, we need to design a backup solution for ORACLE. Because the database is large, it is not suitableThe daily backup is saved, So we designed the overwriting backup for 7 files every week. The specific steps are

1 create Database type SQL code CREATE or replace type STR_SPLIT as table of varchar2 (50) 2 create function www.2cto.com SQL code CREATE OR REPLACE FUNCTION SPLITSTR (P_STRINGIN VARCHAR2, P_DELIMITER IN VARCHAR2) RETURN STR_SPLIT pipelined is

Oracle default archive log Java code oracle archive log www.2cto.com SQL> archive log list; database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 1503 Next log sequence to

Finding the query statements "V $ SQLAREA" and "V $ SQL" with the worst performance in Oracle databases is a very useful view, you can find the SQL statements that require optimization in the worst execution efficiency. The value in the "DISK_READS"

Empdp/impdp after 10 Gb of ORACLE needs to export the database on the server to the local for testing. One of them has a large amount of data and does not need to be exported. Currently, exp/imp cannot be used to import or export some tables.

Oracel SQL _TRACE excerpt SQL _TRACE is a powerful auxiliary diagnostic tool provided by Oracle for SQL tracking. SQL _TRACE is a very common method in daily database problem diagnosis and solution. Www.2cto.com 1. enable trace SQL> alter system set

The method for updating the current table in the oralce trigger. This article describes two problems: 1. The difference between the update trigger before and the after. 2. After A field in table A is updated, the trigger triggers the execution. In

Oracle creates data based on the business logic of the stored procedure. Yes, the QUERY logic in the stored procedure has results. For example, there is a cursor in the stored procedure. Its QUERY is select xxxxx from a, B, c where yyyyy

Oracle decimal point retention problem if you need to use Oracle decimal point retention problem in actual application, in fact, the method is very simple, we only use round to implement (round (_ data, 2 )), however, if the format is not neat, you

Oracle job and how to stop a running JOB are difficult to start with. Here I will only briefly describe the steps for creating a simple job as follows: www.2cto.com 1. create a table g_test create table G_TEST (id number (12), C_DATE DATE) 2. create

Linux installation of Oracle 10g client (graphical interface) operating system version: redhat-release-5Server-5.4.0.3 www.2cto.com oracle Client Version: 10201_client_linux_x86_64.cpio.gz 1, install the following system package (installation

When you uninstall oracle10g from a cainiao oracle Database Under win7 64bit, an error is reported. today, I installed oracle 10 GB on Windows 7 and found an error during uninstallation. The error is as follows: I installed the 32-bit Oracle10.2.0.1.

Oracle batch processing import/export data errorBatch file 1: exp manualdb/manualdba @ DB01 file = D: \ orabak \ CC_ORDER_BUSINESS.dmp tables = (CC_ORDER_BUSINESS, CC_ORDER_ B _AREA) batch file 2: imp statdb/statdba @ db01 file = D: \ orabak \

Oracle Parameter Interpretation parameters: optimizer_index_cost_adj www.2cto.com 1 and optimizer_index_cost_adj have a great relationship with db_file_multiblock_read_count. We recommend that you search for previous posts. After

Date and Time Range Query (oracle)/* Date and Time Range Query */www.2cto.com ---------- create Date and Time Test table ------------------ create table testdatetime (ID integer not null primary KEY, createdate CHAR (10) NULL, startdate date null,