Database Administrator

Temporary table VS table variables: suitable for use (1) For a long time, there has been a lot of debate over the advantages and disadvantages of temporary tables and table variables. Some friends in the Technical Group even think that table

Oracle Database faults Common Oracle Database faults: 1. system faults: sudden power outages and system restarts caused by operating system errors during server operation. Problems: memory data loss and database data inconsistency. Database data

Oracle dynamic server parameter fileThe Oracle dynamic server parameter file (SPFILE) SPFILE is a binary file that is automatically maintained by the Oralce server process. This file cannot be manually modified. Once it is manually modified, it

Will MySQL secondary indexes automatically complete the primary key? At the beginning: I have been skeptical about whether MySQL secondary indexes are automatically added to the primary key. Today I have analyzed 5.5 and 5.6

How to Use AWR reports to diagnose database performance problems How to proactively avoid problems and collect diagnostic information Some problems are unpredictable, but most other problems can be avoided if some signs are discovered early. At the

Configure Statspack in Oracle RAC Environment Statspack is a product of the Oracle 9i era. It has a cross-milestone significance for monitoring and analyzing database performance and is the predecessor of AWR. After 10 Gb of Oracle, AWR replaces

Shell script instance for creating a tablespace in Oracle Shell script instance code for creating a tablespace in Oracle: #! /Bin/bash# Ocpyang@126.com# Create tablespace If [$ #-ne 2]; thenEcho "Usage: $0 TABLESPACE_NAME TABLESPACE_SIZE"Exit 1Fi #

MySQL Status variable) The MySQL status variable is the system status information accumulated after the current server is started. It is mainly used to evaluate the usage of the current system resources to further analyze the system performance and

Database backup and restoration, log cleanup code, and database backup logs -- The database is occupied and cannot be restored. Solution: -- 1. Set the database to work in single-user mode. -- Setting method: Right-click the database to be restored,

How can I remotely back up a database to a local database? How to remotely back up a database to a local database -- 1. Enable xp_mongoshelluse masterEXEC sp_configure 'show advanced options', 1 reconfigure with overrideexec sp_configure 'xp _

This server supports both version 661 and earlier. The downgrade path is not supported ., 661 downgradeThis server supports both version 661 and earlier. The downgrade path is not supported.Environment: SQL Server 2008 R2. problem: the error "this

Create MySQL slave database and MySQL We know that Oracle has DataGuard to back up data in real time, which can be used for master-slave switchover. MySQL also has its own backup database solution, which is called master-slave replication. The

Failed to open the physical file mdf. Operating System Error 5: "5 (Access denied .) ", Mdf cannot be openedFailed to open the physical file mdf. Operating System Error 5: "5 (Access denied .) "Environment: SQL Server 2008 R2 problem: "The physical

What does RAC mean? RAC: Real Application Clusters1 CRS management command1. Start crs (both nodes need to be executed)/Etc/init. crs start2. query the current crs status./Opt/oracle/crs/bin/crs_stat-t3. Stop crs (both nodes need to be executed)/Etc/

Redis source code analysis (5) --- sparkline micro-line chart, redissparkline I didn't know what it meant when I read sparkline for the first time. I never heard of it before, but it actually appeared in the redis code, at the beginning, I thought

Adjust the redo log file size in oracle rac, racredoAdjust the size of the redo log file under rac(1) view the current log information:Select * from v $ logfile;(The path in step 2 can be seen in the MEMBER column here. The redo file name is named

MySQL creates a Function and mysqlfunctionTarget How to Create a Function in a MySQL database) Syntax Create function func_name ([func_parameter]) // brackets are required. The parameter is optional. RETURNS type [characteristic...] routine_body

Trigger -- start again, trigger -- start The trigger is actually involved in Data Center reconstruction. Some use the stored procedure of the trigger. Now we have encountered the use of triggers in niuyun. Let's start again to see how to use it. To

Ibatis: The ibatisquery method, which is not commonly used. 1. queryForObject /** * Executes a mapped SQL SELECT statement that returns data to populate * the supplied result object. * * The parameter object is generally used to supply

[MongoDB] The basic operation of Index in MongoDB, mongodboperation In the past four blogs, we attached importance to the index, including description and comparison with usage of index. now in this blog, we will mainly focus on the basic operation