Database Administrator

Check Oracle ASM disk groups In Oracle 11gR2, a new command is added to check the normally mounted disk groups. This facilitates the maintenance of the database in the asm mode. Applicable in the following scenarios: 1: The host server is routinely

Oracle 11g Set User Password case sensitivity Oracle 11g uses a parameter to set the password's case sensitivity. The following is an experiment: C: \ Documents and Settings \ guogang> sqlplus gg_test/gg_test@10.10.15.25 _ ggSQL * Plus: Release 10.2.

Oracle Database listening is very slow, and hang basically handles faults Tester email feedback:The connection to the database to be ordered is very slow, or even cannot be connected. I want to check it. View:Oracle @ wdatest11 :~

Oracle automatic backup solution in Linux As a DBA, every full-Database Backup can be performed only when others do not use the database (I know there are other methods, this article only considers export ), with the following two parts, you can

Use DbUtils for addition, deletion, modification, and query, and dbutils for addition, deletion, and modification Commons-dbutils is an open-source JDBC tool library provided by the Apache organization. It is a simple encapsulation of JDBC and has

Type conversion causes the execution plan to not go through the index test case, and the Execution Plan Index Test Environment Simulation:SQL> drop table t_col_type purge;Create table t_col_type (id varchar2 (20), col2 varchar2 (20), col3 varchar2 (2

Oracle clears the high waterline of the table, and oracle clears the waterlineWhen a new record is added, HWM moves up slowly, but HWM does not move down after the record is deleted. Therefore, when you use the delete from command to delete a large

Hbase integrates hive and sqoop to export data to mysql and hbasesqoop.Two advantages of hive integration of hbase tables: 1. import data to MYSQL.2. convert an hbase table to another hbase table. Three steps:1. Associate hive with hbase as an

Mongodb usage and deployment ppt, mongodb deployment ppt1. mongodb Introduction2. pptHttp://download.csdn.net/detail/u014285882/7807105Error reported when using mongodb database configuration in ThinkPhp framework Before using the D method, you

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

Data center billing system and Charging System In fact, I think the checkout part of the data room charging system consumes the most energy. First of all, I don't understand what the checkout is, so I feel dizzy as soon as I come up. Later, I read

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 %

Petelai project experience collection (5) ___ system process design, petela __ There is a process design problem in the design of petelai project, though. NET and Java have workflows, but considering the small size of this project, I simply borrowed

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

Uninstall the oralce11g registry 20140810, oralce11g20140810 Windows Registry Editor Version 5.00[-HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE][-HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle in

DBCP and C3P0 database connection pool, What is the database connection pool? All those who have learned about computer networks know that in an internal LAN, most of them use private addresses. To deal with external networks, they must have

[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

DETERMINISTIC and deterministic in Oracle I have been confused when I saw DETERMINISTIC for many times. I did an experiment today. We assume that ORACLE is a DETERMINISTIC function, which is called only once in SQL. If DETERMINISTIC is not used, the

Full MySQl installation solution, MySQl Installation This is the second installation of MySql. It took several hours for the first installation to understand every page of the installation. This time, I found a few installation packages, so I felt

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