Database Administrator

Practice: oracle timesten 11.2.2.7.0 on centos 6.5, timestencentos Entry level, but the steps are more detailed, there is no theory, can be used as an entry manual.   **************************************** * ******************************** 1.

A tragedy caused by the dramatic increase in HugePages ORACLE sessions not enabled, hugepagesoracle Fault description: HugePages is not enabled in LINUX, the host memory is nearly 300 GB, And the SWAP is 32 GB. The SGA_MAX_SIZE setting of ORACLE is

Mongodb replica set priority settings, mongodb replica priorityWhen you set a mongodb replica set, the Primary node, second node, and arbitration node may have unbalanced resource configurations (CPU or memory). Therefore, some nodes must not be

ProgressWheel: progress bar of the Android open-source ring, This is a custom Android component that replaces the standard progress bar component. Implement various progress bar styles, including rings and scans. XML:Add the following to your attr.

SQL statement records, SQL statements Query all surgical appointments and the corresponding schedule. If the pk is not null, separate them with commas ). The SQL statement in mysql is as follows: Select distinct. pk,. surgeryName,. clerkName,.

Mysql is configured based on binlog master-slave replication and mysqlbinlog master-slave The last time I configured the master-slave replication for mysql was at the beginning of the year, I did not expect to start using mysql again. If you don't

ORA-12801, ORA-08103, ora-12801ora-08103 I. Version Information Operating system version: AIX 61009 Database Version: 11.2.0.3.11 (RAC) Ii. Error description R & D response, today they report a lot of Process "ORA-12801: parallel query server P004,

Mysql backup method summary, mysql backup Summary Different DBAs for Mysql backup have different preferences! I will first list the following methods: 1. Use mysql's automatic dump tool, and use Shell to execute crontab; 2. XtraBackup (it has

View two common SQL statements used by the tablespace and two SQL statements used by the tablespace 1. view the tablespace size: SELECT tablespace_name, SUM (bytes)/1024/1024 total FROM DBA_FREE_SPACE group by tablespace_name order by 2 DESC; SQL>

How does CrossApp create a new project? Does crossapp create a project? The method of creating a project in CrossApp is basically the same as that in the Cocos2d-x, it is to use the python script to complete the creation, first open the terminal.

Left Join, leftjoin After the development has executed a statement for more than two hours, the developer asked me why I have been running it for so long.Statement format:select * from tgt1 a left join tgt2 b on a.id=b.id and a.id>=6 order by

C # -- Integrated Security = SSPI in Web. config,Problem cause In the past, the configuration file was used to access the database when the charging system of the IDC room was restructured. For example: string="server=localhost;database=pubs;uid=

[MongoDB] uses shell in Mongodb to achieve dynamic interaction with javascript. mongodbshell The use of mongodb shell to execute scripts is a bit omitted in previous articles; now I will add a supplement to this blog;1. input the script file in the

Ohasd failed to start: Inappropriate ioctl for device, ohasdinappropriate Today, my colleague encountered a problem when installing GI. Let me take a look. The following record is as follows: Symptom: When installing gi, run root. sh and report the

Install MySQL and Ubuntu tumysql1. Verify that MySQL is installed on the original host:Run the sudo netstat-tap | grep mysql command to check whether the MySQL port exists. If sudo is not added, the execution fails because of the permission: $

Oracle Development Series (iii) table access by index rowid you do not know the INDEX back TABLE, rowid back TABLE1 Introduction Recently, the system often prompts a problem where the SQL query time is too long. After reading it, it is an SQL

Usage of the UNIQUE constraints (UNIQUE Constraint) in Oracle, uniqueconstraint Oracle | PL/SQL Unique index (Unique Constraint) Usage1 goal The following example shows how to create, delete, disable, and use uniqueness constraints. 2. What is a

Oracle Foreign Key usage (1), oracleforeign Oracle Foreign Key usage (1)1. Objectives Demonstrate how to use a foreign key in an Oracle database 2. What is a foreign key? 1) in Oracle databases, foreign keys are one of the methods used to achieve

Oracle Primary Key usage explanation, oracleprimary Oracle/PLSQL: Primary Key Usage1 goal The example shows how to create, delete, disable, and enable a primary key. 2 preface-what is a primary key? In Oracle, a primary key indicates a single data

General framework of Oracle, Oracle framework The physical structure of Oracle includes parameter files, control files, data files, redo log files, archive files, and password files. 1.1 parameter file This includes a large number of settings that