Database Administrator

ORA-07445: exception encountered: core dump [kghalkaline () + 58] [SIGSEGV] [Address not mapped to object] [0x000000068] [] [] DUMP File * ** Service name :( orcl) 2012-07-12 14:18:55. 016 * ** Session id: (258.58198) 14:18:55. 016 Exception signal:

1. Create a table T2 to insert two rows of data. If the first row of data is written into the archived log, the second row of data is in the online log.SQL> create table t2 (A1 number (10 ),A2 char (10) tablespace users;SQL> insert into t2 values (11

I.Oracle Binary OptionsDescription For more information about OracleOptions, see Oracle component series summary. We can view the related information through the v $ option view: V $ OPTION displaysOracle Database options and features. typically,

Remote access to the mysql database:1. First, make sure that the firewall blocks the mysql database port (default: 3306 ).In Linux, you can use the following command to disable the Firewall:# Service iptables stopFor more information about how to

I recently learned the source code of Mysql and used CMake as the Build tool. By using CMake to scan system configurations, the config. h file is generated. This header file contains a series of macros prefixed with HAVE. Config. h. cmake in the

Show processlist shows which threads are running. You can also use the mysqladmin processlist statement to obtain this information. If you have SUPER permission, you can see all the threads. Otherwise, you can only view your own thread (that is, the

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

Relationship between multiple tables: one to multiple | (multiple to one) Multiple to multiple one to three Integrity constraints of a link: entity integrity, referential integrity, and defined integrity. Entity integrity and reference integrity

Basic information: Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production Operating system version: CentOS release 5.6 To speed up index creation, consider the following: Use nologging Parameters Use parallel

Report Content: TOP wait event, top SQL, top SQL command type, TOP Session content. Specific implementation methods:SQL> @ $ Oracle_HOME/rdbms/admin/ashrpt. SQL Current Instance~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance-------------------------

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

1. Install SQLite3 Sudo apt-get install sqlite3 2. Install the Toolkit required for Sqlite3 Compilation Install the Toolkit if necessary. It is just for the sake of experience. You can skip the installation. This item is optional. Apt-get

Operating System: CentOS 5.8 MySQL version: 5.5.x Original condition: the database is on one machine and some production data already exists. Target: Master-master replication. The two database servers are set to master-master replication, that is,

When an SQL data import is executed: ORA-14400: The inserted partition keyword is not mapped to any partition The details are as follows: SQL> @ "C: \ Documents ents and Settings \ Administrator \ Desktop \ 0109 new V8BS deployment \ to su hong

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

0. Summary Oracle version: 32-bit Oracle Database 11.2.0.1.0 OS Version: 32-bit WinXP SP3 Primary database SID: primary Slave database SID: standby Advantage: Using RMAN to create a mongouard does not require the master database to go down, which is

The focus of this article is "Join clause (join_clause)", rather than table join itself. Content The table and its data used in this article Oracle 11g R1 (11.1) join clause (join_clause) Inner Joins) Cross-join) Outer Join (Outer Joins)

Cause: The data file in noarchivelog mode is corrupted. Solution: Method 1 (non-RMAN backup ): Because there are no archived log files, the restoration operation cannot be performed in noarchivelog mode and can only be completed. Because no log

During Oracle operation, Operation errors may cause damage to internal metadata, which affects some basic functions and normal processing of the system. Once such a fault occurs, rebuilding the internal data dictionary is what we need to do. This

These two days are busy studying postgresql. The basic usage is similar to that of other databases. I will not explain it myself. Today I want to record the postgresql cluster solution hot standby. Set the Cluster Environment myself: Three computers: