NAV: SLTechnology News&Howtos > Database >

• 

  Rookie Learning Linux 078 Notes mysql backup mysqldump

  Rookie Linux 078 Notes mysql backup mysqldump content overview backup types backup tools mysqldump backup and restore MySQL backup and restore backup: copy RAID1,RAID10 guarantee hard

  2022-06-01 08:54:49 Views: 212
• 

  Dataguard oracle Archive Management script

  If database force logging is not enabled in the management part, the standby library will report bad blocks for / * + append * / operation and nologging operation. Table space force logging or database f is recommended.

  2022-06-01 08:54:49 Views: 245
• 

  SQL_TRACE use case

  The main purpose of SQL_TRACE is to track the execution process of SQL and analyze the performance and resource consumption of SQL. It can see how SQL manipulates the data, what wait events are generated during execution, the resource consumption of sql during execution, and the sql

  2022-06-01 08:54:48 Views: 235
• 

  Create 100 tables in batch

  # at work, there is often the need to create n tables named after time or numbers. # here are four commonly used small scripts for creating 100 tables in batches. # result mysql > show tables;+-+ | Tabl

  2022-06-01 08:54:48 Views: 219
• 

  Realizing string concatenation through FOR XML PATH method of SQL Server

  The function of FOR XML PATH is to display the query results in the form of XML, but through FOR XML PATH, we can simplify our query statements and achieve some functions that used to be achieved with the help of functions, such as splicing the query results in the form of strings. 1 、

  2022-06-01 08:54:48 Views: 225
• 

  The solution to the error of ORA-12754 in 18C Library Construction

  [oracle@dg18c ~] $sqlplus / as sysdba SQL > startup nomount;ORA-12754: Feature 'startup' is disabl

  2022-06-01 08:54:48 Views: 255
• 

  Analysis of slow server caused by deletion of MySQL large table

  -Note: when MySQL deletes a table in a production environment, if the table is too large, tens of gigabytes or even hundreds of gigabytes, be careful when deleting it, otherwise it will lead to MySQLhang residence and affect the business. 1. When MySQL deletes a table, it is divided into two steps: ①: bu

  2022-06-01 08:54:47 Views: 239
• 

  DBCA graphical interface production database

  Oracle Application Express is a fully supported option for Oracle databases that does not require additional purchase. It is a rapid development tool for Web applications for Oracle databases, requiring only a Web browser to

  2022-06-01 08:54:17 Views: 225
• 

  SQL internal connection, external connection and the usage of the (+) sign

  SQL provides several types of joins, and the difference between them is that different methods are used to select rows for joins from different data sets that overlap each other. A. Internal connection, the most common equivalent connection. (tables on both sides are restricted) B. external connection is divided into left outer connection

  2022-06-01 08:54:06 Views: 222
• 

  Detail the common solutions to data disasters based on ORACLE database environment

  1. Fault description: common data disaster failures based on ORACLE database environment: 1. ORACLE database can not start or work properly. 2. ORACLE ASM storage destruction. 3. The ORACLE data file is missing. 4. ORACLE data file

  2022-06-01 08:54:02 Views: 203
• 

  HBase Shell input command cannot remove problem solving skills

  During the use of HBase shell, using the CRT client, you cannot delete the solution after entering the command: options-- > session options-- > Terminal-- > Emulation Select linux

  2022-06-01 08:53:59 Views: 284
• 

  MySQL's method of using mysqldump+binlog to fully recover deleted databases

  This article mainly explains the method of MySQL using mysqldump+binlog to completely restore the deleted database, the content is clear, interested friends can learn, I believe it will be helpful after reading. (I) Overview in daily MySQL database

  2022-06-01 08:53:59 Views: 211
• 

  Hbase 0.94.16 pseudo distribution mode installation

  This article describes the installation of hadoop plus 0.94.16 hbase on the basis of version 1.2.1, hehe! Now it seems that these versions are a little out of date. At the time of writing, hadoop had just released version 2.3.0. If you are a novice or have just stepped into ha

  2022-06-01 08:53:59 Views: 209
• 

  Db_name,service_names,instance_name,oracle_sid,global_dbname in ORACLE

  There are a lot of name-related parameters in Oracle, which can sometimes be confusing. What is the purpose of this parameter, and what is the difference between them? Let's first take a look at the parameters and name-related parameters that have db_name,instance_name in the parameter file.

  2022-06-01 08:53:29 Views: 284
• 

  Summary of oracle cursor usage

  Cursor is widely used in PL sql and is often used in the return values of stored procedures and functions. The return values used in functions solve the problem that pl sql does not have table-valued functions in disguise. Generally, when calling stored procedures in java, the result set returned is also using cursors.

  2022-06-01 08:53:28 Views: 259
• 

  Grid error Resolution for oracle 11g rac installation

  1. Cannot find shared disk on rac2 node using oracleasm [root@rac2 ~] # oracleasm scandisksReloading disk partitions: doneCleaning

  2022-06-01 08:53:25 Views: 275
• 

  Zabbix alarm from the library ERROR-1062

  Last_SQL_Errno: 1062Last_SQL_Error: Error 'Duplicate entry' 54755 'for key' PRIMARY'' on query. Defa

  2022-06-01 08:53:25 Views: 246
• 

  Get the moving moment of OCM 10g

  First of all, I would like to thank itpub's warehouse Xie Yongsheng, who helped me a lot in the exam. Without him, I may not be able to keep on getting this certificate. Thank you very much! A year and a half ago, by chance, I searched the Internet for oracle textual research and found

  2022-06-01 08:53:22 Views: 299
• 

  Bug2 of pt-online-schema-change

  The pt-online-schema-change tool relies on the trigger mechanism to implement the lock-free DDL of the table. Let's imagine that in the case of one master and one slave, there is a large table that needs to perform a DDL operation. In order to verify the execution time of this operation, first use pt-online-s.

  2022-06-01 08:53:18 Views: 213
• 

  The unforgettable experience of the OCP exam

  The unforgettable experience of the OCP examination author: mjboy I sat quietly in front of the bed, looking out at the hallway, gradually fewer people moving around, at this moment, everything is very quiet, people have fallen asleep, only I am still pinching my cell phone, I am suddenly thinking, why not use a way to enjoy the tiring schedule of the day

  2022-06-01 08:53:12 Views: 257