Database Administrator

I. Pre-compiled SQL statement Processing PreparedStatement is an interface in java. SQL. It is a subinterface of Statement. When you use the Statement object to execute an SQL Statement, you must send the SQL Statement to the DBMS. The DBMS compiles

You can view an all_parameters table in dbsnake's blog. You can use this table to view hidden parameters. But I confirmed later that this table is not available. Therefore, this is a view created by dbsnake. How to view Oracle parameter categories

Read consistency ensures that the query results are consistent with the data at the time when the query is initiated, regardless of whether other transactions have changed the data during the query. Assume that we have the following function to

Users in Tianjin reported that the Oracle 10.2.0.4 RAC database generated a large number of trc files a few days ago, resulting in full support of the file system of oracle. Check oracle alert logs on the corresponding host, there are a lot of ORA-0

Oracle analysis function over and Window Function I. analysis function overOracle provides analysis functions starting from 8.1.6. analysis functions are used to calculate a group-based aggregate value. What is different from aggregation

Summary: In data migrate, the constraints on some tables are always bothering us, making migratet difficult. How can we use the attributes of constraints to solve these problems? This article describes in detail the four attributes of constraints:

The following error occurs when Goldengate is in the replicat process: The following logs: 16:25:21 WARNING OGG-00869 OCI Error ORA-04098: trigger 't_mlog_log_dtl_submit_state 'is invalid and failed re-validation (status = 4098), SQL . 16:25:21

If the following error occurs during RMAN backup. Historical archived logs cannot be deleted. RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process RMAN-08515: archived log file name = +

ORA-02082 CREATE DATABASE LINK Connect to username identified by password USING 'service name '; The Link name and service name cannot be the same SQL> create database link OMS connect to OMSUSER identified by password using 'oss _ 10.2.8.1 ';

Create and manage Oracle Partition tables I. Create a partition table Partition tables are divided into four types: 1. Range Partition Table 2. List Partition Table 3. Hash Partition Table 4. Combined Partition Table The following table creates four

Installing Oracle SQL Developer in RedHat Linux 5 has a small problem, but with the help of W3C, it has been solved: 1. install J2SE 6u20. because from SUN. COM is downloaded. binfile. search for: how to install. bin in linux, the answer for

Two methods to import nginx logs to hive 1. Create a table in hive Create table apachelog (ipaddress STRING, identd STRING, user STRING, finishtime STRING, requestlineString, Returncode INT, size INT, refererString, AgentString) ROW FORMAT

This chapter describes how to handle the "handling material handling tickets" error?Main signs:1. If this option is selected, pressing "process" does not work.2. You cannot view "View/update allocation (U)"3. "Source sub-stock" is empty.For example:

Source code: xx. pc /*  Function: demonstrates the Oracle scroll cursor operation.    Considerations when defining a cursor:  1. The declare cursor statement must be the first statement to use the CURSOR.  2. The cursor name is an identifier

Chinese garbled characters in MySQL databases have been a problem for a long time, whether it is java Development or php development. For the sake of simplicity, I have always set the encoding to UTF-8 on all my JSP pages. At the same time, when I

Oracle said that, according to internal standards, on Linux, the read/write speed of MySQL 5.5 is 5.1 higher than that of MySQL 360%. On Windows Server, the performance has been improved by more than 1500%. And our Discuz! And Discuz! The X series

When I arrived at the company, I received a friend's message saying that one node of RAC had crashed. Because he re-built an index at last night and ran for more than two hours before it was over, then he manually canceled it. At, one of the nodes

Flashback query traces the pre-image data stored in the rollback segment to obtain the data before the change. This allows you to quickly restore and roll back the data before the pre-image is overwritten. The flashback feature is affected by the

Hint is often used in SQL statement optimization. This section summarizes common Oracle HINT usage during SQL optimization: 1./* + ALL_ROWS */ It indicates that the overhead-based optimization method is selected for the statement block, and the

Opening the cmd command line is definitely not a mysql command line. The first time I was wrong in this place, I was depressed for a long time. Command for backing up MySQL database Mysqldump-hhostname-uusername-ppassword databasename> backupfile.