Database Administrator

Use PL/SQL to connect to Oracle without installing the Oracle client Want to connect to the Oracle database? Install the client. OH ~ NO !, A few hundred megabytes are missing. Now you only need to download a software named Instant Client Package

Install Percona Server using the source code package Install Percona Server using the source code package 1. Download the source code tar package. Https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.29-76.2/source/tarball/percona-

Usage and difference of in, exists, not in, and not exists in SQL queries 1. in and exists In connects the External table to the internal table as a hash (Dictionary set), while exists loops the External table and queries the internal table after

Compile and install MariaDB-10.0.20 under CentOS 6.6 System Environment: CentOS6.6 (Final)MariaDB port: 3309 (because MySQL is already installed on the local machine and you do not want to delete MySQL) # Wget http://mariadb.nethub.com.hk//mariadb-10

Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU Installation Summary 1. Preparations before installation: Operating System: RHEL6.5 Storage: Huawei, multi-path configured Bind the business network card and heartbeat network card and pass the

Step 2 of kettle's User Defined Java Class, kettledefinedZookeeper Step 2 of User Defined Java Class)   The "user-defined java class" step in kettle, also known as the UDJC step, is available in version 4.0 and has powerful functions and is

Mysql query today, yesterday, last 7 days, last 30 days, this month, last month data, mysql January Recently, the data record query function for the current month was used in the project. The original idea was to construct a period of time in the

In one sentence, convert a Linq statement to an SQL statement.Zookeeper Public IEnumerable ReportView_List (VMB_ReportConditions requiredModel){IEnumerable resultModel = new List ();IQueryable merchantList;MerchantList = Report_List (); # Region

Preface Indexes are one of the most important objects in relational databases. They can significantly reduce disk I/O and logical read consumption and improve the query performance of SELECT statements. However, it is a double-edged sword. Improper

Oracle uses a single cursor to insert data. For example, oracle cursor Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/47143731Background Recently, some friends asked me how to insert

Redis configuration file redis. conf detailed description, redisredis. conf Redis. conf1. daemonize # By default Redis does not run as a daemon. use 'yes' if you need it. # Note that Redis will write a pid file in/var/run/redis. pid when daemonized.

Similarities and differences between Oracle Enterprise Edition, Standard Edition, and other versions, oracle Enterprise Edition For different development and deployment environments, Oracle divides the same series of Oracle databases into four

MongoDB BASICS (9) sharding and mongodb Basics Sharding stores data on multiple servers. Mongodb uses sharding to support deployment of very large datasets and high throughput operations. The capabilities of a single server are limited in various

Redhat 6.4 install ORACLE11R2 and run root. sh to report the following error: "libcap. so.1: cannot open shared object file", oracle11r2root. sh 1. system environment: Redhat 6.4 Enterprise Edition Oracle11.2.0.2 RAC + ASM 2. error

ORACLE-006: Remove and stop jobs, oracle006 remove jobs Generally, you can use SQL to delete or stop a job. Remove JOB: remove Stop JOB: broken First pass Select * from user_jobs; Find the job id, and then call Dbms_job.broken or

Atitit. mysql oracle with as mode temporary table mode CTE statement, reduce the subquery structure mssql SQL server..., atitit. mysqlcte Atitit. Use of the CTE statement in the temporary table mode of mysql oracle with as mode to reduce the

DP backup error ORA-19554: error allocating device, device type: SBT_TAPE ORA-27211, sbttape Environment: solaris 10, oracle 11.2.0.4 2 nodes rac Symptom: rman backup reports the following error: RMAN-00571: ==========================================

Chapter 1 ocp exam guide and ocp exam Guide Database storage structure: Physical database storage structure: Three types of files are required: ControlFile: multiplexing the controfile multiplexing Control File,

Mysql_ping () and MYSQL_OPT_RECONNECT MySQL server has gone away "error, mysqlgoneawaySource: http://www.felix021.com/blog/read.php? 2102Yesterday @ Zind found my previous blog (modified), which mentioned mysql_ping and MYSQL_OPT_RECONNECT.The

Run python on ubuntu to connect to pg. the following error occurs: ImportError: No module named psycopg2, ttupythonRun python on ubuntu to connect to pg. The error ImportError: No module named psycopg2 is returned.Root @ pgproxy1 :~ #