NAV: SLTechnology News&Howtos > Database >

• 

  Automatically enable the standby log application when the windows operating system restarts

  You must first start DG_BROKER_STARTALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH; to create a batch file: set ORACLE_HOME=D:\ a

  2022-06-01 07:44:00 Views: 227
• 

  28_bbed actual combat (1) _ delete operation recovery

  The following example shows how to restore deleted rows. When the rows in the Oracle are deleted, the data is not actually deleted. Rows are simply marked as deleted, and free space counters and pointers are adjusted accordingly. The row state is stored in the header, which occupies the first few bytes of each line.

  2022-06-01 07:43:55 Views: 248
• 

  Principles of index design

  Principle of index design 1. Leftmost prefix principle index column_name (10) Index only the first ten bytes ERROR 1071 (42000): Specified key was too long; max k

  2022-06-01 07:43:49 Views: 297
• 

  How to add and delete subpartitions automatically in Dameng database partition table

  The following is a test example of automatically deleting, creating a partition child table, and maintaining a partition table: 1. Add a partition child table create or replace procedure addpartition (sTable_name v) at a fixed time every month

  2022-06-01 07:43:49 Views: 209
• 

  Basic operation of Oracle

  First, start and close the database 1. How to start database sqlplus / as sysdba-login database SQL > startup-start database 2. How to confirm whether the database has been started method 1: ps-ef | gr

  2022-06-01 07:43:49 Views: 282
• 

  How do six people operate and maintain 10,000 servers?

  At GOPS2017 Beijing Railway Station, Zheng Songkuan from Qunar gave a speech entitled "the Evolution of Qunar Network Application Operation and maintenance Automation", sharing the obstacles encountered in the automation construction process and how we overcome these obstacles, which pits we encountered, and how to fill them.

  2022-06-01 07:43:49 Views: 219
• 

  Summary of data Dictionary tables and views commonly used in Oracle

  Oracle commonly used data dictionary table, view summary-data dictionary classification 1. Static data dictionary table 2. Static data dictionary view 3 dynamic data dictionary table 4 dynamic data dictionary view 2 use of data dictionary 1. Use of static data dictionary tables static data dictionary tables can only

  2022-06-01 07:43:48 Views: 288
• 

  Erroneous deletion and recovery of DM7 data files in Dameng database

  In DM7, there are two features related to data file recovery. Data file failure check the value of the parameter FIL_CHECK_INTERVAL in DM.ini specifies the time interval for which the dm7 system checks the data file, and a setting of 0 means no check. It can also be done through system process S.

  2022-06-01 07:43:48 Views: 268
• 

  Comparison and characteristic Analysis of mainstream backup Software, NBU/TSM/Legato/DP/NetVault

  At present, the mainstream backup software includes Quest NetVault (Quest), Symantec NetBackup (Veritas), EMC NetWorker (Legato) and IBM TSM (I.

  2022-06-01 07:43:48 Views: 256
• 

  Mysql Learning-password Management (default password, change password, solve forgotten password)

  1. There is no password by default after mysql installation. Log in with default password after initialization and installation. You need to modify the root password immediately. [root@mysql ~] # cat / root/.mysql_secret-- View the root account password # Th

  2022-06-01 07:43:47 Views: 218
• 

  Installation Series 1 of GaussDB 100OLTP stand-alone on Centos7.6

  Installation preparation o create user group, user o database installation o modify archive mode 1, installation preparation 1. Installation process 2. Hardware and software indicate that CPU is at least 4 cores, memory occupies at least 2GB, and it is recommended to modify the file system mount parameter to noatime,nobarr.

  2022-06-01 07:43:43 Views: 242
• 

  Tipard Mac Video Converter Ultimate for mac (video format conversion)

  No matter what video format you want, Tipard Video Converter Ultimate Mac can convert it for you! This video conversion software is very powerful, can convert different audio and video, support different formats, and use it.

  2022-06-01 07:43:34 Views: 253
• 

  ORACLE 12C opatch fuser and ChecksystemCommandAvailable failed

  Because the LINUX operating system did rpm package psmisc, ORACLE 12C reported an error: Missing command:fuser when using the opatch installation vulnerability patch. The screenshot of the error is as follows: it is relatively simple to handle the problem, and it is linu.

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

  How does mysql expire_logs_days work and calculate?

  Mysql active and standby replication is done through binlog. When binlog is enabled, the expire_logs_days parameter allows mysql to automatically clean up the binlog from several days ago. So where is expire_logs_days?

  2022-06-01 07:43:21 Views: 294
• 

  Getting started with mysqlsla

  1. What is mysqlsla? To put it simply, it is a tool to analyze mysql log, and I mainly use it to analyze mysql slow log. 2. Download http://hackmysql.com/mysqlsla3 and install tar

  2022-06-01 07:43:21 Views: 269
• 

  Generate a summary line every 15 lines

  The user raffle module award_gift_record is the user raffle record table. Actiontime is the lucky draw time. AwardGiftID means the gift of winning the lottery ID.-1 means that there is no winning awardactId means that the activity ID needs

  2022-06-01 07:43:18 Views: 256
• 

  Mysql-e detailed explanation

  You can use shell scripts to operate the mysql database, and use the-e parameter of mysql to perform a variety of sql (create, delete, add, delete, change, check) and other operations. Mysql-hhostname-Pport-uusername

  2022-06-01 07:43:17 Views: 223
• 

  Oracle transport tablespace-EXP/IMP

  Transport_Tablespace-EXP/IMP imports the T1 table under the 192.168.3.199 database and the chenjc user into the 192.168.3.198 database by transmitting the tablespace (EXP/IMP).

  2022-06-01 07:43:17 Views: 268
• 

  Depth | what is the underlying logic of POLARDB to lead domestic databases to the world?

  POLARDB is the next generation cloud native distributed database independently developed by Aliyun. It is 100% compatible with MySQL, PostgreSQL and other open source databases, and is highly compatible with Oracle syntax. Customers using RDS services do not need to modify the application code and can migrate to P with one click.

  2022-06-01 07:43:17 Views: 225
• 

  The role of innodb_support_xa

  Innodb_support_xa can switch on and off xa two-stage transaction commit for InnoDB. How to open it? Innodb_support_xa=true, supporting xa two-segment transaction commit. The default is true, the value is on, and the submission is executed concurrently by multiple threads.

  2022-06-01 07:43:17 Views: 203