NAV: SLTechnology News&Howtos > Database >

• 

  Group managed Service account (Group Managed Service Accounts, i.e. gMSAs)

  Group managed Service account (Group Managed Service Accounts, that is, gMSAs) the group managed service account is a MSA for multiple servers. Windows manages service accounts for services running on a set of servers. Act

  2022-06-01 11:27:55 Views: 252
• 

  Basic commands of Linux+MySQL operation and maintenance

  Production system environment: [sky@sky9896] $cat / etc/redhat-releaseCentOS release 6.8 (Final) 1. Log in to the database: [sky@sky9896 ~] $m

  2022-06-01 11:27:44 Views: 235
• 

  [BBED] BBED simulates and fixes ORA-08102 errors

  [BBED] BBED simulates and fixes ORA-08102 errors 1.1 BLOG document structure figure 1.2 introduction 1.2.1 introduction and precautions Technical enthusiasts, after reading this article, you can master the following skills, and you can also learn something else you don't know

  2022-06-01 11:27:44 Views: 216
• 

  8.1.7 OSPF packet format

  The protocol number of OSPF is 89. When OSPF packet multicasting occurs, their TTL is set to 1. All OSPF packets in the header start with a 24-octet header, the version number of the versionOSPF version, and the version number of the OSPF

  2022-06-01 11:27:31 Views: 235
• 

  The difference of execution efficiency between innerjoin and exists

  Today, in the implementation of business, it is found that the frequent use of contains statements is inefficient and does not produce results at all, but innerjoin can get the results in an instant. It turned out to be because exsits needed to match 400000 pieces of data from a dataset, which was very resource-intensive. Total

  2022-06-01 11:27:31 Views: 269
• 

  ORA-00257: archiver error. How to deal with Connect internal only and until freed errors

  ORA-00257: archiver error. Connect internal only, the handling method of until freed error oracle database has done real-time synchronization function, synchronization must open the archive log function

  2022-06-01 11:27:30 Views: 250
• 

  Three scenarios in the SQL statement that cause performance problems

  Functional operation of conditional fields: destroys the order of index values, so the optimizer decides to abandon the walking tree search function, but it is not to give up walking the index, but can not use the fast positioning function of the index, you can use full index scanning, of course, you may also directly traverse the primary key index. Mysql > desc

  2022-06-01 11:27:30 Views: 249
• 

  Oracle linux install oracle 11gR2

  Oracle linux is recompiled by oracle according to the linux distribution of redhat, adding some elements of its own. Of course, it belongs to the derivative version of rhel as well as centos, but because it relies on the big tree of oracle, so

  2022-06-01 11:27:27 Views: 230
• 

  Array_filter, find_in_set query whether id is in the id collection, concat connection string, ifnull, if usage

  1:array_filter checks whether each element is a numeric if (array_filter ($this- > data ['log_id'],' is_numeric')! = $data ['log_id']) e

  2022-06-01 11:27:27 Views: 290
• 

  SAP & Oracle EBS integrated solution

  one。 Demand Analysis SAP and Oracle EBS are both the top ERP products in the world and have won the favor of many customers. However, due to the large system, high price and different positioning, customers often face the following confusion in the process of implementation: how to achieve "online + online" in 1.SAP.

  2022-06-01 11:27:26 Views: 206
• 

  Centos7 installs redmin3.3.0+postgresql database

  Preface Redmine is a web-based project management software developed with Ruby. It is a cross-platform project management system developed with ROR framework. It is said to be derived from the ror version of Basecamp. It supports a variety of databases and has many unique functions, such as w

  2022-06-01 11:27:20 Views: 303
• 

  Verify how heap table is stored

  Verification heap table (heap table) storage mode heap table (heap table) storage mode: heap table is the most common and most commonly used in Oralce database system. The data storage mode of the heap table is unordered storage, that is, any DML operation may make the current

  2022-06-01 11:27:14 Views: 204
• 

  Basic Operation of RMAN (1)

  Recoverymanager (RMAN) is a backup and recovery tool provided after ORACLE 8i. It can back up the entire database or database parts, including tablespaces, data files, control files and archive files. RMAN can access and perform backups and

  2022-06-01 11:27:14 Views: 281
• 

  User section of commands commonly used in mysql

  New user: create user user name;-- create an empty password user. Create user user name IDENTIFIED BY 'password';-- create password .grant select [, inse when creating a new user

  2022-06-01 11:27:10 Views: 204
• 

  Build CDH5.8.3 under centos7.2

  1. Basic environment: operating system: Centos 7.2.1511jdk environment version: jdk-8u45-linux-x64.rpmmysql environment: rpm package: http://ftp.ntu.edu.tw/MySQL/Do

  2022-06-01 11:27:10 Views: 265
• 

  Some time conversions commonly used in oracle

  Some are commonly used in the time format select TO_CHAR (SYSDATE,'HH24:MI:SS AM') from dual-12:56:40 afternoon select TO_CHAR (TO_DATE ('21 -)

  2022-06-01 11:27:10 Views: 291
• 

  The use of MySQL trigger trigger

  Q: what is a trigger? A: a trigger is a database object associated with a table that fires when the definition condition is met and executes the set of statements defined in the trigger. The characteristics of the trigger: 1, there is a begin end body, the statements between begin end; can be written simple or complex 2.

  2022-06-01 11:27:10 Views: 247
• 

  Creation and deletion of 1Z0-051-DDL-2 simple index

  Indexes have two functions: one is to enforce primary key constraints and unique constraints, and the other is to improve performance but reduce the performance of DML operability. 1.1 necessity of index I. the index is part of the constraint mechanism, through which the key value can be accessed immediately (or approximately immediately). If you define a primary key, and the primary

  2022-06-01 11:27:10 Views: 288
• 

  How much do you know about RMAN backup compression

  1. RMAN backup has been compressed by default. 1) unused block compression When employing unused block compression, RMAN skips reading, and backing up

  2022-06-01 11:27:06 Views: 283
• 

  Tracking table change record when audit is not enabled by Oracle

  The boss of the operation and maintenance team called and said that they found that tens of thousands of businesses had been re-pushed, and for the third time, the problem was still quite serious. If they wanted to track down who made the misoperation, they had a time period and the tables involved, and asked if there was any way to track it. The database version is 10.2.0.4. The first thought came to mind.

  2022-06-01 11:27:06 Views: 268