Database Administrator

Oracle Optimization Based on Solaris or Linux I. High cluster wait time problems in RAC 1. Set the LMS process to FX 60. Do not adjust the number of lms processes too much. Note: process priority can be set after Solaris 10 Update 10 and Solaris 1

Test and failure of Oracle Materialized View Description: The Materialized View (Materialized Views) is the query result set. Changes to all original tables and Views will invalidate the Materialized view, recently, I found a problem that

IOS sqlite basics and iossqlite Basics 1. Import the libsqlite3.0.dylib Library File: # import "sqlite3.h" 2. Create a database # Define kDocDir [NSSearchPathForDirectoriesInDomains (NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex: 0] #

Install the svn server in centOs5.10 and centos5.10svn /// // ============ = Install the svn server in CentOs5.10 ======================== ///////////////// ////////////////// // 1. Install SVN # Yum list sub * # Yum install subversion // 2. Check

Database topic of SQL Study Notes (iv): Introduction to JDBC usage and Study Notes jdbc The jar package provided by the database vendor for database operations is the database driver. If each vendor provides their own database driver, it will lead

Locate the specific datafile on which row data is stored in the table and which datafile Subtitle: uses a PL/SQL statement to locate the specific datafile in which row data is stored in the table. A dba may often ask you how to know which data file

Oracle exp exports a large number of tables and the table structure. oracleexp The requirement is: to export the structure of a specified 3 thousand tables, This is generally the case, but the problem is that the table is very large and won't

Record an Oracle 10g data recovery event, oracle10 g Facts have proved that I will not die if I don't die. This Oracle crash took me two days, just because I installed some inexplicable Android simulators and uninstalled them again. After

The future star of NoSQL databases and the future star of nosql DatabasesRelational Database Value When learning NoSQL, we certainly think of the mainstream database-SQL database at this stage. Why does SQL database become the mainstream? It is

Data Source (connection pool), data source connection Data sources are generally implemented from javax. SQL. dataSource interface, Spring, Struts, Hibernate and other frameworks all have their own data sources. Tomcat also has built-in data

Mysql api with rollup, mysqlrollup The group by clause allows an additional row to be added to the simple output end WITH the ROLLUP modifier. These rows represent high-level (or high aggregation) simple operations. ROLLUP allows you to answer

Database Operation Specifications and database specifications This article is an original article. For more information, see the source: Http://blog.csdn.net/msdnchina/article/details/42780787 1. When writing data to a database, use the nohup

10gR2 terware simple installation steps, 10gr2clusterware1. Install the Operating System (omitted)Note: I use the OEL 5u5 version here. Because it comes with the environment variable installation package provided by Oracle, It is very convenient to

Oracle Gateway11g R2 accesses the configuration documents of heterogeneous databases (DB2), gateway11gdb2   Directory1. Prerequisites 2. Download transparent gateway 3. Unzip and install transparent gateway 4. Install the DB2 client program 5.

Oracle string operation, oracle string Select upper ('testmyname') from dual; -- convert to uppercase Select lower ('testmyname') from dual; -- convert to lowercase Select upper (substr ('testmyname'), 5) from dual; -- intercept myname and

Oracle instr function usage and (oracle uses instr to replace like), oracleinstr Oracle instr function appeared in the recent project, so I found some information about it on the Internet. Usage of INSTR and SUBSTR in Oracle INSTR usage in

Use of TTL in ssdb and use of ssdbTTL[Nerd @ QA tools] $./ssdb-cli-p 8999Ssdb (cli)-ssdb command line tool.Copyright (c) 2012-2014 ssdb. io'H' or 'help' for help, 'q' to quit.Server version: 1.8.0Ssdb 127.0.0.1: 8999> TTL 01: 00000:

Oracle XE Installation Guide on CentOS, centosxe Introduction: Installing oracle xe on Centos is mainly used for learning and testing. Although simple, it involves many steps and details. 1. Download Oracle XE Access the

Output the log configuration of java log4j to mysql, log4jmysql Log4j supports outputting logs to files, databases, and even remote servers. This time I will share with you how to output logs to mysql. (1)The configuration of log4j. properties is as

Oracle performance optimization operation 12: Use Case statements to merge multiple scans, oraclecase We often have to calculate different aggregation based on multiple sets of data tables. For example, the following example uses three independent