NAV: SLTechnology News&Howtos > Database >

• 

  Rman-- basic command

  RMAN basic command (1) start and shut down database RMAN > shutdown immediateRMAN > startup (2) execute operating system command RMAN > host;// exit exit (3) execute SQL statement RMAN >

  2022-06-01 07:49:03 Views: 228
• 

  What tools must be installed after DBA changes to a new computer?

  What tools must be installed after DBA changes to a new computer? Recently changed to a new computer, as a DBA, which tools need to be installed? Which tools are installed is related to your specific company and position, as well as the direction in which you are learning and planning to learn. One: Oracle database 1 SQL Deve

  2022-06-01 07:49:03 Views: 218
• 

  SQL Server under Linux does not support linked servers with other types of data sources.

  Customer requirements: a Ubuntu server, install SQL Server 2017 database, as an intermediate server, through the SQL Server link server way, connect the relevant databases of various business systems. Problem: there is a system whose database uses Ora

  2022-06-01 07:49:02 Views: 245
• 

  Oracle RPM package installation Oracle19c

  RPM package installation Oracle19c A description 1.1 Oracle operating system requirements under Linux: Oracle Linux 8.1 with the Unbreakable Enterprise Kernel 6

  2022-06-01 07:48:45 Views: 279
• 

  High ratio of rows returned to index

  In MySQL, the number of rows returned by the query exceeds 20% of the total number of rows, and the execution plan will not take the index. Let's look at an example to query information with an id greater than 1. Click (here) to collapse or open mysql > explain select * from test0

  2022-06-01 07:48:45 Views: 254
• 

  Basic usage of merge into

  Because merge into is rarely used normally, but this time it is used to insert and update records, so simply write down the most basic usage. The example here is to update the value count of the eligible data in a table. If you find a record that meets the ID condition, add 1 to its value field.

  2022-06-01 07:48:44 Views: 259
• 

  My set of more comprehensive oracle database monitoring and management scripts

  To introduce a set of oracle database monitoring management script the script for oracle monitoring is relatively comprehensive, easy to use, they can also expand their own functions on the basis of the script. Directory installation monitoring script configuration database connection information window operating system li

  2022-06-01 07:48:44 Views: 250
• 

  DB2 HADR performance analysis

  In the HADR monitoring of DB2 database, it is found that for a certain period of time every day, many applications are in commit active state, which has an impact on application performance. It may be due to two reasons. Which reason is the slow network communication caused by log writing? Talk with surveillance data. Every 5 seconds

  2022-06-01 07:48:44 Views: 235
• 

  Download and install method of Oracle 19C

  1. Download zip package on the official website. two。 Extract to the / usr/local/oracle directory. 3. Create users and user groups / usr/sbin/useradd-u 600 oracle/ / user group oracle/usr/sbin/

  2022-06-01 07:48:44 Views: 281
• 

  Oracle audit

  Summary: the database audit function is the function provided by oracle itself to record database operations. Oracle audit sub-standard audit and fine-grained audit (FGA) can be classified into oracle audit sub-standard audit and fine-grained audit (FGA), such as audit permission call record, user's oracle operation record, query operation record and so on. Standard

  2022-06-01 07:48:32 Views: 251
• 

  Linux openfiles modification

  There are two main changes: one is: / etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofi

  2022-06-01 07:48:32 Views: 231
• 

  Make a note of the exception that the root directory of the production MySQL server is full-- DB temporary table usage exception

  The abnormal growth of tmp space indicates that the author: sylar all rights reserved. [the article is allowed to be reprinted, but the source address must be indicated in the form of a link, otherwise legal liability will be investigated.] First, background note recently zabbix always has the following alarm information: second, problem analysis according to the zabbix alarm, query immediately

  2022-06-01 07:48:32 Views: 209
• 

  MySQL server parameter description and view setting method

  View parameters: SHOW VARIABLES; setting parameters: SET GLOBAL parameter name = value; if you set the maximum number of database connections is: SET GLOBAL max_connections=1000. Use shell > m

  2022-06-01 07:48:32 Views: 294
• 

  Interpretation of PostgreSQL Source Code (130)-MVCC#14 (vacuum procedure-lazy_scan_heap function)

  This section briefly introduces the processing flow of manual vacuum execution by PostgreSQL, and mainly analyzes ExecVacuum- > vacuum- > vacuum_rel- > heap_vacuum_rel- > lazy_scan_hea.

  2022-06-01 07:48:31 Views: 295
• 

  MySQL 5.7Database parameter optimization

  Connection related parameter max_connections: the maximum number of concurrent connections allowed by the client. The default value is 151.This parameter is generally set to 300-1000max_connect_errors: if the client attempts to connect more than this number of errors

  2022-06-01 07:48:31 Views: 246
• 

  Suggestions for writing MySQL DML sentences

  The DML statement does not allow @ number to replace the unreasonable field name: UPDATE table_name SET @ 1=NOW () WHERE @ 2room1; the correct way to write it: UPDATE table_name SE

  2022-06-01 07:48:31 Views: 230
• 

  Download conference materials | what should developers pay attention to under the hot technology tuyere?

  On April 16th, the Oracle Code 2019 developer Conference ended successfully in Shenzhen. Nearly 1000 developers gathered at this year's conference, and 450000 programmers watched the live broadcast online at the same time. On-site, technical experts from home and abroad, around cloud computing, autonomous database, Io

  2022-06-01 07:48:16 Views: 267
• 

  Analysis of automatic restart process of 12c DG broker DMON

  First, knowledge points 1. It is strongly recommended that you use broker to manage dataguard. To know where the 2.broker log is, reading the log is the first step in learning. 3. The architecture needs to look at the official documentation. Second, the testing process 1. View the DMON process $ps-ef

  2022-06-01 07:48:14 Views: 203
• 

  MyISAM table

  1. Transaction MyISAM is not supported: locks the entire table, locking all tables instead of rows. When reading data, shared locks (read locks) are available on all tables, and each connection does not interfere with each other. When writing, or an exclusive lock, the entire table is locked, while other connection requests read

  2022-06-01 07:48:14 Views: 277
• 

  Summary and induction of common performance indicators of MYSQL

  (1) QPS (query per second) QPS = Questions (or Queries) / uptimemysql > show global status like 'Question%';mysq

  2022-06-01 07:48:13 Views: 273