Oracle part: Definition type (for string segmentation): createorreplaceTYPESTR_SPLITISTABLEOFVARCHAR2 (4000); string segmentation Function
Oracle: Definition TYPE (used for string segmentation): create or replace TYPE STR_SPLIT is table of VARCHAR2 (
Today, we used the stress test provided by hbase to compress our hbase cluster. cluster configuration: master8cpu * 32G + 3 8 CPU * 16G, parameter configuration, modified zookeeper
Today, we used the stress test provided by hbase to compress our
On LAMP and LNMP platforms, data is stored in MySql databases. MySql versions 3.23.15 and later provide a master-slave synchronous replication mechanism.
On LAMP and LNMP platforms, data is stored in MySql databases. MySql versions 3.23.15 and later
A view is a logical table based on one or more tables or another view. Unlike tables, a view does not contain any data. A table is an entity that exists independently and is used for storage.
A view is a logical table based on one or more tables or
[Oracle] v $ session and v $ process
[Oracle] v $ session and v $ process
View the sid and serial of the current session #:
SYS @ ORCL> select sid, serial #, status from v $ session where sid = userenv ('sid ');
Sid serial # STATUS
-------------
We know that in MySQL5.5, if you want to modify the size of the ib_logfile (redolog) file, and in MySQL5.6, it is more user-friendly, the fourth step can be ignored directly, straight
We know that in MySQL5.5, if you want to modify the size of the
Change CentOS6.4 to the Chinese environment etcsysconfigi18n # LANGen_US.UTF-8LANGzh_CN.UTF-8 restart should be OK -----------------------
Change CentOS 6.4 to Chinese environment/etc/sysconfig/i18n # LANG = en_US.UTF-8LANG = zh_CN.UTF-8 restart
The undo segment is in the manual management mode because the undo segment management mode is modified during the experiment.
The undo segment is in the manual management mode because the undo segment management mode is modified during the
Check and modify the software and hardware environment of Oracle11g installed in Linux
Install and modify the Oracle 11g software and hardware environment in Linux
Linux:
1. Memory: physical memory must be higher than 1 GB
Check memory size:
After Fedora19, Fedora replaces mysql with mariadb. Although these two things are the same, I still like mysql, and I don't know why, in Fedora20
After Fedora 19, Fedora replaces mysql with mariadb. Although these two things are the same, I still
Today the Test Library has an account password forgot, tried more than a dozen times began to prompt: ERROR: ORA-28000: theaccountislocked means that the account is obviously locked, may be
Today the Test Library has an account password forgot,
Cache and Buffer are two different concepts. Simply put, Cache accelerates ldquo; reads rdquo; while buffer caches ldquo; writes rdquo; the former solves read problems,
Cache and Buffer are two different concepts. Simply put, Cache accelerates ldquo;
The OCI package is required for PHP to remotely connect to Oracle. This package is provided by oracle. You can directly install the Oracle InstantClient to obtain this package.
The OCI package is required for PHP to remotely connect to Oracle. This
Most of the time, we need to initialize database settings, such as creating indexes, especially when configuring multiple MongoDB servers, or when initializing and archiving.
Most of the time, we need to initialize database settings, such as
After checking, the CPU and memory of the server are normal, but the disk IO is very high. The index of the optimized SQL-related table is invalid, and the shrinking data file is also invalid. At last, it is found that the session has a lot of
Oracle installation is accompanied by employees data for SQL exercises. MySQL also provides the employees database, but it is not installed with the database, and its download link is also very good.
Oracle installation is accompanied by employees
Flash back technology is usually used to quickly and easily recover logical errors such as misoperations in the database. The flash back method can be divided into database flash back, table flash back, transaction flash back, and root
Flash back
1. specify the time range to determine the number of logs to be mined based on the time range, and add the logs to the script respectively. 2. Compile the logminer script executedbms_logmnr.add_l
1. specify the time range to determine the number of
Oracle12c has a new feature that can archive data in the database, hide infrequently accessed data from the application, and set it to inactive. Of course, it can also be performed at the session level.
Oracle 12c has a new feature that can archive
Scenario: Oracle database storage is broken, data files and control files are all lost, only backup sets of data files are available, and no control files are available in the backup set. (Of course, oracle10
Scenario: Oracle database storage is
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