Database Administrator

Search for records with all repeated titles: SELECT * FROM t_info a WHERE ((SELECT COUNT(*) FROM t_info WHERE Title = a.Title) > 1) ORDER BY Title DESC 1. Search for duplicate records 1. Search for all Repeated Records Select * From table Where

Oracle-07445 [kgghash]: Oracle BUG causes the process to be killed when updating the LOB FieldSymptom:The user reports that a DB connection is accidentally killed. The following information is found in the alert Log during troubleshooting:Mon Apr 22

The oracle optimizer uses statistics to select the optimal or sub-optimal execution plan. During the execution plan determination process, oracle can analyze the data distribution characteristics of each table column very well, however, oracle is

Inadvertently found this good tool from a blog abroad, can't wait to recommend to everyone this completely free SQL intelliisense Prompt tool (http://www.red-gate.com/products/ SQL _prompt/index.htm), preliminary use, it can indeed improve

Merge is a very useful function, similar to the insert into on duplicate key in Mysql.Oracle introduced the merge command in 9i,With this merge, You can execute the inserts and updates operations on a table in an SQL statement at the same time. of

Indexes can be used for like 'xxx % 'in MySQL, but like' % xxx % 'cannot. mysql> desc artist;  +------------+-----------------------------------------------+------+-----+---------+-------+  | Field      | Type                                

Oracle Database 10g audit captures user behavior at a very detailed level, which can eliminate manual, trigger-based audit. Assume that user Joe has the permission to update the table and updates a row of data in the table as follows.

On percona performance conference 2009, several Yahoo engineers brought a "Efficient Pagination Using MySQL" report, which has many highlights. This article is a further extension based on the original article. First, let's take a look at the basic

-- This test script can be run directly. -- Now we want to group and add data in the database by fixed fields. Five methods are summarized here. -- Create a test table and add Test Data create table test(id varchar2(10),mc varchar2(50));   

It briefly describes how to check the CPU and PSU patch installation of the current database. There are two methods under normal circumstances. One is to log on to the database and check the DBA_REGISTRY_HIST View: MODDB2:[/home/oracle]$sqlplus 

Overview Variables are an essential part of a language and, of course, the same for T-SQL. Variables are rarely used in simple queries, but variables are an essential part of complex queries or stored procedures. Variable type In the T-SQL,

Task: there are more than 1000 store information records (in excel, including address, store name, phone number, etc.). The boss asked me to use the address to find the corresponding coordinates, then, the coordinates are added and updated to the

The more memory available for SQLSERVER, the more resources SQLSERVER has to use in the buffer zone, which can reduce the number of times the server reads data from the disk to obtain static information or compile the process plan. To adjust the

Monitoring over 250 configuration parameters and thousands of measurements is not an easy task for Oracle administrators to monitor the overall health of their Oracle databases. Oracle provides a variety of tools to monitor performance, but this is

It is hard to know why a system is slow in running and performance degrades. Is it a memory leak, a bottleneck on the disk subsystem, or is there a limit on the scalability of a specific application? There are some ways to discover and understand

The time spent preparing new SQL statements is the most important part of the execution time of Oracle SQL statements. However, by understanding the internal execution plan generation mechanism of Oracle, you can control the number of times that

View is one of the most basic and important functions for databases. The design of the database view is directly related to the database performance. In addition, in the design of large databases, the division of labor and cooperation, the design of

BKJIA exclusive Translation] This article provides a general introduction to the automatic database maintenance task management in Oracle 11g. The article is concise for two reasons: 1. Most people have not touched these settings. Even so, if you

The data dictionary in Oracle is a very important part of the database and provides information about the relevant database. It is used by all Oracle users (from application end users, application design developers to database administrators) is a

Oracle Database pioneered the design concept of tablespace, which makes an indelible contribution to the high performance of Oracle Database. In this case, many Oracle optimizations are implemented based on the tablespace design concept. Typical