Database Administrator

Database Version: 11.2.0.3 Symptom: When I started a test database today, I found that the database cannot be open. The error is as follows: ERROR at line 1:ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [],

Background Due to the influence of traditional RDB, most developers may have a mindset for designing database tables. In the context of cloud computing and big data, RDBMS is approaching the limit, and KV storage will attract more and more attention.

Recently, MySQL installed on Mac is not used for a period of time. When I tried to use it, I found that I forgot my password. Fortunately, google soon found a solution. At that time, no relevant records were made. Today, we encountered the same

During the daily system check, I checked the database tablespace usage through the Oracle Enterprise Manager Console, and found that the system tablespace usage is 100%, and the temporary tablespace corresponding to each user is the system

I. Hive join Optimization1. we try to place small tables on the left of join. We use Hive-0.90, so it is automatically converted. This means that small tables are automatically loaded into the memory and map side join is executed (with good

After 10 Gb of Oracle, two features OFA and OMF are introduced in terms of directory structure and file management. OFA (Oracle Flexiable Architecture) is a feature of directory structure constraints. The directory structure distribution of

System Environment: Operating System: AIX5300-08 Oracle software: Oracle 10g (64-bit) Installing Oracle 11g R2 Based on IBM AIX Add data files (bare devices) to the tablespace in AIX) AIX6.1 install Oracle 11g R2 Install Oracle 10201 on AIX AIX +

Introduction: The use of MyBatis in the project, a more annoying problem is unable to see the specific execution of the SQL, So, find the Log4jdbc-log4j2. This is a jdbc-level listening tool that can listen for the main operations on the database,

The TPC (Tracsaction Processing Performance councer) Transaction Processing Performance Association is a non-profit organization that evaluates the Performance of software and hardware in large database systems. TPC-C is developed by the TPC

Write down the basic implementation principle of group by in MySQL. Because group by actually performs sorting operations, and compared with order by, group by mainly only performs grouping operations after sorting. Of course, if other Aggregate

Lab requirement: Configure mysql-mmm to achieve high availability of mysql MySQL-MMM for MySQL High Availability MySQL-MMM switching demonstration Mysql proxy and MySQL-MMM achieve high availability of read/write splitting Restore the MySQL-MMM

8.2 Opening a Standby Database for Read-Only or Read/Write Access8.2 When a standby database is open for read-only access, users can query the standby database but cannot update it. thus, you can reduce the load on the primary database by using the

Oracle databases contain many duplicate items because they do not have any constraints. The question now is how to delete these repeated items. Repeat records only keep one of them. The following table creation statement Create table message_student3

To diagnose the slow running of Oracle, you must first determine which diagnostic information to collect. You can use the following diagnostic methods:1. Is the problem of slow database operation common or occurs at a specific time?If the database

I. Environment Information 1) master database (Single Instance) Host platform: AIX6.1 Database Version: 11.2.0.3 (psu5) 2) slave database (crs deployed) Host platform: AIX6.1 Database Version: 11.2.0.3 (psu5) Ii. Background As the business volume

The MySQL5.6 script is compiled and installed in the source code package. Two MySQL databases are installed on one machine. The port, installation path, and socket file location are specified during compilation. The installed MySQL installation file

When you delete indexes, tables, tablespaces, users, and other database objects or users, you may encounter the following errors: SQL> drop user Oracle cascade; Drop user oracle cascade; * ERROR at line 1: ORA-00604: error occurred at recursive SQL

Commands of the Oracle dump File Include exp/imp and expdp/impdp. For dump files, we cannot extract data directly, but we can extract the corresponding DDL statements from the dump file through relevant parameters. Description of how Oracle extracts

After restarting the server, the user finds that a node in RAC cannot view the RAC status.An error occurred while checking the RAC status../Crs_stat-tCRS-0184: Cannot communicate with the CRS daemoBecause it cannot communicate with crs, check the

I. Introduction PostgreSQL is a very complex object-relational database management system (ORDBMS). It is also currently the most powerful, feature-rich and complex free software database system. Some features are not even available in commercial