Database Administrator

Use Windows performance monitor to monitor common SQL Server metrics As mentioned in the above article, Win's Performance Monitor is an essential tool for monitoring database performance. Next I will introduce some common monitoring metrics, which

MongoDB Data Replication shard I. MongoDB introduction: MongoDB is a high-performance, open-source, and non-pattern document-based database. It is a popular NoSql database. It can be used in many scenarios to replace traditional relational databases

Football and oracle series (5): The directX library missing in the voda14 game is similar to the oracle rpm package, fifa 14rpm **************************************** ******************************** ************** Original Works are from the blog

Specification of memory size in different Oracle versions, different oracle versions  **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to

I. Check hardware requirements:1. Memory:#/Usr/contrib/bin/machinfo | grep-I MemorySwap:1 GB-2 GB 1.5 times the size of the RAM2 GB-16 GB Equal to the size of the RAMMore than 16 GB 16 GBView the swap size:#/Usr/sbin/swapinfo-2. Disk Space:/Tmp

[PLSQL Developer] PLSQL Developer SQL Editor garbled, plsqldeveloper[Problem] We often write various statements in the SQL window of PLSQL Developer. To save these statements, you can save them as a text file or copy them and paste them into a Word

Oracle Database permission management and oracle permission managementPermission management: the default three usernames and passwords in oracle 9: sys change_on_install // the Administrator with the highest permissions: system manager // normal

Sqoop import data time date type error, sqoop import data date A problem has been plagued for a long time. When sqoop import is used to import data from a mysql database to HDFS, an error is reported until an invalid value of the time and date type

It took an entire afternoon (more than six hours) to sort out the summary, which is also a deep understanding of this aspect. You can look back later. After installing Hadoop, run a WourdCount program to test whether Hadoop is successfully installed.

I. Basic Introduction SQLite is a self-contained, serverless, zero-configuration, and transactional relational database engine. Because it is very small, it can also be built into your application as an embedded database. SQLite is used in Solaris 1

Use exp/imp to migrate data, especially between different versions and between different systems,Of course, we recommend that you use expdp/impdp to import and export data. The following is a brief introduction to the basic operations of exp and imp.

For details about how to use the count function in MySQL, mysqlcount The count function is a function used to count records in tables or arrays. Here we will introduce the usage and Performance Comparison of the count function in MySQL. Count (*)

RedHat Linux 6.2 Oracle10g installation and configuration Manual The following are all root user operations: 1. Installation preparation 1.1 RedHatLinux Server 6.2 Installation File RatHatLinuxServer-6.2-x86_64.iso 1.2 Oracle10g Linux Installation

SQLite tutorial (4): built-in functions, sqlite tutorial built-in functions 1. Aggregate functions: The aggregate functions supported by SQLite are also supported in many other relational databases. Therefore, here we will just give a brief

What is the data structure ?, Data structure? What is the data structure? A Data Structure is a data structure that stores and organizes data by computers. A data structure refers to a set of data elements with one or more specific relationships

1. First, you must understand what an execution plan is? An execution plan is a query solution made by the database based on the statistics of SQL statements and related tables. This solution is automatically generated by the query optimizer, for

Redis Research (14th)-management tools, redis research toolsTo do well, you must first sharpen your tools. When using Redis, if you can effectively use various Redis management tools, it will greatly facilitate development and management. I.

In Oracle, table columns are changed from VARCHAR2 to CLOB and varchar2clob.Scenario The columns in the original table are defined as the VARCHAR2 type. As we all know, the maximum length of the VARCHAR2 type is 4000. If you want to convert this

Mysql-related log summary and mysql Log Summary As an important means of querying problems, log should be recorded as much as possible for you to query some problems. MySQL has the following types of logs:Error log:-log-err Query log:-log Slow query

The simplest and most effective Bufferpool A buffer pool is a storage area in the memory. It is used to temporarily read and modify database pages (including table rows or index items ). The buffer pool is used to improve the performance of the