Database Administrator

The server Load balancer of the Oracle RAC server distributes new connection requests to the node with the smallest load based on the number of connection loads of each node in the RAC. When the database is running, the PMON process of each node in

MySQL version 5.1.49 # Uname-Linux loDB192168000046 2.6.18-238.19.1.el5 #1 SMP Fri Jul 15 07:31:24 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux # Cat/etc/issueCentOS release 5.6 (Final)Kernel \ r on an \ m # Mysqlhotcopy-u root-p 'Password' database name

There is a new feature in Oracle 11gR2. When the table has no data, no segment is allocated to save space. Oracle cannot export empty tables when executing export, but there is still a solution. Solution: 1. insert a row and then roll back to

SQLite statement: Select count (*) FROM sqlite_master where type = 'table' and name = 'student '; If yes, 1 is returned; If it does not exist, the return value is 0. C # statement: SQLiteCommand mDbCmd = mDbConn. CreateCommand (); MDbCmd.

Version: OS: Enterprise Linux Server release 5.7 Db: Release 10.2.0.1.0 Ogg: Version 11.2.1.0.1 Prepare beforehand (both nodes must be prepared ): 1. Install and start Oracle, upload ogg installation media to/ogg, and decompress 2. Create a ggusr

Environment: SQL> select * from v $ version where rownum = 1; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod SQL>! Uname-r 2.6.18-308. el5xen The

1. analysis table and index (analyze does not rebuild the index) Analyze table tablename compute statisticsEquivalent to analyze table tablename compute statistics for table for all indexes for all columns For table statistics exist in views:

I. Summary of list Common commands THE list command lists the backup information in the control file and RMAN recovery directory, which is one of the most intuitive ways to understand all visible database backup files. List incarnation; List backup

Login as: rootRoot@192.168.88.xx's password:Last unsuccessful login: Tue May 15 22:15:03 BEIST 2012 on ssh from 192.168.88.xxLast login: Thu Aug 23 01:27:54 BEIST 2012 on ssh from 192.168.88.xx **************************************** ***************

Oracle dynamic SQL statements are easy to use, but the assembly process is too annoying. Especially when a date field is involved in the Assembly Statement, to_char must be added during the Assembly to convert it into a character first. In SQL,

Today, to_char is used in the stored procedure to query the day of the week. I thought there was no problem, and I didn't want it. Select to_char (sysdate, 'day', 'nls _ DATE_LANGUAGE = AMERICAN ') day Into v_day From dual; Note: The returned values

When reading some posts online. Someone found that the mechanism for organizing and managing database file storage in Sqlite is B-tree. I think this is not rigorous. So I turned out the definitive guide to sqlite SECOND EDITON. After review, I would

Recently deployed project, the following message is displayed in the Linux system for testing (such as test) tnsping orcl using non-Oracle users: TNS Ping Utility for Linux: Version 11.2.0.1.0-Production on 04-DEC-2012 14:29:28 Copyright (c) 1997,200

There are three types of pages for Oralce. 1. rownum Select * from emp 2. Display rownum [allocated by Oracle] Select a1. *, rownum rn from (select * from emp) a1; 3. Several query changes A. to specify a query column, you only need to modify the

Today, the rac database query database encountered the ORA-00600 kcbz_check_objd_typ_3 error, and the disk queue process is very high, the system pressure is very highAfter the alter system flush buffer_cache statement is executed, the error

PhpMyAdmin 3.x must be php5.2 or above, and be prefixed with a Checksum. If you choose the wrong one, the problem will be difficult to solve. PhpMyAdmin is a MySQL management tool that manages MySQL directly from the web. 1: Upload

Memcached is a distributed memory object cache system, which is usually used for dynamic Web applications to reduce database load. Memcached is a hashmap based on a storage key pair. When the table is full, it is replaced by the LRU (least recently

In the last week, I reviewed index-related things. In addition to reviewing concept, I also saw a good document on MOS. Share with you. Document No.: [ID 30405.1] This article is only concerned with B * tree indexes which are currently the most

Operating system version: RedHat 6.2 64-bit Database Version: Oracle 10.2.0.4 Problem description After the software is successfully installed, no error is reported during the installation process. If dbca is executed, the following error is

The GATHER_TABLE_STATS process of the dbms_stats package is required. The owner and table names must be filled in. PROCEDURE GATHER_TABLE_STATSArgument Name Type In/Out