Database Administrator

NLS_LANG format: NLS_LANG = LANGUAGE_TERRITORY.Client CHARACTERSET 1. Composition of the NLS_LANG Parameter The NLS_LANG parameter consists of the following parts: NLS_LANG = _. The meanings of NLS_LANG are as follows: LANGUAGE: Oracle

Features of automatic PL/SQL running in Oracle: Run the automatic scheduling task in the UNIXDE corn Utility You can use the DBMS_JOB package in PL/SQL in ORACLE to schedule PL/SQL statement blocks so that they can run automatically at the specified

1. Install the compiling environment Uname- Linux ha01 2.6.18-194. el5 #1 SMP Fri Apr 2 14:58:35 EDT 2010 i686 i686 i386 GNU/Linux Yum-y install gcc Yum install-y gcc-c ++ 2. mysql compilation and Installation [Root @ ha01 local] # tar-xvf mysql-5.1.

And, or, not: 1. a and B (sequential execution) (1) true if a and B are the same as true, (2) a, B, and false are false, [1] If expression a is false, there is no need to judge later. The entire expression must be false; [2] if a is true, the

Use show sgaYesCheck the size of SGA.,The results of show sga are in the following format: Total System Global Area AAAAA bytes Fixed Size BBBBB bytes Variable Size CCCCC bytes Database Buffers DDDDD bytes Redo Buffers EEEEE bytes ThisProvide a

In MySQL, a table is created manually by using commands. When a Chinese record is added to the page, an incorrect string value similar to the following is thrown: '\ xBB \ xF0 \ xD0 \ xC7' for column 1 row.... The reason is that the string encoding

To better understand the differences between the 10gR2 RAC and the latest version, we will continue to build a 10gR2 RAC on the platform with the Environment configured in 11gR2. Before installation, you must modify a Kernel Parameter of RHEL5.5 to

When startup is runningOracle error, ORA-600 error. The error is as follows,ORA-00600: Internal error code, parameter: [keltnfy-ldmInit], [46], [1], [], [], [], [], [], [] This error occurs when nomount is started, so it is related to the system.I

When installing Oracle 11g R2, the following message is displayed: swap size failed. The SIZE of SWAP space is smaller than the SIZE of SWAP space required by ORACLE. You do not want to re-partition the SWAP partition. Therefore, create a SWAP file

When creating a database table, you can specify a DEFAULT value (DEFAULT value ). Using default values for database fields helps isolate database design issues from application code. You can use the alter table command to change the default value of

Use dbms_stats or analyze Since Oracle8.1.5 introduced the dbms_stats package, Oracle and experts have recommended dbms_stats to replace analyze. The reasons are as follows: 1. dbms_stats can be analyzed in parallel. 2. dbms_stats has the automatic

V $ SESSION In this view, each session connected to the database instance has a record. Including user sessions and background processes such as DBWR, LGWR, and arcchiver. V $ common columns in the SESSION V $ SESSION is the basic information view

Audit FunctionThe database is in the mount status.SQL> alter system set audit_file_dest = '/u01/gdrz/' scope = spfile;(Set the Audit Directory)System altered.SQL> alter system set audit_trail = db, extended scope = spfile;System altered.[Oracle @ bw

// In common applications, we use the date function to_date () in many places ()// But we know little about the date function format, or we will not study it at all.// However, knowing how important the date format is// The following is a specific

The Gentoo Linux operating system (pronounced/mongod zookeeper ntu kernel/) is a Linux meta release version based on the Portage package management system. This project and its products are named after the babaya penguin. The Gentoo package

Oracle is a large database that can be used to store massive data. There are also various ways to import data sources, some of which are constantly added as the business grows, and some are also imported in batch during business system

A ORA-01555 error was found during database security check: This SQL statement is obviously not completed after running for a long time. In the Statspack report, this SQL statement is also on top.SQL occupies a large amount of db cache. Large

The day before yesterday, according to the experiment steps described in RAC and STREAM in oracle rac, a similar experiment environment was set up on HP rx8640, and the experiment failed. Yesterday, I found an article "Learn oracle stream step by

Error message: Can't connect to local MySQL server through socket '/var/run/mysqld. sock' Solution: Create a mysqld directory under/var/run/, and create a link pointing to:/opt/lampp/var/mysql. sock Input command: ln-s/opt/lampp/var/mysql.

Tested the cost calculation of full table scan for Oracle11gR2 in non-workload mode. Now we can test the cost calculation of full table scan for Oracle11gR2 in workload mode. First, we will increase the table blocks to 10003. SQL> select owner,