NAV: SLTechnology News&Howtos > Database >

• 

  Too many broken files in ORACLE audit directory ORA09925 caused sqlplus to be unable to log in to the console

  Today, ORACLE database 11.2.0.4 for linux maintenance, single instance oracle cluster database, ASM instance is down, database instance is down. Grid or oracle using sqlplus / as sysasm

  2022-06-01 07:49:57 Views: 217
• 

  Operating system error 5: access denied

  SQLServer2012 attachment data is read-only mode, modified to read-write mode error report: modify the permissions of data files and log files: no longer report errors.

  2022-06-01 07:49:51 Views: 252
• 

  In-depth understanding of the locking mechanism of SQL Server 2008

  Compared to SQL Server 2005, such as snapshot isolation and improved lock and deadlock monitoring, SQL Server 2008 does not make any significant changes in the behavior and characteristics of locks. A major new feature introduced by SQL Server 2008

  2022-06-01 07:49:44 Views: 273
• 

  SQL is dead, but SQL will last forever!

  In the 47 years since the introduction of SQL, it has experienced the birth and demise of many databases, as well as the birth and demise of many data processing methods. 47 years ago, two young IBM researchers proposed a new language in the database, which is a relational language.

  2022-06-01 07:49:38 Views: 238
• 

  PostgreSQL DBA 97-System Conf (huge_pages)

  PostgreSQL provides the parameter huge_pages to use the huge pages of OS. The default is try, which can be used as soon as it can be used. If it is not used, it will not be used. One of the reasons for using HUGE PAGE is that HUGE PAGE is resident in memory, no

  2022-06-01 07:49:24 Views: 284
• 

  Install mongodb under linux

  [root@sc-wjg ~] # uname-aLinux sc-wjg 2.6.32-358.23.2.el6.x86_64 # 1 SMP Wed Oct 16 18:37:12 UTC 2013

  2022-06-01 07:49:24 Views: 234
• 

  Some basic operations of MongoDB

  This article mainly explains some basic operations of MongoDB, the content is clear and clear, interested friends can learn, I believe it will be helpful after reading. Introduction to MongoDB: MongoDB is an open source database system written by C++ language. Mo

  2022-06-01 07:49:24 Views: 300
• 

  How to use mysql cursors

  This article mainly shows you how to use mysql cursors, the content is easy to understand, I hope you can learn, after learning there will be gains, the following let the editor to take a look at it. What is a cursor: if you have seen the mysql function before, you will find that returns cannot be used.

  2022-06-01 07:49:20 Views: 236
• 

  Xtrabackup backup to a remote server

  1. Set up ssh login-free ssh-keygenssh-copy-id-I ~ /. Ssh/id_rsa.pub root@xxx.xxx.xxx.xxx to verify ssh (successful if date of occurrence) ssh xxx.xxx.x

  2022-06-01 07:49:11 Views: 251
• 

  Usage of mysql transaction management

  This article mainly explains the use of mysql transaction management, the content is clear, interested friends can learn, I believe it will be helpful after reading. What is transaction management: a series of operations to be performed can be called transactions, and transaction management is to manage these operations.

  2022-06-01 07:49:11 Views: 211
• 

  [analysis function] over partition by

  1. The difference between over partition by and group by-over partition by can display summary data and source data in a row, for example: query the salary of each employee and the maximum salary of the department-group b

  2022-06-01 07:49:11 Views: 262
• 

  Essays: what is MYSQL_BIN_LOG::COND_done

  First, what is the question? welcome to follow my "in-depth understanding of MySQL Master and Slave principle 32", as follows: if the picture can not be displayed, please see the following link: https://www.jianshu.com/p/d636215d767f 2. Find the whole position of influence.

  2022-06-01 07:49:10 Views: 302
• 

  Interpretation of PostgreSQL Source Code-WAL#7 (Insert&WAL-XLogRe...)

  This section focuses on tracking and analyzing the processing of FPW (full-page-write) in the XLogRecordAssemble function. Global static variables of data structure the global variables used by XLogRecordAssemble include hdr_

  2022-06-01 07:49:10 Views: 240
• 

  Summary description of Last_SQL_Errno error codes for MySQL master-slave replication

  1005: failed to create table 1006: failed to create database 1007: database already exists, failed to create database 1008: database does not exist, database deletion failed 1009: database file cannot be deleted resulting in database deletion failure 1010: data directory cannot be deleted resulting in deletion

  2022-06-01 07:49:10 Views: 251
• 

  Basic knowledge of MHA

  Environment: manager: 10.1.99.213 (install mha manager mha node package) installation depends on the machine's corresponding version of the epel source master: 10.1.99.216 (install mysql and

  2022-06-01 07:49:09 Views: 229
• 

  How to install SQLServer2019 for CentOS8

  What the editor wants to share with you this time is how to install SQLServer2019 in CentOS8. The article is rich in content. Interested friends can learn about it. I hope you can get something after reading this article. 1. Download Microsoft SQL Se

  2022-06-01 07:49:09 Views: 286
• 

  Analysis of Oracle table table and index index, index reconstruction and import and export of statistical information

  1. Parse tables and indexes (analyze does not rebuild indexes) analyze table tablename compute statistics is equivalent to analyze table tablename comput

  2022-06-01 07:49:09 Views: 288
• 

  PostgreSQL Source Code interpretation (91)-query statement # 76 (ExecHashJoin function # 2)

  This section is the second part of the introduction of ExecHashJoin functions, which mainly introduces the implementation logic of other functions that depend on ExecHashJoin, including ExecHashTableCreate and ExecChooseHashTableSiz.

  2022-06-01 07:49:08 Views: 211
• 

  PostgreSQL source code interpretation (167)-query # 87 (basics-parser Bison)

  Enter a SQL statement, how does PostgreSQL parse the input SQL and identify the SQL type and base table / field information? The next few sections will be analyzed one by one. This section introduces the open source tool parser Bison. 1. The basic concept of Bison Bison is

  2022-06-01 07:49:08 Views: 222
• 

  The space limit that exceeds the tablespace occurs when the user uses the tablespace quota without restriction and the tablespace has enough space.

  When a friend's production database inserts data into a specific table, the data Times exceeds the space limit of the tablespace data. For example, under execution, view the tablespace quota information used by the user, and check the tablespace quota used by the user. It is found that there is no limit, because the max_bytes is-1SQL > sele.

  2022-06-01 07:49:08 Views: 285