Database Administrator

-- The location where exceptions and exceptions are captured in Oracle can be used to debug stored procedures, especially for a long time.DECLAREV_RATE NUMBER; -- RatioV_RETINFO VARCHAR2 (2000); -- exception informationBEGINSELECT 120/0 INTO V_RATE

Set on the click node or Local Machine 1 SQL> archive log list; # Check whether archive mode is used 2 SQL> alter system set log_archive_start = true scope = spfile; # enable automatic archiving SQL> alter system set log_archive_dest_1 = 'location =

Method 1: offline tablespace 1. offline tablespace: alter tablespace tablespace_name offline;2. copy the data file to the new directory;3. rename: Modify the tablespace and control file;4. online tablespace; 1. offline tablespace zerone SQL> select

OS: aix5DB: 9.2.0.8The customer needs to restore the production database to the development and testing environment through RMAN, restore data files, control files and related archive files through RMAN, and then start to recover the database, the

SQL> select * from v $ log;   GROUP # THREAD # SEQUENCE # bytes members arc status FIRST_CHANGE # FIRST_TIM ------------------------------------------------------------------------------------------- 1 1 2 52428800 1 yes active 464602 07-SEP-12 2 1 3

A single-instance database generally has the database name db_name, Instance name: instance_name: Service name: service_names. Generally, the three names are consistent. There are some differences in the RAC cluster. In terms of planning, we will

Basic Application of a function 1. Create a function (in the SQL window) Create or replace function get_hello_msgReturn varchar2BeginReturn 'Hello world ';End get_hello_msg; The function must have a return value. The return value of this function is

Usually, data storage needs to specify the case sensitivity of string fields. MySQL Default queries are not case sensitive. However, as user information, once the user name is repeated, it will waste a lot of resources. In addition, it is difficult

My newly installed Linux Mint 13 "Maya" Xfce RC, but because it is based on XUbuntu 12.04, it should be applicable to both XUbuntu and Ubuntu 12.04 1. Click here to download the installation media for Oracle express Oracle Database Express Edition 11

1. receive service requests A customer's dual-node RAC is not synchronized at two nodes. Ii. problem diagnosis 1. Check service status: Command crs_stat-t 2. Check time: the date node is two minutes faster than the second time of the node. 3. Check

I: Row_number () over (partition by col1 order by col2) indicates grouping by col1 and sorting by col2 within the group, the value calculated by this function indicates the sequential number after each group is sorted (the continuous and unique in

You can CREATE synonyms in your own mode. This requires the create synonym system permission. If you want to CREATE a SYNONYM in another user's mode, you must have the create any synonym system permission. Synonyms created by common users are

I have been optimizing the SQL statements of various products recently, and I am also helping a colleague solve the deadlock problem. What I learned is that I have a deeper understanding of InnoDB locking. Let's take a look at this case today:

This article describes how to use SQL profile to bind the correct execution plan. 10gR2 is quite practical. Of course, baseline can be used for 11 GB, Of course, I think both of them are quite good. We may often encounter some big tables, such as

The crs_register command registers resources to CRS. This method usually combines crs_stat-p or crs_profile to create a configuration file first. Crs_register also provides the CRS update function. This article describes the usage of crs_register

Oracle table management-how to create a table-------------------------------------------------------Create a tableStudent tableSQL> create table student (Xh number (4), -- Student IDXm varchar2 (20), --- nameSex char (2), --- genderBirthday date, ---

(I) three major functions ① Collect and delete index, table, and cluster statistics ② Verify the structure of tables, indexes, and clusters ③ Identification table and cluster and row migration and row Link For analyze's function of collecting and

MySQL backup category. For more information, see the previous article on MySQL backup category. Cold backup: The cold backup of the InnoDB Storage engine is very simple. You only need to back up frm files, shared tablespace files, independent

Step 1: Try to delete sqlplus using the SQL command. If the deletion is successful, everything is fine! However, if you want to delete a session with a deadlock through a command line or using an Oracle management tool, oracle will only mark the

(Translated from python v2.7 document) Sqlite is a C language library that provides a lightweight file database solution. She does not need server support and supports non-standard SQL statements. Sqlite has been integrated into the python Standard