NAV: SLTechnology News&Howtos > Database >

• 

  How to set up boot DB2 and oracle

  In fact, there is a parameter of autostart on the DB2 database, but somehow it doesn't work on DB2v10.1, so I have no choice but to solve it by myself. Some of the methods on the Internet are to write a script and set it to boot. I think it's too troublesome. I do this by editing / etc/rc.

  2022-06-01 12:49:12 Views: 224
• 

  Oracle sql makes a traversal query

  SELECT * FROM (WITH temptest AS (SELECT LEVEL lv FROM DUAL connect BY LEVEL < = 10) select lv,cnt,gdm,s

  2022-06-01 12:49:07 Views: 246
• 

  Hbase on Yarn- compilation and deployment of slider

  1. Compile Slider, [root@plat1 apache-slider-0.91.0-incubating] # pwd/usr/local/src/apache-slider-0.91.0-incu

  2022-06-01 12:49:03 Views: 244
• 

  Quickly understand the principle of MySQL InnoDB transaction ACID implementation in this article

  [51CTO.com original manuscript] when it comes to database transactions, what comes to mind is either to make changes or none at all, or the concept of ACID. In fact, the essence of a transaction is a combination of locking, concurrency, and redo logs. This article is mainly about what the transactions in InnoDB are.

  2022-06-01 12:49:00 Views: 283
• 

  AWR report parameters: DB TIME and DB CPU

  Preface: AWR report is an important report to understand the operation of ORACLE, and the use of CPU is an important indicator of AWR report. This document interprets the AWR report from the dimension of a single CPU. Second, introduction of important parameters: DB Time:Amount of e

  2022-06-01 12:48:57 Views: 261
• 

  Ebs creates one user based on another user and adds responsibilities

  -- create user DECLAREv_user_name VARCHAR2: = upper ('& Enter_User_Name'); v_description VARCHAR2: =

  2022-06-01 12:48:56 Views: 240
• 

  Application scenarios and points for attention of mongodb

  The data in MongoDB is stored in a "library"-"collection"-"document"-"field" structure. This structure is very similar to the "library", "table", "row" and "column" structure of the traditional relational database. However, MongoDB does not need to pre-define the table structure, data

  2022-06-01 12:48:56 Views: 246
• 

  Oracle 11G RMAN single instance off-machine recovery

  Data backup is of course preparation for data recovery. Oracle of the new environment has been backing up all the time, but there are no tests to verify the effectiveness of the backup, so the importance of this test is self-evident! The following is an example of RMAN offline recovery on WIN platform. Source database target library operating system WIN SVR

  2022-06-01 12:48:26 Views: 204
• 

  The role of voting nodes in mongodb

  The voting node does not contain a copy of the dataset in the replication set and cannot be promoted to the primary node. Voting nodes exist to make the number of nodes in the replication set odd, so as to ensure that the same number of votes will not occur when voting. If you add a node, the total number of nodes is even

  2022-06-01 12:48:26 Views: 262
• 

  MongoDB replication set

  About MongoDB replication set 1, what is a replication set? a replication set is an additional replica of data, a process of synchronizing data across multiple servers. Replication sets provide redundancy and increase data availability, through which hardware failures and interrupted services can be recovered. The advantages of replication sets are as follows:

  2022-06-01 12:47:56 Views: 229
• 

  BSLN_MAINTAIN_STATS_JOB Job Failed With ORA-04063

  Oracle 12c Statistics automatically collect JOB- (BSLN_MAINTAIN_STATS_JOB) error information ORA-04063: package body "DBSNMP.BSLN_INTERNAL" h

  2022-06-01 12:47:56 Views: 226
• 

  Mysql optimization

  Database level: application system level optimization SQL optimization SQL optimization generally through the analysis of slow query logs to capture long transactions and high consumption of sql, through the combination of specific business, sql logic analysis and simplification, or rewrite sql. By configuring slow_query_log

  2022-06-01 12:47:56 Views: 226
• 

  [Oracle Database] Database user management

  Create user SQL > create user soe identified by soe default tablespace soe temporary tablespace temp;User cre

  2022-06-01 12:47:56 Views: 221
• 

  Pessimistic lock, the concept of optimistic lock

  Pessimistic lock: as the name implies, it is very pessimistic, which refers to a conservative attitude towards the modification of data by the outside world (including other transactions of the system, as well as transactions from other transactions, as well as transactions from external systems). The data is locked throughout the data processing process. Pessimistic lock implementation

  2022-06-01 12:47:55 Views: 257
• 

  Synchronization failure caused by the same server_id in master/slave

  Yesterday, I encountered a strange imagination when I was doing MySQL SwitchOver. The structure diagram before and after switching is as follows: when I switched everything, I restarted mysql on 04 in response to other needs, and then show slave status\ G found an error: La.

  2022-06-01 12:47:55 Views: 208
• 

  Oracle ebs modifies the password of an APPS user

  Be sure to back up your password before you fix it: SQL > create table fnd_user_20160614 as select * from fnd_user;Table created.SQL > create t

  2022-06-01 12:47:54 Views: 230
• 

  Histogram of Oracle

  1 the meaning of histogram in the Oracle database, CBO defaults to assume that the data of the target column is evenly distributed between its minimum LOW_VALUE and maximum HIGH_VALUE, and calculates the option after applying query conditions to the target column according to this uniform distribution principle

  2022-06-01 12:47:51 Views: 289
• 

  RHEL 7.2 + Oracle 12cR2 + RAC

  Recently, * began to install the Oracle 12cR2 database version in large quantities. I have also installed a lot of RAC environments for my customers. Some are installed in a virtualized environment and some are installed on an X86 server. You need to consider configuring a lot of path software on the X86 server. RHEL 7.2

  2022-06-01 12:47:51 Views: 238
• 

  Exercises for sed and awk

  Use sed to print out the IP address: [root@Srv02 ~] # ifconfig eth0 | grep Mask | sed's / ^. * dr://g' | sed 's/Bc.*$//g'192.168.1.22

  2022-06-01 12:47:51 Views: 212
• 

  Brief introduction of if case statement find locate File search and Compression and decompression tool

  1 shell script programming condition selection if condition judgment case 2 file search find locate and compression and decompression tools procedural programming language: sequential execution selection execution loop execution condition selection if statement execution: note: if statement

  2022-06-01 12:47:50 Views: 287