Database Administrator

The SEGMENT_SIZE does not change after the TRUNCATE TABLE In the test environment, historical transaction tables can be cleared and only the table structure needs to be retained. Therefore, we wanted to clean up the space through TRUNCATE. We found

MySQL is a simple and easy-to-use basic operation guide. (1) Introduction to mysql basic operations System: Ubuntu 14.04 LTS Installation: Apt-get install mysql // install the database apt-get install mysql-workbench // install the graphical

Summary of Oracle parameter viewing methods and oracle parameter Summary Oracle provides a large number of system parameters. The following is a summary of the query methods.Current System Parameter The current system parameters involve these views:

Use kettle to batch download files and kettle to batch download files Use kettle to batch download files In the latest projects, you need to download files in batches and import the results into the data. kettle is indeed competent through some

Oracle 10g 10.2.0.1 in Oracle Linux 5.4 32Bit RAC installation manual (a touch of Xiangyang), 10.2.0.1 installation manual Oracle 10g 10.2.0.1 installation manual in Oracle Linux 5.4 32Bit rackets (step by step) Http://download.csdn.net/detail/rlhua/

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

The root User Name in ubuntu cannot enter mysql, how to view the user name and password, how to modify the root password, and tumysqlMysql-u root-p Press enter. after entering the password, the system prompts "access denied... ues password YES/NO"

1. Result Set Caching description   For instructions on the Oracle official website, refer: 7.6 Managing the Server and ClientResult Caches Http://docs.oracle.com/cd/E11882_01/server.112/e16638/memory.htm#BGBCABED   1.1 Overview You can enable

Mysql-workbench is a graphical MySQL management tool, which has been well done and can be used for database management and development. The following describes how to install the tool: 1. Download mysql-workbench. :

NoSQL has now become a very popular topic in the IT industry. In this article, we will introduce you to the basic knowledge of CouchDB, a member of NoSQL, and take you into the world of NoSQL.   What is NoSQL? NoSQL (short for not only SQL, also

Many friends think that in simple mode, the heap table cannot retrieve a record because there is no log record. In fact, in a sense, it can be recovered, because the heap table only changes the row offset when deleting records, and the actual data

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

Alex's Hadoop cainiao Tutorial: tutorial 10th Hive getting started, hadoophiveInstall Hive Compared to many tutorials, I first introduced concepts. I like to install them first, and then use examples to introduce them. Install Hive first. First

Install the 32-bit oracle software in 64-bit linuxIn some cases, sometimes we need to install 32 oracle software on a 64-bit system (for example, the customer's abnormal requirements ). Although theoretically, this method is feasible, but in the

Navicat 1577-Cannot proceed because system tables used by Event Scheduler where found damaged at s, navicat Problem: Today, Navicat is used. However, when a new mysql instance is connected, no matter whether a database is opened, the system prompts 1

For example, the database administrator needs to enable the Oracle database system to perform self-monitoring. When the server's CPU usage reaches, the system automatically sends an alarm to the database administrator. When the tablespace usage

Use the transparent data encryption (TDE) of the Oracle database introduced as part of Oracle Advanced Security Option Version 10.2 and later ), you can selectively Encrypt sensitive database data stored in the underlying database data files and all

INSERT Process Overview First, let's take a quick look at the processing steps when inserting a row. Each step in these steps has the potential for optimization, which will be discussed later. 1. prepare statements on the client. For dynamic SQL

There are many discussions about Automatic Storage Management (ASM), but what is ASM? ASM is an effective abstraction layer that enables your Oracle database to be used together with an abstract space called diskgroups, rather than directly using

It is easy to have problems when managing databases, but how to solve problems when database pages are damaged or verification errors occur is also important for everyone to understand. I have been learning more about database Fault Handling