Database Administrator

Oracle 10 Gb physical standby to logical standby 1. Preparations for configuring logical StandbyBefore creating a logical standby, first check the status of the primary database to make sure that the primary database has all the preparations for

Deleting temporary tablespace ORA-25152 Error Deleting temporary Oracle tablespaces or shrinking temporary tablespaces often results in table space occupation. Next we will handle this situation, First, find the locked sid: SELECT a. INST_ID, B.

Summary of SQL video and summary of SQL I still like short videos in English for 7 to 8 minutes. The VB videos of Mr Chen Wei and the SQL videos of Mr Yan jianling are all between 30 and 40 minutes. One tomato is not enough and two tomatoes are not

In oracle db, the calculation formula of a data dictionary pct miss is oraclepct. This article is an original article. For more information, see the source: Http://blog.csdn.net/msdnchina/article/details/38766801   The data dictionary mentioned

SQL Server, sqlserver A trigger is an addition, deletion, and modification operation on a table, which causes or triggers the addition, deletion, and modification operation on another table. Therefore, the trigger has three types: deleted trigger,

Oracle Performance Analysis 3: TKPROF introduction, oracletkprof Tkprof is a command line tool that comes with Oracle. It is mainly used to convert the original trace file to a formatted text file. The simplest way to use it is as follows: tkprof ly_

Zero Point download. The first version of the autumn version of the xinxing mysql tutorial in 2014 has been completed. We look forward to your support. After a period of unremitting efforts, in the end, the first version of the autumn version of

Failed to upgrade Oracle Cluster Registry configuration (root. sh), clusterroot. shRecently, we have installed Oracle 10g RAC on Suse 11 sp3. After installing clusterware, run/u01/app/crs/root. sh received an error message, Failed to upgrade Oracle

PL/SQL learning and plsql LearningDocument 1 -- Created onDeclare-- Local variables hereI integer;BeginI: = 12;-- Test statements hereDBMS_OUTPUT.put_line (I ); End;Document 2 DeclareCursor s isSelect * from city_app.city_server;S _ s %

Data room charging system trigger and charging system trigger The earliest Contact trigger was seen in Yan jianling's video, but he did not understand it at all. However, when the data center charging system was implemented, it turns out that SQL

Sorting and sorting algorithms -- Sorting problems, such as numbers 1, 2, 3, 4, 5, and 6 -- ideas: (1) if 1 is changed to 5, that is, 1 is directly changed to, 2, 3, 4, and 5, respectively, minus 1 and 6 unchanged -- (2) if 5 is changed to 3, 5 is

Sqlite learning notes 11: Using sqlite to delete records in C language, sqlite learning notes The last section describes how to delete data. All the previous code is inherited here and passed the test on Ubuntu14.04 and Mac10.9. # Include #

Sorts a field in a database table by deduplication. 1. Problem background In a database, t_tab_ AB has two fields, a and B, as shown below: Before query: After query: A B 1 2 1 2 1 3 2 3 1 4 3 4 1 5 2 3 2 4 2 5 3 4 3 5 2. Solution Groups and sorts

Postgresql ALTER common operations, postgresqlalter Postgresql version: psql (9.3.4) 1. ADD an alter table table_name ADD column_name datatype; 2. delete an alter table table_name DROP column_name; 3. Change the Data TYPE of the alter table

Having has some differences in Oracle and mysql, havingoraclemysql In Oracle, having must be used in combination with group by, but in mysql, the situation is different and can be used separately. C: \ Documents ents and Settings \ guogang> sqlplus

Data center charging system-triggers and data center charging system triggers In the previous article, we learned how to use the view. We still need to know a lot about the database. What is a trigger? How to use it? What are the advantages of using

[ThinkPHP learning] ThinkPHP automatically escapes and stores Rich Text Editor content, leading to read errors, RT. Convention. php In the conf file of ThinkPHP has a configuration option. 'Default _ filter' => 'htmlspecialchars', // The DEFAULT

Computing cost -- full table scan, computing cost -- table Scan The following describes how to manually calculate the cost value in the oracle execution plan. The cost is calculated as follows:Cost = (# SRds * sreadtim +# MRds * mreadtim

[MySQL Case] ERROR 1418, mysqlerror1418 1.1.1. ERROR 1418 [Environment description] Mysql5.0.67 [Problem description] When creating a stored procedure, an ERROR 1418 is reported. # Create an SQL statement for a function Create function 'xxx' (num01

ORA-00911: Invalid character, invalid ora-00911 character An error is returned for a simple select statement! Solution: remove the semicolon ...... Why does this happen? Because I chose Test Window and selected the SQL Window below, there