Database Administrator

How to configure complex password verification settings for Oracle 11g ---- View the password-related parameter configuration information in the default profileSQL> SELECT profile, resource_type, resource_name, limit FROM dba_profiles WHERE resource_

[Troubleshooting] Oracle 11g graphical installation failure System Environment: OEL6.5 _ x86 Database Version: Oracle 11g 11.2.0.3.0 I. [fault symptom] The first graphic interface is displayed when Oracle 11g is installed, and a fault warning

Merge updates or inserts the same table. merge updates the table.For a business logic, you must first determine whether a record exists in the Database. If yes, update the record. If no record exists, insert the record.The practice before the

MySQL hash partition (4), mysqlhash Partition For details, see MySQL partition (1) Example: Here is my personal learning Summary-> details --> if you have any questions, please come and talk about it. MYSQL hash decryption Root:

Oracle 12C 64Bit installation manual in Oracle Linux 6.5 and 12c installation manual Oracle 12C 64Bit installation manual in Oracle Linux 6.5, step by step : Http://download.csdn.net/detail/rlhua/7689365 For 64-bit Oracle Installation in

MySQL update and delete, MySQL update and delete The SQL statement for updating and deleting operations is relatively simple. However, when using UPDATE, pay attention to the limitations of the WEHER condition. The following statement only updates

Rubbing people and chores-constantly updating, and constantly updating1. After finishing the lv layout and adding datafile, we can find the big tablespace ....2. Add a bare device datafile without r3. Access the cde interface through the xmanager

Modify mysql-root password on mac-solve various permission problems, macmysql-root Official: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix There is also a reference for mysql installation, with

For different database versions of session_cached_cursorsFor the session_cached_cursors value, different db versions have different default values:9i is 010.1 010.2 is 2011.1 is 5011.2 is 5012.1 is 50It is worth noting that this parameter is a

Chapter 1 Securing Your Server and Network (7): Disable SQL Server Browse and chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not

[Translated from mos] In the rac database, the HC _ . dat file is used by instances under other Oracle_Home instances .,In the rac database, the HC _ . dat file is used by instances under other Oracle_Home instances.Reference Original:RAC database

Oracle memory management (one): oracle Memory Management [In-depth analysis of oracle-eygle] Study Notes 1. Memory Management   The memory used by the ORACLE database mainly involves two aspects: PGA and SGA.  1.1 PGA Management PGA refers to the

Windows sqlplus/as sysdba report ora-12560 the ultimate solution, sqlplusora-12560Windows sqlplus/as sysdba report the ultimate solution of ora-12560Windows, sqlplus/as sysdba often report ORA-12560: TNS: protocol adapter error, solve this error,

Query the Exchange Server distribution group and output the group members to a local text file !, Recently, the customer has a requirement to query all the members of the Distribution Group. It is easy to use PS. How can this problem be solved? The

MySQL automatically adds a column in Select... into outfile...to show the effect of csvleading fields, outfile..csvSelect... into outfile... it only exports data without field names, so you need to find another way to implement it. Here is a clumsy

[Translated from mos] The v $ undostat view is not updated every 10 minutes. v $ undostat has only one row (one rows) and mosundostat. The v $ undostat view is not updated every 10 minutes. v $ undostat has only one row (one rows) Reference Original:

Overview of database systems-[04] index and database system overview 04 1. Index Overview  Index creation is an effective way to speed up the query. You can create one or more indexes on the basic table based on the needs of the application

C3P0 apparent deadlock, 1. After running c3p0 for a period of time, the following error is reported: W 07-26_00:58:27 ThreadPoolAsynchronousRunner.java 608 com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@70929ab6 -- APPARENT

MongoDB aggregation operations, Introduction to aggregation An aggregation operation is an operation that records data and returns computation results. MongoDB provides rich aggregation operations to detect and execute computation on datasets. Data

Single-purpose aggregation operation, Clustering refers to a wide range of data manipulation operations based on an input and a specific program for computing results. MongoDB provides a large number of aggregation operations to perform specific