Database Administrator

Manage redo log records Redo Log ConceptPlan Redo LogCreate Redo Log groups and MembersReallocate and name Redo Log membersDelete Redo Log groups and MembersForce switch logVerify the Redo Log file BlockClear Redo Log filesRedo Log dictionary

Simple role-based permission management of RBAC 1. What is permission management? permission management refers to the subdivision of background functions and the management of jobs divided by different employees How RBAC is implemented is managed

Install and configure MySQL in CentOS MySQL is preferred. The first MySQL database version is released on Linux. Other options include postgreSQL and Oracle. Install the mysql database on Linux. You can download the rpm package of the MySQL database

How to use Oracle External tables to import text file data Recently, colleagues are busy with Data Consistency comparison. They need to compare the data in different text files. Some files are large and have many records. If they are opened in a

Disable task execution using the DBMS_STAT Function Use the following statements to view SQL statements with large physical reads Select executions,Disk_reads,Buffer_gets,Round (buffer_gets-disk_reads)/buffer_gets, 2) Hit_radio,Round

Unix/Linux Kernel Parameters closely related to Oracle The following are several Unix/Linux Kernel Parameters closely related to Oracle. During database installation, the parameters must be adjusted according to the actual situation. Init.

Mysql cannot be remotely logged on. mysql Login When using TCP/IP to connect to mysql, the following error occurs:Can't connect to MySQL server on 'xxx. xxx. '(111) This error occurs. After repeated tossing:Check whether the IP address is

Manual vip resource adding for 11g RAC plus nodes, 11 grac Today, I encountered several problems when I added Node 3 to a set of 2-node rac instances; 1. Private network adapter in the original production rac environment. Multiple redundant network

Mysql5.6 audit function, mysql5.6 Audit1. Preface for security and operation traceability considerations, more and more companies have added audit functions. Mysql5.5 has released related audit functions. The 5.6.20 function is barely available.

How to optimize NFS in Oracle databases ?, Nfs Optimization There are a lot of articles on MOS, which basically cannot run the following three points: Setup can make a big difference1. Network topology and load2. NFS mount options (select an

Mysql performance optimization, mysql 1. When using an index to query records, you must pay attention to the index usage, for example: (1) The string configured with the like keyword cannot start with '%' (2) When using multi-column indexes, the

Mysql installation illustration 1. Several common methods for mysqldump: (1) Export the entire database (including data in the database) Mysqldump-u username-p dbname> dbname. SQL (2) Export the database structure (excluding data) Mysqldump-u

42nd questions, 05342 42. You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL TuningSet as a part of the workload capturing. What information is captured as part of this process? (Choose allThat apply .)A. the SQL

Mysql Character Set and mysql Character SetThe character set defines the character encoding method. ASCII, GBK, and UTF8 character sets are common. All character sets are compatible with the ASCII character set. Character Set Is negative

BSON structure, jsonBSON Structure Flyfish This section mainly describes two examples on the bsonspec.org website. {"Hello": "world "} Hello is the key, and world is the value. \ X16 \ x00 \ x00 \ x00\ X02Hello \ x00\ X06 \ x00 \ x00 \

MySQL Study-MySQL common users cannot log on locally, mysql-mysqlMySQL Study-MySQL common users cannot log on locallyAfter installing MySQL, we usually add common users with corresponding permissions to access the database. When you log on to the

MySQL group sorting, mysql Group I. Problems Product tablePlatform id Product Name Id ptid name1 100 product 12 100 product 23 100 product 34 100 product 4100 product 5100 product 6101 product 78 101 product 8101 product 910 101 products 1011 101

Redis Study Notes --- installation, redis Study Notes ---Introduction As more and more Internet companies begin to use Redis for practical projects, and many people have been discussing the architecture design of Redis, it is suitable for learning.

ORACLE11g poisoning recovery, oracle11g poisoning Unfortunately, the win2003 server is neglected to manage and poisoned. After the virus is cleared, oracle is paralyzed. What should I do if the last backup is still one week ago? The first idea is

Rapid deployment of Zabbix Server and MPM (monitor for mysql), zabbixmpm1. Preface zabbix, as a free open-source monitoring software, is increasingly popular among it o & M personnel for its ease of configuration management and visualized views,