//refer to the web but the way someone gives it is wrong. Public functionEleme_callback () {$res= (Object)Array(' 1 ' = ' foo '); $data=$this->object_array ($res);} Public functionObject_array ($array) { if(Is_object($array)) { $array=
Oracle full-text index is a technology that exchanges space for time. In addition, dml operations cannot be automatically synchronized to the index, which requires regular manual maintenance. Therefore, it is not widely used.
Oracle full-text index
MySQL string to date type selectstr_to_date (2014-08-2000:00:00, % Y-% m-% d % H: % I: % s); 2014-08-2000: 00: 00selectdate_format (1997-10-0422: 23: 00, % H: % I: % s); 22:23:00
MySQL string to date type selectstr_to_date (2014-08-2000:00:00, % Y-%
Tuning through case studies -- Dynamic View (v $ bh and x $ bh) v $ bh and x $ bhv $ bh: it records the usage of data blocks in the data buffer in detail, and records the detailed records of a block. V $ bh from base table x
Tuning through case
Start an Oracle database instance in Linux: Step 1: Start the listener; Step 2: Start the database instance.
Start an Oracle database instance in Linux: Step 1: Start the listener; Step 2: Start the database instance.
Start an Oracle database
After the project was completed, we found the tragedy. By default, sqoop is used to list data tables from oracle databases. If the data accuracy is greater than 15 bits, some fields in the imported table are default.
After the project was completed,
The access to foreign MongoDB images is very slow, so it is very unreliable to select the MongoDB official website for online installation. Then, we can choose to install the binary release package of MongoDB2.6.
The access to foreign MongoDB images
Today, in the log file of a server, the following information is found: It seems to be an error, but it does not affect the operation of the database. But after all, the error is reported. If you look uncomfortable, study Fa.
Today, in the log file
Use the dbms_pdb package for Migration. dbms_pdb is newly added to 12c, which is used for Migration convenience. You can use descdbms_pdb to view the specific parameters. Migrate Non-CDB database
Use the dbms_pdb package for Migration. dbms_pdb is
ORA-00980: synonymtranslationisnolongervalid, ORA-00980: synonym conversion no longer valid
ORA-00980: synonym translation is no longer valid, ORA-00980: synonym conversion no longer valid
ORA-00980: synonym translation is no longer valid ORA-00
Oracle performance optimization cursor and SQL, these SQL statements are strictly unable to share the cursor (that is, share the execution plan), but the execution plans required for these statements are
Oracle performance optimization cursor and
ROLLUP literally means to roll up the volume. It can be used in GROUPBY to accumulate the sum: If there is no ROLLUP, the following query is based on department_id and job _
ROLLUP literally means to roll to, used in group by can play a cumulative
Record A ORA-600 [13013] processing process and an alert Log with a ORA-600 [13013] error found after a database exception is completed
Record A ORA-600 [13013] processing process and an alert Log with a ORA-600 [13013] error found after a database
This article has been tested by ourselves. The system is Ubuntu14.04server, And the Mysql database is Mysql5.5. We are going to migrate it to MariaDB10.1.
This article has been tested by ourselves. The system is Ubuntu 14.04 server, and the Mysql
Oracle version: Oracle versions earlier than 11.2.0.3.9 have been installed with the patch set 11.2.0.3.9, and Rac has not yet been officially used. Therefore, we can simply hit the latest 11.2.0.3.11 patch set.
Oracle version: Before Oracle Rac 11.2
A new feature in Oracle11g is the Partition Table of the system. Here is an experiment: SQLgt; select * fromv $ version; BANNER -------------------------
A new feature in Oracle 11g is the Partition Table of the system. Here is an experiment: SQLgt;
The principle of MySQL master-slave replication is the same as that of MySQL master-master replication, but slave databases cannot be used for write operations. Therefore, some parameter configurations may exist during the configuration process.
The
Due to some remote installation requirements, the remote interaction of the oui gui is slow, which may affect the speed of DBA's RAC installation. Or some enterprises disable XWindow, which also causes failure.
Due to some remote installation
The error "ERROR1148" is returned when MySQLload reads data from a file.
When MySQL load reads data from a file, ERROR 1148 is displayed.
Create a data table in MySQL
Create table weblogs (Md5 varchar (32 ),Url varchar (64 ),Request_date
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service