Database Administrator

CentOS 6.5 offline compilation and installation of MySQL 5.6.22 Offline compilation and installation of MySQL 5.6.22 on CentOS 6.5. 1. Download the source code package Http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.22.tar.gz 2.

ORA-00382 and DB_nK_CACHE_SIZE parameter settings Recently, I tried to optimize a query that contains the blob field table and considered using a non-standard block cache. However, an error occurred while trying to set the DB_32K_CACHE_SIZE

Oracle 10g one master multiple slave construction skills In the Oracle database environment, one-master-one-slave mode is a traditional method of use. In case of a disaster, you can flexibly switch the master-slave role to maintain service

Warning during Oracle Compilation Compiler Warnings Compiler warning Oracle 10g allows you to enable compile-time warnings that are useful to identify potential run-time problems in your programs. these warnings are not serious enough to raise an

Add ASM disk error ORA-02097 and ORA-15014 Background: This is a set of currently installed 11.2.0.1 RAC. The Grid Infrastructure has been installed, the ASMLib and the disk partition have been completed, and no member disks were found when the

SQL Server database user permission settings In SQL Server 2005 databases, we can set permissions for each user to improve database security. This type of user permission settings are widely used. For example, you can set a user's permission to

What happens to MySQL when the disk space is full? Guide What happens to MySQL when the disk space is full? What should I do? What will happen When the disk space is full, MySQL cannot write any data, including writing data to the table and

Multi-User concurrency and transaction processing in Oracle Concurrent accesses to multiple Oracle usersTransaction: an inseparable operation acting on some data Lock: Write lock, mutex lock (can only be used by one process) read lock, shared lock

How to use SQL select distinct, selectdistinct Duplicate values may exist in the table. This is not a problem. However, sometimes you may want to list only different values. The keyword distinct is used to return a unique value. Table: Example 1

In awr, "PHYSICAL_MEMORY_BYTES" indicates the available physical memory and physical memory. Environment: Microsoft Windows x86 64-bit, Oracle Database 11.2.0.1.0, single-host   In awr, the memory displayed by "PHYSICAL_MEMORY_BYTES" is the

[] How to modify data of a table in batches in sqlserver, 2015 sqlserver During the past few days of exercises, I encountered a small problem. For example, if I had a score initialized to 0 in all the tables, I want to randomly generate less than 100

Select sequence. currval reported error ORA-08002: sequence XXXX is not defined in this process, sequencecurrval Scenario Description: 1. Create a table named S_DEPART -- Create tablecreate table S_DEPART( departid INTEGER not null, departname

What is Spark ?, Spark? What is Spark? Spark is an open-source cluster computing system based on memory computing. It aims to make data analysis faster. Spark is very small and exquisite. It is developed by a small team dominated by Matei at the

Mysql5.6 audit function, mysql5.6 Audit1. Preface for security and operation traceability considerations, more and more companies have added audit functions. Mysql5.5 has released related audit functions. The 5.6.20 function is barely available.

For Mysql Enterprise Audit plugin, auditplugin As in the previous article, if you want to know who has logged on to your database server and what has been done, you need to use Mysql Enterprise Audit plugin. The following describes how to use Mysql

CentOS-based Mysql learning Supplement 2-using Shell to create a database, centosmysql Article Source: CentOS-based Mysql learning Supplement 2-using Shell to create a database For how to use the mysql database based on commands, see the

ORACLE management-view users with DBA roles, oracledba 1. view All users: select * from dba_users; select * from all_users; select * from user_users; 2. view system permissions of users or roles (system permissions assigned to users or roles):

Oracle database wrc execute error ORA-15557, wrcora-15557 [Oracle @ host capture] $ wrc system/oracle @ db1 REPLAYDIR =/home/oracle/cap_dir/Workload Replay Client: Release 11.1.0.7.0-Production on Sun Jul 19 17:16:56 2015 Copyright (c) 1982,200 7,

[Oracle 10g] sqlplus logon error resolved, oraclesqlplus I,When running sqlplus in cmd in win7, the following error is reported: SP2-1503: Unable to initialize Oracle call interface SP2-1503: Unable to initialize Oracle call SP2-0152 Solution:

ORACLE Database Export table, oracle Database ImportToday, a system is installed on the company's server and cannot be imported during database table export. It was originally 10 Gb. the dmp file is imported to 11 GB. If you suspect that the version