NAV: SLTechnology News&Howtos > Database >

• 

  Learning mysql sql sentences (1)

  In order to learn the database, first familiarize yourself with the sql language, and take mysql as an example to start learning! (reference book "mysql database development, optimization, management and maintenance") the following is the execution of sql statements, mainly to build and modify tables: first enter window

  2022-06-01 06:42:12 Views: 269
• 

  Oracle date type comparison and String comparison

  Define table structure: Log table structure: here is varchar for Oracle comparison.

  2022-06-01 06:42:08 Views: 226
• 

  Ant Financial Services Group recruits DBA

  One main responsibility 1. Responsible for the construction of database high availability system, pursuing 100% continuous service availability and second fault recovery ability. two。 Responsible for database cost optimization, through new technologies, new products, new solutions to optimize the performance of the system. 3. Responsible for the construction of database-related process platform and tool products

  2022-06-01 06:42:07 Views: 204
• 

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

  This section provides a brief introduction to the implementation logic of the XLogRecordAssemble function, which assembles XLOG record from registered data and buffers into the XLogRecData chain in preparation for XLOG Record insertion. 1. Data knot

  2022-06-01 06:42:07 Views: 213
• 

  [giant Sequoia Database Sequoiadb] sdb shell command deletes all cata, coord and data nodes under the host

  [detailed description of the problem] 1. A cluster already exists in the SAC interface; 2. Execute a command in sdb shell to delete all cata, coord and data nodes of the host under the cluster. The command is as follows: CataRG.getNode ("host1", "cluster")

  2022-06-01 06:42:07 Views: 273
• 

  Principle and operation of Mongodb log

  Logging principle: WiredTiger uses checkpoints to provide a consistent view of data on disk and allows MongoDB to recover from the previous checkpoint. However, if MongoDB exits unexpectedly between checkpoints, you need to use logging to restore what happened after the last checkpoint

  2022-06-01 06:42:06 Views: 228
• 

  Alibaba MySQL DBA interview questions

  1, the replication principle and process of MySQL (1), ask the basic principle flow, three threads and the relationship between them; (2), ask the consistency delay, data recovery; (3) ask the solution of replication bug encountered by all kinds of work. 2. Myisam and in in MySQL

  2022-06-01 06:42:06 Views: 271
• 

  Invalid ORA-00904:"WM_CONCAT": identifier

  Today, the customer site business dumped me with an error concession, ora-00904: "WM_CONCAT": invalid identifier. A preliminary analysis of the following scenario: the day before yesterday, because the original set of libraries had to be deleted, and their business user A used the set of libraries that they planned to delete, so export user A, guide

  2022-06-01 06:42:06 Views: 248
• 

  Parsing CDS view annotations-@ Environment.systemField

  The following CDS view uses the annotation @ Environment.systemField, defining two parameters # SYSTEM_LANGUAGE and # USER. This view from the CRM material master data of the product header table COMM_

  2022-06-01 06:42:05 Views: 297
• 

  The latest question bank and answer arrangement of OCP certification 052 exam-70

  70 、 Which two are true about space management in tablespaces?A. Free lists are used for managing free

  2022-06-01 06:42:05 Views: 208
• 

  Oracle static snooping

  Oracle static snooping and dynamic snooping I. what is registration? Registration is to register the database as a service with the listener. The client does not need to know the database name and instance name, but only needs to know the service name provided by the database to apply for a connection to the database. This service name may be

  2022-06-01 06:42:05 Views: 264
• 

  Rhel7 installation 11g rac

  Installation walk-through-Oracle Grid/RAC 11.2.0.4 on Oracle Linux 7 (document ID 1951613.1) in this document, 19404

  2022-06-01 06:42:04 Views: 282
• 

  Running Mode Management of informix-online dynamic Server

  Online running status offline:online has no running mode, and shared memory has not been allocated at this time. Initialization:online system initializes and shifts from offline mode to quiescent mode

  2022-06-01 06:41:57 Views: 288
• 

  How to deal with the problem of extremely slow business response caused by frequent changes in ORACLE DML execution plan

  Recently, a very strange thing encountered in oracle rac maintenance is that the business is occasionally extremely slow, but the server load and database load are very low, there are no obvious errors in the database and host logs, and there is no session congestion within the database. This article is hereby recorded

  2022-06-01 06:41:57 Views: 265
• 

  Those things about the database (all practical information)

  When it comes to databases, our first idea is how to optimize and how to make query operations faster. I think the best way is to be as thoughtful as possible from the beginning of database design. If unfortunately it is an old project, we have to start with optimization. Next, I will talk about some of my understanding and experience from design and optimization.

  2022-06-01 06:41:50 Views: 227
• 

  Oracle 11g listens for related files

  [oracle@test admin] $pwd/u01/app/oracle/product/11.2.0/db_1/network/ admin [oracle @ test admin] $cat li

  2022-06-01 06:41:49 Views: 298
• 

  PPT production skills: how to change the color of picture ink arbitrarily in PPT

  The picture that adds ink to the slide will look very good, but sometimes the color of the ink will not match the theme of our slide, so how can we change the color of the picture in the slide? let's learn it together. Https://www.p

  2022-06-01 06:41:46 Views: 274
• 

  Problems installing RAC on linux7

  Requirements for Installing Oracle 11.2.0.4 RDBMS on OL7 or RHEL7 64-bit (x86-64) (Doc ID 1962100.1)

  2022-06-01 06:41:45 Views: 224
• 

  Configure rman to automatically delete applied archive logs

  Configure Rman to Purge Application standby logs.Posted on March 26, 2011 by GaryConfigure RMAN to p

  2022-06-01 06:41:45 Views: 214
• 

  Oracle instance is disabled: SHUTDOWN: waiting for active calls to complete

  Close an instance in RAC to jam SQL > shutdown immediate backend log shows: Fri Aug 10 14:56:16 2018Active call for process 43909332 us

  2022-06-01 06:41:45 Views: 208