Database Administrator

In Linux, the database name, table name, column name, And alias are case-sensitive: 1. The database name and table name are case sensitive; 2. Table aliases are case sensitive; 3. The column name and column alias are case-insensitive in all cases;

As you know, it is sometimes necessary to terminate all Oracle processes or a specified set of Oracle processes. When the database is "locked" and you cannot enter Server Manager to "gently" Terminate the database, you can use the kill command in

After Oracle is upgraded to 11.2.0.3, there will be a series of Performance or Wrong Results. According to the metalink Document ID 1392633.1, the solution is as follows: ScopeThis note concerns itself with highly updated patches in 11.2.0.3 that

For details, see:Oracle Database Release Notes11g Release 2 (11.2) for ibm aix on POWER Systems (64-Bit)Part Number E23560-031. Installation, Configuration, and Upgrade Issues for Release 11.2.0.3Review the following sections for information about

Someone recently proposed to view the Postgresql execution plan. The following describes how the cost and other related values in the PG execution plan are calculated:PG version 9.1.21. Use the terminal tool PGADMIN to press F7 to execute the

Enterprise-levelDatabaseMost applications are deployed inRAIDThe disk array server can improve the disk access performance and implement fault tolerance/disaster tolerance.RAID (redundant disk array) is simply an array made of cheap hard disks. The

In database security configuration, security reinforcement is required. To ensure database security, however, sometimes, after improper operations or database business account password modification, the configuration of database connection for the

How can we evaluate the performance of the database to be launched soon? swingbench is the best choice except Benchmark Factory for Databases, which can be described as short and concise and completely free of charge, you don't need to get your

In the past two days, a QA asked, "it is difficult to check the Database console because the database storage time is BigInt. I really don't know what it is! There is related function conversion in the impression, as follows: The storage time of the

Fine-grained auditing (FGA) is introduced in Oracle 9i. It can record SCN numbers and row-level changes to recreate old data, However, they can only be used for select statements, but not for DML, such as update, insert, and delete statements.

In Oracle RAC, in addition to the TFA Method Based on the client, there is also the TFA Method Based on the server. You can regard the TFA method of the server as an upgraded version of the TFA method of the client. The TFA on the server must be

Using shell scripts to monitor and manage Oracle databases will greatly simplify DBA workload, such as common instance monitoring, monitoring, and alarm log monitoring, and database backup, AWR report automatic mail, etc. This article describes how

1. Configure Advanced Security Options and network services for Oracle databases through OUI 2. Configure kerberos Authentication 1. Execute the command netmgr and click the authentication label. In Available Methods, select KERBEROS5 and move it to

When migrating a database from MSSQL to MySQL, You need to insert 0 values in the auto-increment column of MySQL based on the requirements of business logic. In MSSQL, this is done as follows: String SQL; sql = " set identity_insert dbo.AppUsers on "

The latest PSU of Oracle is 11.2.0.3.6 on July 6, May 29, 2013. This upgrade is performed for RAC and DB respectively to prepare for the future RAC + DG Environment. System: linux 5.7 x86_64 Database Version: 11.2.0.3.0 Upgrade ORACLE from a single

Oracle 10g officially certified operating system version Operating system x86Red Hat Enterprise Linux AS/ES 3 (Update 4 or later)Red Hat Enterprise Linux AS/ES 4 (Update 1 or later)Oracle Enterprise Linux 4 (OEL4)Red Hat Enterprise Linux AS/ES

One switch command1 switch command usageUpdate the data file name to the data file name specified during image copy under rmanUpdate the data file name to the name specified by the set newname command. 2. Prerequisites for using the switch

Problem description: Use pl/SQL developer 9.0.6 on Windows 7 (32-bit) to remotely connect to the Oracle 10.2.0 database in Linux (64-bit. The oracle client used on Windows is a instantclient-basic-win32-10.2.0.3-20061115 and

When using RMAN to copy a physical standby database, it is prone to errors and the error is very strange.The author summarizes the following points. 1. RMAN-04006 ORA-12528 Start the slave database to nomount SQL> startup nomount & nbsp;The Oracle

When multiple tables are joined in Hive, the Hive SQL Optimization engine is not powerful enough, and the Association Sequence of tables is different, which leads to different quantities of MapReduce jobs. In this case, you need to adjust the SQL