Database Administrator

Lately, I met a case that the range filter predicates due to wrong cardinality issue. Let's check the following query. Recently I encountered a performance problem caused by incorrect base number caused by range filtering. Let's look at the

Create a myt table and insert data as follows: Create table myt (name varchar2, create_time date) Insert into myt values ('john', to_date (sysdate, 'dd-MON-YY ')); Insert into myt values ('Tom ', to_date (sysdate, 'dd-MON-YY ')); Insert into myt

1) Preparations* FTP client software* Xmanager* Pl/SQL dev* 10gr2_db_sol [1]. cpio, database installer, applicable to SUN Solaris (iSCSI), Database Version 10.2. 2) create user groups and users1) Add a user group:Groupadd oinstallGroupadd dba2) Add

To manage Oracle databases in Ubuntu, we 'd better use Oracle's own SQL developer software. Previously I installed DbVisualizer to manage Oracle, which is a common database management tool and convenient. On the Internet, many methods for installing

1. Install CentOS 5.5 i386. All are installed by default. Disable SELinux and firewall. 2. Check the rpm package # Rpm-qa -- queryformat "% {NAME}-% {VERSION}-% {RELEASE} (% {ARCH}) \ n" | \ Egrep "binutils | compat-libstdc ++ | elfutils-libelf |

Installing Oracle on openSUSE is a simple task. Generally, you can follow the steps on the openSUSE website to install Oracle more easily, provided orarun. to install and configure the rpm package, follow these steps:Http://en.opensuse.org/Oracle_on_

I wrote the LAMP configuration document for Ubuntu only. Today I cannot enter my mysql. It's a strange thing! It's also strange to say that, in the same configuration steps, the broken machine in the unit, how can we be so obedient? The new second

Processing null in oci must be completed through Indicator. Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 # Include # Include # Include # Include "include \ oci. h"# Include "include \ ociextp. h"   # Define ERRGOTO (Recode) do \{\If

When we install RAC, sometimes the incorrect ASM instance or LISTENER is installed due to various errors, or the CLUSTERWARE resource is added, but it does not really work, such: The two nodes have created ASM1 and ASM2 instances respectively. The

1. The current session is valid. Alter session set NLS_DATE_FORMAT = 'yyyy-MM-DD: HH24: MI: ss '; 2. Permanent Effect After the sys user logs in, execute the following command and restart the database to make it take effect. Alter system set NLS_

1.View the Exhibit and examine the structure of the SALES, MERS MERs, PRODUCTS, and TIMES tables. The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table. Similarly, the CUST_ID and TIME_ID columns are also

In one sentence, cold backup refers to stopping database services, such as MySQL and Oracle, and then backing up the data directory using the copy, package, or compression commands. If the data is abnormal, you can recover the data through backup.

To configure a Cluster, you must at least configure1 MGM (Management node) + 1 SQL node + 2 Data NodeMGM can share a machine with the SQL node, and the data node occupies a server separately.This requires at least three servers. Sometimes it will be

Oracle 11g, when backing up a database with the exp command, if the table does not have a datagram EXP-00011 error, the corresponding table does not exist. As a result, the corresponding empty table cannot be backed up. Cause: by default, a segment

An error is reported for a standby database of the database: ORA-00600: Internal error code, parameter: [kdoilsn1], [], [], [], [], [], [], [], [], [], [], [] According to the trace file, the SQL statement that reports an error is: select * from

Physical standby database error: Internal ORA-00600 error code, parameter [kdsgrp1], [], [], [], [], [], [], [], [], [], [], [] The SQL statement that produces the error is a select statement. Query this error: Applies:Oracle Server-Enterprise

We have published three articles in the first, second, and third articles in one of the basic questions and answers for Linux interviews, which are well received by readers. At the same time, we have received feedback. Some readers hope that this

This error occurs during the link while installing Oracle10201 for the linux X86-64. Detailed error message: Error in invoking target 'install' of makefile'/opt/oracle/product/10.2/ctx/lib/ins_ctx.mk '. see

1. What is the difference between PGA and SGA? SGA is the global area of the system, and PGA is the global area of the process. Oracle is running, and SGA is the memory structure of oracle, such as putting databuf and share pool, allocating at

DBA manages all the data in the database. However, it is not convenient to use the Administrator identity for some data operations due to audit or other reasons, however, you do not know the user password of the Oracle user, because the Oracle user