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
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:
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
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
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 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
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
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 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
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
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 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
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
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 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" [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 =
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 (+)
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: 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 _
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