Database Administrator

DataGuard slave database deletes applied logs The company set up a slave uard. At the beginning, it did not pay attention to the management of archiving logs in the slave database. After the system was running for a while, it was found that the

Oracle universal paging Stored Procedure Oracle universal paging Stored Procedure -- Create a package and define a cursor type in the packageCreate or replace package testfenyepackageType test_cursor is ref cursor;End testfenyepackage; -- Compile

Java implements Oracle Database Backup Today, we will paste an Oracle database backup feature that has been implemented very early. This feature was designed at the university stage: Import java. io. File;Import java. io. IOException; /*** Oracle

How to Use sqlplus-prelim in Oracle hang In many cases, Oracle hang causes sqlplus to be unable to connect, and thus the Oracle system and process status cannot be obtained, which leads to a lack of a strong foundation for locating the problem.

How to enable and enable autotrace for Oracle tools Platform: Oracle 10g RHEL-5.8 The procedure is as follows: 1) sys @ ORCL> @ $ ORACLE_HOME/sqlplus/admin/plustrce. SQL 2) sys @ ORCL> grant plustrace to public; Description of several common

Oracle transaction processing and instance demonstration JDBC operation batch Deletion Transactions As the basic unit of logical processing, database operations are composed of one or more SQL statements. Of course, there are also non-database

(64-bit oracle uses 32-bit PLSQL) install 64-bit oracle database software, use 32-bit PLSQL Developer Connection method, plsqloracle Since PLSQL Developer does not provide 64-bit, I sorted out the information on the Internet and sent it   1.

Oracle public redo thread and private redo thread, oracleredo The previous study content is still vague for public redo thread and private redo thread, and the information collected on the Internet is very limited. It seems that some good things

[Sqlite] --> data migration and backup -- from earlier versions 3.6.2 to later versions 3.8.6 and 3.6.23.8.6Data Migration 1. Use the. dump command Command help prompt . Dump? TABLE? ... Dump the database in an SQL text format If TABLE specified,

Hibernate uses hql for Chinese sorting, Why does MySQL not support Chinese sorting? No way. You only need to wait for utf8_unicode_cn to come out. If you want to implement cross-database with hibernate and do not want to change the code, I will tell

Oracle copies an SQL statement (test OK) for any table row, oraclesql I tested it for a long time. There are many methods on the Internet, but they are all incorrect. The correct method is as follows: declare cursor rowAll is select * from

[Oracle] deletes a node from RAC, which is a oraclerac node. Environment: OS: OEL5.6 RAC: 10.2.0.1.0 There are currently three rac1, rac2, and rac3 nodes. The following describes how to delete a rac3 node. 1. Delete the database instance on the rac3

Optimization of SQL statements in ORACLE notes, oraclesql statements SQL statement optimization is summarized as follows:   To optimize SQL statements, follow these six steps: Rational use of Indexes Avoid or simplify sorting Eliminate scanning

ORA-00600: [kfgFinalize_2], Environment: OS: OEL5.6 RAC: 10.2.0.1.0 [Root @ rac2 ~] # Crs_stat-t Name Type Target State Host ------------------------------------------------------------ Ora... B1.inst application ONLINE rac1 Ora... B2.inst

The Ignoring query to other database problem occurs in MySQL, ignoringdatabase When mysql is used today, any input command will output: Ignoring query to other database This error message is very strange. Later, we found that the-u parameter

RAC Cache Fusion principle understanding, racfusionCache fusion. grd. drm. gcs. gesCache fusion1. RAC is a database running on multiple instances. It uses the Distributed Lock manager (DLM) to solve concurrency problems. Resources are shared among

Data room charging system-view application and data room Charging System View I learned about the view in database learning and self-examination a year ago. At that time, I only learned the theory. This time I personally practiced it in the

Mysql exports only the table structure or data. mysql exports the structure. Only data is imported without structure Mysqldump-t database name-uroot-p> xxx. SQL Only data is imported from the structure. Mysqldump -- opt-d database name-u-p>

Hadoop2.X/YARN environment setup-CentOS7.0 JDK configuration, centos7.0 Hadoop is written in Java and cannot use OpenJDK pre-installed in Linux. Therefore, JDK (1.6 or above) must be installed before hadoop is installed) Raw materials: the 32-bit

Ora1455 indicates how to handle ORA 1455 error when oracle exports data at 11g. This exception may occur because the exported User table may have an empty data table. First: View: SQL> show parameter deferred_segment_creation; If this parameter