Database Administrator

I had trouble with my Oracle stored procedures for more than a month. Due to different versions, I spent a whole day today and finally solved them later in the afternoon, this problem accounts for 10% of the performance appraisal this month. It is

1. Preparations for configuration in Linux Environment: Linux: RedHat Enterprise 5.4, DB: Oracle 11g R2 X64, Oracle installed in the/home/oralce_11 directory. The configuration process is as follows: (most of the content is online, and individuals

Do you still remember the concept of saving points in SQL? In a transaction, you can create a save point, make some modifications, create another save point, and so on. If these changes are not what you want, all you need to do is roll them back to

When using MySQL, garbled characters are often caused by inconsistent encoding. The following information about MySQL Data Encoding is provided, which may be helpful. I. MySQL encoding mechanism: 1. Database-level encoding: databases with different

Main Environment:JBOSS 5.1.0 Orace 10G Gatein3.1.0-GA Refer to the original article in the movie in official user manual and briefly translate and annotate it:2.1. Database Configuration2.1.1. OverviewDependencies in 3.1 has two different database

An error is reported when the software installation Progress reaches 87%. Error in invoking target 'client _ sharedlib 'of makefile '/U01/app/Oracle/product/10.2.0 /Db/network/lib/ins_net_client.mk '.

The following is the official Oracle Database, which is listed here. We hope to reduce the search time. Download it now ~ Oracle Database 11g Release 1 (11.1.0.6.0) Standard Edition, Standard Edition One, and Enterprise Edition

Oracle audit can be used to query the operations performed by a user on the database. After 10 Gb, it can be used to query specific SQL statements. The entire process of opening an account with the audit function: 1. show parameter audit. You can

A key improvement of FORALL statements, which greatly simplifies code and significantly improves performance for programs that want to update many rows of data in PL/SQL programs.1:Use FORALL to enhance DML processing capabilitiesOracle introduces

Business Process Model (BPM) is mainly used in the demand analysis stage. It describes Business logic and rules in detail from the perspective of Business personnel, the process, process, message, and collaboration protocols between one or more

1. Detailed description of export tool parameters [Oracle @ linux exp] $ exp help = y Export: Release 10.2.0.4.0-ProductionOnWednesday, September 16, October 5 15:08:57, 2011 Copyright (c) 1982,200 7, Oracle.AllRights reserved. Enter

Refer to Oracle official installation documentation: http://www.oracle.com/technology/global/cn/pub/articles/smiley_10gdb_install.html 1> Installation preparation 1.1> download oracle Installation program on the oracle official website download

I am used to the alter statements of Oracle and cannot use these statements in db2. The example table is as follows: Create table emp (id int, name char (20), salary decimal (); -- create table emp The alter statement usage of db2 is as follows: (1)

Some time ago, because of a project, MYSql Data Synchronization Service was required. However, because the website space service provider does not provide remote connection to MYSql, therefore, the NaviCat client cannot be used to connect to the

1. Search for user tables SelectTable_name, num_rowsFromAll_tablesWhereOWNER ='Tiger' ANDTABLE_NAMELike '% Master' Order ByNum_rowsDesc 2. Search user table fields Select*FromUser_tab_columns WhereDATA_TYPE ='Char' AndDATA_LENGTH = 119

How Does Oracle search for fields containing a certain value in all tables of the current user? Create or replace procedure MY_Pro_SearchKeyWord isV_ SQL VARCHAR2 (4000 );V_tb_column VARCHAR2 (4000 );V_cnt NUMBER (18, 0 );Cursor cur is SELECT

DBAs often hear that archiving logs and master databases are not synchronized because of inadequate monitoring of mongouard. what's even worse is that the master database usually has RMAN backup, Archive logs are usually deleted after full-database

1. the maximum number of lists IN the IN clause is 1000. If this number is exceeded, an error is returned. You can use a temporary table to solve this problem; 2. * The character length of the create trigger statement text cannot exceed 32 KB (the

The distributed document storage database MongoDB is so popular now. In response to the requirements of cloud computing last year, I tried it a little. However, at the time of the test, version 1.8.1 was now available in version 2.4, but NoSQL was

CRS cannot be started. Running crsctl start crs has no response View messages:[Root @ UNID02 ~] # Tail-f/var/log/messagesDec 9 08:11:13 UNID02 logger: Cluster Ready Services waiting on dependencies. Diagnostics in/tmp/crsctl.7259.Dec 9 08:12:13 UNID0