Database Administrator

MySQL stored procedures have been criticized for lack of debugging tools since the birth of MySQL 5.0. Since its acquisition by SUN and ORACLE, MySQL products have experienced many improvements in both functionality and performance. However, in

How to copy SQL Server tables and EXCEL Data in batches (solved) 1. Copy SQL Server table data to excel (method) 1. Create a New query and read the table data using SQL statements. 2. Then, right-click the data and copy it (you can also click

DATAGUARD configuration is as follows: PROD is the master database, SBDB is the slave Database 1-3 log groups are redolog files and 4-6 log groups are standby logs. After the standby log is created, the master database closes the database and uses

Some big tables are sometimes used in my experiments. Here we will share how to use dba_objects to create and test large tables: First, create a test table. SYS @ ORCL> create table test nologging as select rownum id, a. * from dba_objects a where 1

1. Start the server File In the install subdirectory of the Sybase directory.RUN_server (here the server represents your server name, for example, here I am RUN_FENGLB) Name, edit this file,Add the parameter "\ data \ master. dat-sFENGLB" to save

685. In your test database: -You are using Recovery Manager (RMAN) to perform incremental backups of your test database -The test database is running in NOARCHIVELOG mode -One of the data files is already upted -All online redo log files are lost

In database management, some historical data or basically unchanged data is put into the read-only tablespace. Because such tablespaces can only be read but not DML. It can effectively prevent accidental modification or deletion, so it is suitable

/* Author: Jiangong SUN */ If you have wondered to clean a table data, and want to save the original data in a backup SQL script. Here is a solution for it. Right click your database-> click "Tasks"-> then click "Generate Scripts" Then you

After Oracle is installed, the first thing to do is to think about how to connect and proceed. SQL Developer is a powerful tool officially provided. In my opinion, it is also the first choice. The latest version on the official website is 4.0.1.14.48

Oracle 12c has a new feature that can archive data in the database, hide infrequently accessed data from the application, and set it to inactive. Of course, it can also be displayed at the session level. This is achieved through the row archival

Modify the locked user in Oracle 11g: scott After installing Oracle10g and creating an oracle database, you can log on to the database using scott to check whether the connection is successful. When you log on with sqlplus scott/tiger in the cmd

Advantages and disadvantages of ASSM and MSSM. ASSM: advantage, support for large concurrent Inserts : Disadvantages: the clustering factor of the index will be very poor-you can use reverse key indexes and Hash partitions. MSSM does not support

After apsaradb for redis is installed (if the reader has not installed it, please refer to the plugin), we cannot only use the redis client to operate the database. Currently, apsaradb for redis supports c, c ++, c #, this document describes how to

In fact, if you write such a title, you will think it is about the three paradigm of SQL Server. Otherwise, you will see the six paradigm of SQL Server in a classic SQL Server book recently. I was surprised a lot at the time. I did not hear much

We use PowerDesigner to create a table and generate an SQL script. Therefore, PhysicalDateModel is used to create a physical model. Open PowerDesigner, click File> Now Model, and select Categories> Information> PhysicalData ), create a new name for

DBA work summary   For more than a year, I have respected and respected the leaders to unite my colleagues, obey the rules and observe the discipline, learn professional knowledge, and work diligently. Summary of the past, in the knowledge structure,

/* Function called at startup to load RDB or AOF file in memory. */void loadDataFromDisk(void) { long long start = ustime(); if (server.aof_state == REDIS_AOF_ON) { if (loadAppendOnlyFile(server.aof_filename) == REDIS_OK)

Paip. Improve Stability --- automatic detection of sleep mysql database dead connections and killAuthor Attilax airlong, EMAIL: 1466519819@qq.comSource: attilax ColumnAddress: http://blog.csdn.net/attilax///// Detects the leakage of the application

Redis Introduction Redis is an open-source, network-supported, memory-based, key-Value Pair storage database written in ansi c. For details, click here.Install redis My linux operating system is ubuntu12.04 Log on to the http://www.redis.io/download

Character Set is a set of symbols and encoding rules. Both the oracle database and mysql database have character set selection problems. Character sets are important for databases, because most of the data stored in the database is various texts.