Database Administrator

NoSQL products are getting increasingly popular. NoSQL products are generally developed with high performance and high performance.ScalabilityHigh Fault Tolerance is everyone's praise. When we ask why NoSQL becomes popular, we may ask why these

Navicat Oracle features an intuitive GUI and provides powerful visualization tools such as query editor and syntax highlighting capabilities when previewing SQL, SQL console, text, hexadecimal and BLOB view/Editor, SSH tunnel and more to improve

In fact, this problem was previously encountered by the same customer. At that time, an engineer resolved the problem and recorded the process as follows: The application colleagues reported that the stored procedure had been executed for 2 or 3

To count which users are logging on to the database and other purposes, you need to record the information about the database logon and the information about failed attempts to log on to the database, which of the following triggers can be

Rownum and rowid are all pseudo columns. However, rownum is a logical number and its value always starts from 1. The rounum of each row is not fixed. The rowid is a "physical" number. If the database file is not moved, the rowid of each row is

The quick refresh mechanism of Oracle materialized view is completed by materialized view logs. How can Oracle quickly refresh multiple materialized views through a materialized view log? This article briefly describes the refresh principle. For

Oracle set operation combines two or more result sets into one result set. Result set operations include: INTERSECT (intersection) returns the records that are common to the two queries. Select deptno from dept intersect select deptno from emp;

Triplicate Select mbid00, mbmc00, llurl0, cfwz00, mbsltp, sycs00, lrsj00 from (Select mbid00, mbmc00, llurl0, cfwz00, mbsltp, sycs00, lrsj00, rownum as con from (Select * from JZ_MBXXB0 where 1 = 1 and lbid00 ='123'Order by lrsj00)Where rownum 10)

I. Reserved Area Loading and aging of large objects without PIN will cause fragments in the sharing pool. Oracle wants to solve this problem. It opens up a region in the sharing pool, all objects larger than 4400 bytes will be allocated space in

I. Basic Configuration: 1.ToRootLogin, MountLinux isoFile [Root @ Oracle ~] # Hostname Oracle.junjie.com [Root @ oracle ~] # Cat/etc/sysconfig/network NETWORKING = yes NETWORKING_IPV6 = no HOSTNAME = oracle.junjie.com [Root @ oracle ~] # Ifconfig

Test Oracle 11g fixed execution plan-Baseline 1. Select SQL _id SQL>Pagesize 300 SQL>Set linesize 300 SQL>Set autotrace on SQL>Var name varchar2 (10 ); SQL>Exec: name:='It'; Select department_name From hr. departments dept Where

Overview of Oracle flash deletion and recycle bin In earlier versions of the Oracle database, if a table is mistakenly deleted, the database must be restored to the previous time to restore the deleted table. This process is usually time-consuming

Starting from Oracle9i, Oracle provides a Web-based sqlplus interface. With iSQL * Plus, you do not need to install any Oracle client, you can use sqlplus in the browser to perform data operations and database management. Generally, you can log on

1. Start and close server processes:The following are the usage and common options of the pg_ctl command. It should be noted that this command is the encapsulation body of the S command, so it is more convenient to use than using postgres

Oracle multi-field max/min Function We know that max or min is used for finding the maximum and minimum values in a column; You can use greatest and least to calculate the maximum and minimum values for multiple columns and fields (not sure the

Configure Oracle listener in Linux to remotely connect to the database Server: Export LANG = "zh_US" 1. Add a listener: terminal running:$ ORACLE_HOME/bin/netca(In the graphic interface environment), add a listener as prompted.2. added services

Since Oracle 10 Gb has not yet come out of the red-flag Linux Asianux 3.0, it is better to install the rpm package according to the requirements of Asianux 2.0. We must have the following RPMs installed:Red Hat Enterprise Linux 4.0 and Asianux

Migrate a user from an Oracle database to another database. The migrated data volume is about 120 GB. If you use expdp to export data, it will take a long time. In addition, the exported DMP file copy and impdp import time cannot meet the

Through the Partition Table analysis, we found that the original table structure was renamed without indexing, and a new table was created. After the analysis, we found that the index was used! Is it a partition storage parameter? Or the number of

We often hear that in Oracle, when a role is granted user permissions, the user must log on again to obtain the permissions granted. How can this problem be solved? Let's take the following steps to understand the meaning of this sentence. 1. DBA