11g warning log

11g warning log 1. obtain information about ADR by querying the v $ diag_info view. sys @ ora11g> select * from v $ diag_info; INST_ID name value ------- -------------------- metric 1 Diag Enabled TRUE 1 ADR Base/oracle/u01/app/oracle 1 ADR

High-concurrency response for processing data in Oracle databases

Some systems may have high requirements on the system's response to high data concurrency (for example, the flight ticket booking system). This article uses Oracle's lock table to solve this problem: The key code in Procedure is as follows: ---------

Some practical statements in Oracle Developer 2000

Some practical statements in Oracle Developer 2000: Abort_query; stop query execution Add_group_column (record group id or name, group column Add a column to a Record group, record group id Name, column type, column width ); Add_group_row (record

Oracle transaction autonomy

Add the following statement to the function to indicate transaction autonomy. PRAGMA AUTONOMOUS_TRANSACTION;   Example: SQL codeCreate or replace function func_made_applycode (schoolcode in varchar2, spe_level in integer) return varchar2 isResult

Oracle Stored Procedure for java connection to oracle Database call back list

The following describes how to connect to the oracle database using java to call and return the list of oracle stored procedures for your reference. If you are interested in oracle stored procedures, take a look. Since the oracle stored procedure

Oracle index creation policy

Oracle index problems are often encountered when learning Oracle. Here we will introduce the solutions to Oracle index problems. Oracle indexes and corresponding tables should be in different tablespaces. Oracle can read data on different hard disks

Temporary oracle tablespace

The following are some statements about temporary tablespace learned:-- 1. view temporary tablespace (dba_temp_files view) (v _ $ tempfile view)Select tablespace_name, file_name, bytes/1024/1024 "file_size (M)", autoextensible from

Execution is slow due to unreasonable ORACLE table structure design.

Today, I received a confirmation request from the development team. The following three statements have the same execution plan COST, but the actual execution results differ greatly (1) the query speed is very slow, 2) and 3 ).  1)Select *From

The selectKey of ibatis is used to obtain the id after data is inserted.

The selectKey of ibatis is used to insert data and obtain the id. Some sequence data is used when ibatis is used to insert data into the database. In some cases, after the insertion is complete, you must return the sequence value before proceeding

Add Redo log Member/Group

Add Redo log Member/Group 1. ADD redo log groups a: alter database add logfile ('/oracle/dbs/log1c. rdo ','/oracle/dbs/log2c. rdo ') SIZE 100 M; B: ALTER DATABASE ADD LOGFILE GROUP 10 ('/oracle/dbs/log1c. rdo ','/oracle/dbs/log2c. rdo ') SIZE 100 m

Dynamically set View parameters

The SQL code create or replace package p_view_param is function set_param (num varchar2) return number; function get_param return varchar2; end p_view_param; create or replace package body p_view_param is paramValue varchar2 (4000); function

Concept of oracle lock-1

Concepts of oracle locks-1. Locks 1. The concept of locks: a database is a shared resource used by multiple users. When multiple users concurrently access data, multiple transactions can simultaneously access the same data in the database. If such

Oracle basic query statement

Oracle basic query statement sqlplus sys/Manager as sysdba connects to the database alter user scott account unlock as an administrator; changes the table structure of the user desc emp; (queries information of all employees whose department number

Oracle multi-row merge skills

The oracle multi-row merge technique often combines fields in a column when writing SQL statements. For example, the monthly salary of a person is listed, but each person can only take one row. In such scenarios, you may also use row-column

Use SQL statements to parse the element Geometry Field

Using SQL statements to parse the element Geometry field is used in system applications. To obtain the point value set of the element geometric field, we often used ArcEngine for development and analysis, this article introduces a more convenient

Oracle hot backup and cold backup

Oracle hot backup and cold Backup 1. Introduction to cold backup: the cold backup database backs up all key files after the database is closed, including data files, control files, and online redo log files, copy it to another location. In addition,

"_ Sort_elimination_cost_ratio", one of the CBO Parameters"

"_ Sort_elimination_cost_ratio" [SQL] create table t1 as select * from dba_objects where object_id is not null; alter table t1 add constraint t1_pk primary key (object_id ); create index t1_ind on t1 (object_type); alter session set optimizer_mode =

Use like fuzzy search in ibatis

In ibatis, the like fuzzy query method is invalid: SQL code select * from table1 where name like '% # name # %'  Two Effective Methods: 1. Use $ instead #. This method removes the type check and uses the string connection, but there may be SQL

SQL (+)

SQL (+) SELECT emp_name, dept_name FORM Employee, Department WHERE Employee. emp_deptid (+) = Department. deptid  This SQL statement uses the right connection, that is, the other side of the "(+)" is the connection direction. All records on the

Example of oracle expdp and impdp

Example of oracle expdp and impdp: due to production requirements, you need to copy the rmtel user data to rmtel_xzy, but exclude the rmtel user ('cab _ JJXPORT_TAB ', 't_servicexx', 'tb _ crossconnection', 'tb _ link', 'tb _ card', 'tb _

Total Pages: 2147 1 .... 2087 2088 2089 2090 2091 .... 2147 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.