NAV: SLTechnology News&Howtos > Database >

• 

  Database SQL optimization

  One: optimization description A: there is data showing that the maximum waiting time that users can bear is 8 seconds. There are many database optimization strategies, and at the beginning of the design, the establishment of a good data structure is very important for later performance optimization. Because the database structure is the cornerstone of the system, the foundation can not be laid well, and all kinds of optimization strategies can not be used.

  2022-06-01 09:38:05 Views: 271
• 

  Index series eight-- the ordering of index characteristics is difficult to optimize union

  -UNION is the drop table T1 purge;create table T1 as select * from dba_objects where object_id is to be sorted

  2022-06-01 09:38:05 Views: 244
• 

  11g rman configuration catalog

  1. The official document https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcatdb.htm#BRADV896562, the configuration steps are as follows-create tablespace c

  2022-06-01 09:38:01 Views: 299
• 

  Oracle Goldengate installation configuration

  The first step is to download the installation package for ogg. The download address is as follows: http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html will be installed on the

  2022-06-01 09:38:01 Views: 224
• 

  Case simulation of misconfiguration of Oracle pfile UNDOTBS parameters

  Simulation of the cases in Chapter 2.3.1 of "getting started with DBA, Advanced and Diagnostic cases" [oracle@021Y-SH-BKAP dbs] $vi initorcl.oraorcl.__db_cache_size=2885681

  2022-06-01 09:38:01 Views: 218
• 

  Find the recently modified SP

  Find the recently modified SP and expand "Programmability" in the corresponding database in SSMS, and click "Stored Procedures". Select "View", "Object Explorer Details" in the menu bar

  2022-06-01 09:37:52 Views: 264
• 

  JDK Source Code Reading-3-Design pattern-structural pattern

  1. Adapter (Adapter) java.util.Arrays$ArrayList (java.util.Arrays#asList ()); note here that ArrayList is the inner class of Arrays.

  2022-06-01 09:37:39 Views: 239
• 

  Table space problem-shrinking space method: lookup of tables in table space: extended table space

  The method of shrinking space: I. Do not delete data, shrink the data file size of the tablespace, and free up disk space to query the tablespace select OWNER,SEGMENT_NAME,TABLESPACE_NAME,BYTES/1024/10 where the table is located.

  2022-06-01 09:37:30 Views: 209
• 

  Solving the puzzle of DBA: evaluation and Optimization means of Database carrying capacity

  As a DBA, it is sometimes challenged to ask questions like this: if the size of the existing business increases tenfold or 100x, can the database support it? We'll make a big push next month. Is there a problem with the database? Plan to do the de-O work, keep the code logic unchanged, and switch the database from Oracle to MyS.

  2022-06-01 09:37:18 Views: 210
• 

  GoldenGate installation and patch installation

  This article describes the basic installation of OGG and the installation of OGG patches. 1. GoldenGate installation 1.1. Download the new version of GoldenGate through the official website of ORACLE, you can download Oracle GoldenGate D directly

  2022-06-01 09:37:17 Views: 214
• 

  [MySQL] [highly available] use of purge_relay_logs tools

  [MySQL] [High availability] background of purge_relay_logs tool: in the process of switching between MHA high availability architecture, ​ mainly depends on comparing the old and new relay log files of each instance, and selecting the latest relay log.

  2022-06-01 09:37:17 Views: 234
• 

  ISCSI based on user authentication and iSCSI creation based on configuration file

  Continue the above-> http://11107124.blog.51cto.com/11097124/1884645 before discovery's target information will be saved here (discovery's database) [roo

  2022-06-01 09:37:17 Views: 272
• 

  Oracle12c manually creates pdb

  When container database and plug-in database are used to store data in Oracle12c, with the increase of traffic, sub-database is adopted to store data, which is distributed to different storage devices, which can improve the overall performance. Here's how to create a pdb using a sql script: create a pdb database correspondence

  2022-06-01 09:37:13 Views: 222
• 

  The structure of SQL Server insider data rows

  The data rows of the table have the general structure shown in figure 6-5 (as long as the data is stored in an uncompressed form). This format is called the FixedVar format because data for all fixed-length columns is stored first, followed by data for all variable-length columns. Table 6-7 shows the storage in each

  2022-06-01 09:37:08 Views: 232
• 

  Openldap 2.4dual master MirrorMode configuration

  Although the master-slave configuration provides high availability of ldap, when the Master node dies, some configuration is needed to allow the Slave node to take over the work of the master node, but in the case of multi-master, the master node can be replaced directly, and even keepalive can be used.

  2022-06-01 09:37:04 Views: 233
• 

  Mongodb user Rights Management

  1. Add a management account mongo-- host 127.0.0.1-- port 27000use admindb.addUser ('admin','123456') 2, and log in to mongo-- h through the account.

  2022-06-01 09:37:04 Views: 274
• 

  MongoDB replication set Management (subsequent)

  Introduction: replica set: 1: standard node: participate in primary election 2: passive node: can only become secend, not participate in election 3: arbitration node: responsible for voting, no data storage experimental environment: 2 standard nodes, 1 passive node, 1 arbitration point specific experimental steps: (front

  2022-06-01 09:37:04 Views: 263
• 

  SSH configure remote management host

  Remote management has telnet plaintext transmission tcp23 temporary service ssh secret transmission tcp22 system service security ssh-> opensshyum-y install opensshservice sshd

  2022-06-01 09:37:04 Views: 213
• 

  On prebuilt table of Oracle materialized view

  The advantage of creating a materialized view to add on prebuilt table is that under the schema of the created materialized view, there should be a table with the same name as the materialized view, and if the materialized view is updated, the table with the same name will also be updated. When the materialized view is deleted, the table with the same name is not deleted and the base table is retained.

  2022-06-01 09:37:03 Views: 264
• 

  Problem: only_full_group_by

  Cause of error: mysql version 5.7 and above default sql configuration: sql_mode contains "ONLY_FULL_GROUP_BY" this configuration strictly complies with the "SQL92 standard". So the upgrade of the database may lead to

  2022-06-01 09:37:03 Views: 221