Oracle

Oracle rman nocatalog and catalog 1. Check whether archive mode is Enabled [oracle @ test ~] $ Sqlplus/as sysdbaSQL * Plus: Release 10.2.0.1.0-Production on Wednesday April 17 03:15:57 2013 Copyright (c) 1982,200 5, Oracle. all rights reserved.

The push_pred application of hints optimized an SQL statement in the project. At that time, it was reduced from more than 40 seconds to 2 seconds. I felt very fulfilled. Now I 've looked at it again, I think there is still room for optimization. The

Oracle stored procedures and questions 1. the overall structure of the create or replace procedure stored PROCEDURE name (parameter 1 in number, parameter 2 in number) IS variable 1 INTEGER: = 0; variable 2 DATE; BEGINEND stored PROCEDURE name 2.

Greenplum management mode is the same as oracle schema. It is used to logically organize the storage containers of database objects. Different schemas do not share namespaces. Schema public is created by default after the database is created. each

Oracle like '%... %' optimized 1. Try not to use like '%' 2. For like '%' (not starting with %), Oracle can apply index3 on colunm. For like '%... '(Not ending with %), you can change it to like' % '4 in the form of reverse + function index. if you

Oracle daily check script [plain] #! /Bin/bash sqlplus-s/as sysdba Spool/tmp/oraclecheck/dbcheck. log set echo off whenever sqlerror continue; set lines 500 set pages 500 prompt ################################# ########### prompt Database

Oracle scheduled task failure solution found that the system data was not updated. Check that the oracle scheduled task was not executed. The next_date is changed to 4000/1/1, and the broken is selected. Select * from user_jobs: the number of failed

[Oracle] the quick way to DELETE duplicate data is that you have never seen this method on the Internet: delete from prod_grid_incWHERE rowid in (SELECT B. row_id2 FROM (select rowid row_id2,. *, row_number () over (partition by. prod_id order by.

Oracle 11g ora-00979 bug processing migrate oracle 10g Report library to oracle 11g existing Stored Procedure compilation times ora-00979 error, determined to be group by followed by the cursor cannot be used, later I found a bug of 11g with metlink

The three major advantages of Oracle performance adjustment are ASH, AWR, and addm ash (Active Session History). Based on the V $ SESSION, the ASH sample is performed once per second to record the event waiting for the Active Session. Non-active

[Oracle] the Flashback flash back mechanism Flashback is intended to be difficult if you have misperformed data and submitted the data before it has been Flashback. Some people may say that the backup can be used to restore the system to a previous

Oracle trunc does not perform function processing on the time field, which is very slow and Low-each time a record is extracted, a function must be performed on the time field to determine whether select count (1) is appropriate) FROM

In the Oracle Crash case, I received a call report saying that an Oracle database was inexplicably crash when I got off work. Let me go to the site to see it. At the scene, the on-site maintenance personnel said that the database was automatically

GoldenGate System 2: quick setup of a third-party one-way communication GoldenGate environment 1. Environment preparation (1) download the installation package and decompress it to ORACLE_BASE (2) modify the environment change [oracle @ irms156ogg] $

Oracle pl/SQL programming simple data type definition operation begin dbms_output.put_line ('Hello World'); // dbms_output = system. out put_line = println end;/set serveroutput on; set to print the output to the command line. By default, v_name

Oracle analysis functions 1. automatic summary functions rollup, cube, 2. rank function, rank, dense_rank, row_number 3. lag, lead function 4. increase the moving of sum, avg, and 5. ratio_to_report processing function 6. first, last base-based

[Oracle] Local VS Global partition index in Oracle, the index and table can also be partitioned. There are two types of partition indexes: Local and Global ). 1. The Local index is created using the LOCAL keyword. The partition boundary is the same

Comparison and analysis of historical SQL statement execution plans in Oracle Based on the CBO optimizer environment, the generation of SQL Execution plans relies on the authenticity and integrity of statistical information. Such as column

Some common operations of sequence in Oracle sequence are so-called serial numbers in oracle. It will automatically increase each time it is obtained, and is generally used in places where it needs to be sorted by serial number. Create Sequence you

Oracle odbc ConfigurationIf oracle odbc is installed in Windows 64-bit, you cannot use "Administrative Tools"> "Data Source (OBDC)" in the control panel to install the data source.In "run", enter C: \ Windows \ SysWOW64 \ odbcad32.exe to install the