NAV: SLTechnology News&Howtos > Database >

• 

  The use of reverse function Index of Oracle Operation and maintenance case

  I would like to share with you a case of sql optimization encountered by our group. The case is not the database I am responsible for. I am just a porter. This case occurred last year, and it was found that the reason was the rise of nets host cpu, and the development operation found DA. Then DA analyzed the situation and finally located

  2022-06-01 16:08:45 Views: 239
• 

  Oracle JRockit Mission Control

  Used to analyze jrockit virtual machine performance, can real-time monitor performance, analyze memory usage and so on, the current version has very detailed help, but also TMD Chinese, thanks to Oracle. Server-side configuration is simple, that is to configure JMX1. Prepare .access and .pa for access control

  2022-06-01 16:08:38 Views: 243
• 

  Python script backs up MySQL database by table

  Script function: 1. Automatically create backup directory 2. Automatically back up each table in the database and compress 3. Backup results, email to notify the contact person 4. Script content #! / usr/bin/env python#-- *-- coding:UTF-8-- *-

  2022-06-01 16:08:38 Views: 265
• 

  Detailed explanation of sqlserver2012 installation

  Installation environment: system: Windows 2012 R2 Datacenter database: SQL_Svr_Enterprise_Edition_2012_w_SP1 start installation: 1, double-click setup.exe2, install, click

  2022-06-01 16:08:08 Views: 249
• 

  Export the specified field of mongodb data, and then import the specified field into the mysql instance and solve related problems

  Requirements: export the specified fields of mongodb data, and then import the specified fields into the mysql table directly above. Finally, you will post several problems and solutions, so that similar problems can be quickly solved (the specific usage of the commands used during this period is not described in detail in this article) will mo

  2022-06-01 16:07:43 Views: 299
• 

  Use Auxiliary to do ASM migration cases.

  Use the auxiliary library (Auxiliary) to do the ASM migration case system environment: operating system: RedHat EL55Oracle: Oracle 10gR2 establishes ASM migration through the auxiliary library, which can easily migrate the storage of the file system off-machine.

  2022-06-01 16:07:43 Views: 287
• 

  Mysql architecture

  Mysql architecture connection processing, authorization authentication, security layer 2, most of the core service functions of MySQL are at this layer, query parsing, analysis, optimization, caching and all built-in functions including encryption functions, all cross-storage engine functions are implemented at this layer: stored procedures, triggers, view

  2022-06-01 16:07:35 Views: 203
• 

  The most efficient cluster in LVS+Keepalived (actual combat)

  LVS+Keepalived Cluster Environment preparation: DR1 Master: 192.168.100.101 CentOS 7-2DR2 backup: 192.168.100.102 Murray-> CentOS 7-3web1:19

  2022-06-01 16:07:35 Views: 227
• 

  Oracle creates tablespaces

  Drop tablespace qb including contents and datafiles;DROP TABLESPACE TJLGL INCLUDING CONTENTS AND DAT

  2022-06-01 16:07:34 Views: 200
• 

  Detailed explanation of zabbix Monitoring MySQL

  Note: lab environment CentOS Linux release 7.0.1406 (Core) [root@localhost scripts] # mysql-vWelcome to the MariaD

  2022-06-01 16:07:30 Views: 241
• 

  Resolution of an archiving failure (ORA-00257 error)

  Problem description: a platform, today suddenly found that everyone can log on to the platform, the previous data can also be seen, but can not enter new data. Read the alarm log and found the following error message: ORA-00257: archiver error. Connect intern

  2022-06-01 16:07:30 Views: 289
• 

  Oracle SQL execution process

  1.sql execution process 1 > parsing (judging whether the object exists, whether it has permission to query, semantic parsing, checking whether there is the same SQL in the cache, etc.) 2 > optimization (CBO determines the optimization mode, determines the access path, connection order, and estimates the cost of various ways through many comprehensive factors in the process.

  2022-06-01 16:07:27 Views: 214
• 

  Add data files to the tablespace and store them in ASM

  * * the instance name of 10.1.80.174 is controlled by PGJT2, and the tablespace ODS is full. Apply for additional data files. Col tablespace_name for a15select d.tablespace_name

  2022-06-01 16:07:26 Views: 269
• 

  Oracle modifies user name

  1. Change the test user name to test1 2. Step 1: for all versions of select user#,name from user$ where name='TEST';update user$ set na

  2022-06-01 16:07:26 Views: 245
• 

  Steps to safely stop Oracle database under a large amount of data

  Recently, we have obtained a large amount of test data and found that under normal circumstances, as long as shutdown immediate, we can stop the database, but for the production system, the amount of data running is relatively large, and the redolog has hundreds of megabytes, so the number of shutdown at this time

  2022-06-01 16:07:26 Views: 245
• 

  SQL tables with multiple primary keys, when there are duplicates in the inserted data, query the duplicate values of the data?

  SQL tables with multiple primary keys will prompt an error that cannot be inserted in violation of the primary key constraint when the inserted data is duplicated. So, how do I find the duplicate value of the inserted data? Solution: use group by to assume that there is a table # a with saleid,vendorid,comid,pr

  2022-06-01 16:07:17 Views: 306
• 

  Linux system Centos7 yum command to install MySQL5.6 online

  Currently, there is no mysql in Centos7's yum source, so you can install it directly. I used MariaDB instead. Then if we want to install the MySQL database, we can use the following method # wget http://dev.mysql.com/get/

  2022-06-01 16:07:17 Views: 238
• 

  Log types in MySQL (2)-General query log

  Introduction General query log records the connection and disconnection of the client, as well as every SQL statement sent from the client. The log content format General query log can be recorded in a file or in a table in the following format: in the file

  2022-06-01 16:07:17 Views: 233
• 

  TNS-12535: TNS:operation timed out (WARNING: inbound connection timed out (ORA-3136))

  Cause of problem: Fatal NI connect error 12170.VERSION INFORMATION:TNS for Linux: Version 11.2.0.3.0-Production

  2022-06-01 16:07:17 Views: 310
• 

  Oracle data Foundation (3)

  one。 View, sequence, indexed view 1. What is a VIEW, also known as a virtual table, is a logical representation of a set of data the view corresponds to a SELECT statement, and the result set is given a name, that is, the view name view itself does not contain any data, it only contains mapping to the base table

  2022-06-01 16:07:16 Views: 229