NAV: SLTechnology News&Howtos > Database >

• 

  Oracle Study-- resmgr:cpu quantum wait event

  Oracle Study-- resmgr:cpu quantum wait event appears "resmgr:cpu quantum" wait event in AWR Report: "resmgr:cpu quantum" wait event

  2022-06-01 13:49:44 Views: 294
• 

  Query and assignment of multiple instances in Oracle Database

  Recently, during the inspection of a certain system in the unit, it was found that there were many instances in the database, and when querying one of the instances directly, the display failed. Later, it is found that it needs to be specified to modify the environment variable. The specific ideas are as follows: 1. Log in to the server first, ps-ef | grep smon

  2022-06-01 13:49:38 Views: 237
• 

  Advanced MySQL Database (VI)-Index

  MySQL Database Advanced (6)-Index 1, Index introduction 1, Index introduction Index (Index) are data structures that help MySQL obtain data efficiently. In MySQL, the index belongs to the concept of storage engine level, and different storage engines implement the index in different ways. M

  2022-06-01 13:49:38 Views: 293
• 

  View temporary tablespace usage and how to extend tablespace temp

  SELECT D. TABLESPACENAMEMagna space "SUM_SPACE (M)", BLOCKS SUM_BLOCKS,USED_SPACE "USED_SPACE (M)", ROUND (NVL)

  2022-06-01 13:49:37 Views: 252
• 

  ORACLE 11G (bare device dataguard)

  Add standby log main library parameter file: CRM.__db_cache_size=8254390272CRM.__java_pool_size=33554432CRM.__large_pool_size

  2022-06-01 13:49:37 Views: 227
• 

  Oracle RAC reports to ORA-09925 unable to create audit-- no space under Solaris

  Oracle RAC report under Solaris ORA-09925 unable to create audit-- no space received a developer response, sqlplus or developer tools log in to the database to report an error

  2022-06-01 13:49:34 Views: 255
• 

  The case of Oracle Study-RMAN backup configuration parameters

  Oracle Study case-- RMAN backup configuration parameter 1, PARALLELISM We can also use the parallelism parameter to specify how many channels are created "automatically" at the same time: RMAN > configure devic

  2022-06-01 13:49:34 Views: 277
• 

  Mongo Advanced query

  1. Conditional operator (1) conditional operator db.collection.find ({"field": {$gt: value}}); / / greater than: field > valuedb.collection.

  2022-06-01 13:49:34 Views: 232
• 

  The growth path of DBA-mysql master-slave synchronization, separation of reading and writing

  Master-slave synchronization what is master-slave synchronization: let other database servers automatically synchronize data on the database server that is being served. 1 add authorized user mysql > grant replication slave on *. * to slave

  2022-06-01 13:49:33 Views: 289
• 

  Oracle memory Architecture (1)

  When the oracle database instance starts, the oracle database allocates a memory area and starts the background process. The information stored in the memory area is as follows: the information of each connection session in the program code, including the information needed during the execution of the currently inactive session program, such as

  2022-06-01 13:49:29 Views: 290
• 

  ORA-00060 Deadlock detected

  There are already many problems to be solved on the Internet. I also met one that is quite special. Data found that there is a deadlock phenomenon, and very serious, there are more than 3G deadlock logs per hour. Later, it was found that the difference between the system time and the program time was more than 10 hours. Therefore, the question can be solved by setting the time to be consistent with the system time by command.

  2022-06-01 13:49:28 Views: 208
• 

  A case study of troublesome Aborted alarm in MySQL

  MySQL's analysis of aborted alarm logs Part1: written in the error log of MySQL, we will often see some kinds of Aborted connection errors. This article will make a preliminary study of this kind of errors.

  2022-06-01 13:49:28 Views: 210
• 

  Authority Management of 02-influxdb

  01-InfluxDB introduction Please add a link to describe the rights management of 02-influxdb backup and recovery introduction in fact, the permission syntax of influxdb is basically similar to mysql, after reading it, you can basically understand it; create authorization syntax with

  2022-06-01 13:49:28 Views: 248
• 

  Non-relational data NoSQL technology

  NoSQL (NoSQL = Not Only SQL), which means anti-SQL movement, is a new revolutionary movement of database. It was suggested in the early days that the trend became higher and higher in 2009. Advocates of NoSQL advocate the use of non-relational data storage

  2022-06-01 13:49:25 Views: 211
• 

  MySQL 5.6reference manual

  MySQL 5.6 Reference ManualMySQL 5.6 reference manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide contains MySQLN

  2022-06-01 13:49:24 Views: 276
• 

  Introduction to DML, DDL and DCL languages

  What is the introduction of DML, DDL, and DCL? DML: data manipulation language includes addition, deletion, modification and search (INSERT,DELETE,UPDATE,SELECT), a language for manipulating data. The operating unit of DML is RECORD. INSERT

  2022-06-01 13:49:24 Views: 267
• 

  The solution to the disappearance of mysql database caused by an error in modifying root in mysql

  An error occurred while updating the ROOT password today. Update user set password='123456' where user = "root" is wrong. It should be update user set password.

  2022-06-01 13:49:24 Views: 266
• 

  PMM Monitoring MySQL

  1. PMM-SERVER1. Install dockeryum install-y docker-io2. Pull pmm-server image docker pull percona/pmm-server:lates

  2022-06-01 13:49:24 Views: 262
• 

  Performance Optimization of Oracle Learning (12) Partition Table

  First, partitioning concept Oracle allows tables, indexes, indexes to organize tables into smaller slices, each of which we call partitions. The partition has its own name and storage parameters. As shown below: each row of data can only belong to one partition, and the partition key determines which partition the data row belongs to. The partition key consists of one or more

  2022-06-01 13:49:05 Views: 255
• 

  Data pump of Oracle imports / exports data

  Used to use imp/exp to import and export data, now let's do a data pump import and export method. It is needless to say that it has more advantages than imp/exp-faster! But unfortunately, I made a mistake when exporting the data. Damn it, this is particularly embarrassing. So, God,

  2022-06-01 13:48:45 Views: 272