NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 11g uses the exp command to export solutions for incomplete tables

  Today, I am migrating the database from 11.2.0.1 to 11.2.0.4. I used exp to export all the objects under a user. When I did imp import, I found that the tables were much less. After reading the log, I found that some empty tables were not exported. I checked it on the Internet and found that it is a new feature in 11G.

  2022-06-01 06:21:07 Views: 223
• 

  Free buffer waits of oracle waiting for event

  1. When will free buffer waits happen? In a nutshell, this wait occurs when you need to look for available blocks in buffer cache but cannot find them. Reasons for finding available blocks include reading blocks into memory or constructing CR blocks. S

  2022-06-01 06:21:07 Views: 208
• 

  Detailed explanation of MySQL execution Plan EXPLAIN

  This article is based on MySQL 5.7Reference Manual as the main axis (translation & take its essence) and combined with the length of hundreds of online articles, because the author's level is limited, please forgive me if there are any inaccuracies in the article, if reprinted, please indicate the source of the original text guocun09-Oram.

  2022-06-01 06:21:07 Views: 271
• 

  MySQL master-slave synchronous report error 1236

  Preface: as a database administrator of MySQL, he often encounters the problem of master-slave synchronization, and the more common one is the error report of error 1236. Just recently encountered this error, the following is the arrangement of the document; [2] problem description 1, environmental information mysql version: 5.7

  2022-06-01 06:21:06 Views: 250
• 

  Talking about the transaction isolation level in MySQL (R11 note 86th day)

  I wrote an article about affairs (1) before, which can be regarded as a basic understanding of transactions. Today, let's briefly summarize the isolation level of transactions. Although it is an old knowledge point, it is worth reviewing it. These two kinds of transaction isolation levels are basically set in MySQL, and the default RR (Repeat)

  2022-06-01 06:20:48 Views: 282
• 

  Easily master the way of database management-- the third part of operation and maintenance inspection (structure design)

  In the preface, daily inspection is an important step in database management and maintenance, and it is necessary to register the date and result of each inspection, and a patrol report may be needed at the same time. The purpose of this series is to solve some common problems: do not know what to patrol, do not know how to facilitate the physical examination machine, there are too many physical examination troubles.

  2022-06-01 06:20:48 Views: 276
• 

  Db file sequential read and its optimization

  Db file sequential read: direct path reading. The official explanation is as follows: This event signifies that the user process is reading a buffer

  2022-06-01 06:20:44 Views: 245
• 

  Oracle RAC+DG environment building (CentOS 7+Oracle 12C) (5) configure shared storage

  1. Add disk on rac01 (1) add controller (2) add disk, set to fixed size (3) set to shareable 2, rac02,rac03,rac04 add shared disk created above 3, disk partition pair / dev/sdb / dev in turn

  2022-06-01 06:20:35 Views: 202
• 

  Tablespace tablespace deletion

  1. Normal tablespace deletion: Oracle 11g delete tablespace syntax description: DROP TABLESPACE tablespace_name [including contents [and datafiles]

  2022-06-01 06:20:35 Views: 228
• 

  Table reorganization with more fragments

  First of all, query out the tables that need to be reorganized in the database: SELECT d.namephery. Bid _

  2022-06-01 06:20:34 Views: 235
• 

  Get the maximum performance from MySQL-turn

  A reference for optimizing MySQL. Transferred from the network. [@ more@] Optimization is a complex task because it ultimately requires an understanding of the entire system. When it is possible to do some local optimization with a little knowledge of your system / application, the more you want to optimize your system, the more you must know about it.

  2022-06-01 06:20:34 Views: 298
• 

  2011-11-2 Vernier and Pipeline function

  Http://www.itpub.net/thread-1499223-11-1.html105 Building I created this table and filled in the data: CREATE TABLE plch_parts (partnum)

  2022-06-01 06:20:33 Views: 236
• 

  [Zookeeper] zookeeper cluster installation

  Single node installation reference: http://blog.sina.com.cn/s/blog_6f6bc30e0101pb13.htmlzookeeper cluster installation notes: 1. Note that / etc/hosts needs to be configured 2. Note

  2022-06-01 06:20:03 Views: 262
• 

  Understand the Oracle execution plan

  One: what is the Oracle implementation plan? An execution plan is a description of the execution process or access path of a query statement in Oracle 2: how to view the Oracle execution plan? Because I have been using PLSQL remotely connected company database, so here is PLSQL as an example

  2022-06-01 06:20:03 Views: 265
• 

  What's New in MySQL 8.0-Invisible Index

  Official documentation: https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.htmlMySQL 8.0 invisible index Learning MySQL

  2022-06-01 06:19:54 Views: 265
• 

  MongoDB development specification

  one。 Naming convention 1.mongodb version selection: the default newly installed database uses MongoDB 3.x Community Edition. Recommendation 3.2.10 # 2. Database design specification database name can be any UTF-8 string that satisfies the following conditions: (1) No word except "_" can appear.

  2022-06-01 06:19:49 Views: 213
• 

  Connect to the SAP HANA database using ABAP (ADBC) and Java (JDBC)

  Maintain a record in the table DBCON that points to the HANA database. Enter the hostname and port number of the HANA database in the con_ENV. Such as vmXXXX:30015DATA: ls_new TYPE DBCON.ls_new-con_n

  2022-06-01 06:19:49 Views: 213
• 

  18C RAC DBCA build library cannot find ASM disk group

  When using dbca to create a database for Oracle 18C RAC in Oracle Linux 7.1, the ASM disk group was not found, while grid users using asmca could see the ASM disk group. Solution 1. Check the creation of ASM disk devices

  2022-06-01 06:19:49 Views: 208
• 

  Plug-in cx_Oracle installation for python connection to Oracle

  Installation of cx_Oracle notes: first of all, when installing the configuration, you must grasp one point, that is, the version is consistent! Including: system version, python version, oracle client version, cx_Oracle version, and then easy to install and configure! If Pyt is already installed

  2022-06-01 06:19:46 Views: 248
• 

  [learning] SQL Basics-012-Lock

  1. Type exclusive lock: record, row level shared lock: table level, prevent the use of DDL to modify table structure shared lock [S lock], also known as read lock. If transaction T adds S lock to data object A, transaction T can read A but cannot modify A, other transactions can only add S lock to A, but not X lock until T is released.

  2022-06-01 06:19:46 Views: 294