Database Administrator

Case Study of Oracle Study-view the "strange phenomenon" of shared memory through IPCS" In the Oracle 11gR2 environment, using the ipcs command to view the shared memory, we found that the memory allocated to Oracle is only 4096 Bytes, and this

MySQL transactions and lock mechanisms The characteristic ACID of a transaction, that is, atomicity, consistency, isolation, and durability. Atomicity ensures that a transaction is a minimum unit, which is inseparable from each other; Consistency

Oracle 11gR2 ASM single instance installation stepsEnvironment: Platform: VisualBox 4.3.12OS: Oracle Linux 5.8 Grid Infrastructure: 11.2.0.3Database: 11.2.0.3 1. Install the Operating System (omitted) 2. Configure the software installation

Oracle Study case -- rebuilding Database Control Files System Environment: Operating System: Linux RH6 Database: Oracle 11gR2 Case Analysis: All control files in the Oracle database are accidentally damaged. Non-archive databases rebuild control

Oracle Optimization Based on Solaris or Linux I. High cluster wait time problems in RAC 1. Set the LMS process to FX 60. Do not adjust the number of lms processes too much. Note: process priority can be set after Solaris 10 Update 10 and Solaris 1

Restrictions in Oracle and OracleConstraint type CONSTRAINT_TYPE in Table ALL_CONSTRAINTS:C (check constraint on a table) -- constraints, such as not null, checkP (primary key) -- primary keyU (unique key) -- unique key constraintR (referential

Data room charging system-storage process and charging system storage process A lot of things have been learned in this IDC charging system. E-R diagrams, views, stored procedures, triggers and more. All these things have been learned before, and

Install MySQL5.6.22 in CentOS-7, centos install mysql5.6 Install MySQL5.6.22 in CentOS7 (Latest Version) Reprinted please indicate the source:Jiq • Chin's technical Blog1. installation environment (1) CentOS version: CentOS-7 View method: [Root @

Database topic of SQL Study Notes (iv): Introduction to JDBC usage and Study Notes jdbc The jar package provided by the database vendor for database operations is the database driver. If each vendor provides their own database driver, it will lead

Four notes from the InnoDB section of MySQL The first is the transaction implementation mechanism of InnoDB. On csdn, click "Download". Here we will briefly introduce that it is controlled through redo and undo, in addition, the log buffer is

Max_prepared_stmt_count, maxparametercount An error occurred while migrating data from SqlServer to MySQL. The ole db access interface "MSDASQL" of the link server "192.168.66.53 (ewallet_lxl)" returns the message "[MySQL] [ODBC 5.2 (w) driver]

Restoration Method for 10g Clusterware Votedisk corruption, clusterwareVotedisk is very important for RAC (10g Clusterware, 11g GI). We call it an arbitration disk, when a node in the RAC cluster fails and the network is disconnected, it determines

PostgreSQL stored procedure returns a dataset instance, and postgresql Stored Procedure Here we use an instance to demonstrate how to return data sets in the PostgreSQL stored procedure. 1. Prepare the data table first. //member_categorycreate

Record an Oracle 10g data recovery event, oracle10 g Facts have proved that I will not die if I don't die. This Oracle crash took me two days, just because I installed some inexplicable Android simulators and uninstalled them again. After

The future star of NoSQL databases and the future star of nosql DatabasesRelational Database Value When learning NoSQL, we certainly think of the mainstream database-SQL database at this stage. Why does SQL database become the mainstream? It is

Oracle client-free PLSQLDeveloper Configuration Guide, oracle client Configuration Oracle client-free PLSQLDeveloper Configuration Guide  Step 1: Download instantclient-basic-win32-10.2.0.5.zip from the oracleofficial network to the local machine,

Add new data files to the database in the environment of the aix bare device. In a bare device environment, adding data files is a little more troublesome than other environments, because only one data file can be created under a bare device. The

Mysql api with rollup, mysqlrollup The group by clause allows an additional row to be added to the simple output end WITH the ROLLUP modifier. These rows represent high-level (or high aggregation) simple operations. ROLLUP allows you to answer

In the oracle query table, a specific type of data is very slow, and no reason is found. oracle does not When I look up a table today, it is very slow to query a specific type of data in the table, but the whole table is very fast, and no reason is

Http_load Benchmark Test (full-site test) and http_load Benchmark TestHttp_load (full-site test) Http_load is an open-source tool running on the linux operating system for website stress testing. :