Oracle string segmentation in work

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 (

HBase stress testing

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

Install and deploy multiple MySQL instances in Linux

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

Oracle view basics and Examples

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 [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 -------------

MySQL5.6 more user-friendly modification of the redolog Transaction Log File Size

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

Install Oracle11.2 on CentOS6.4

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

When the ORA-01552 was doing experiments, the undo segment management mode was modified.

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

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:

Install MySQL under Fedora20

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

The ORA-28000 account is locked and unlocked

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 of Oracle read/write disks

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;

Remotely connect to Oracle using PHP in Linux

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

MongoDB database Initialization Script

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

Oracle performance problems caused by improper definition of materialized views

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

MySQL example employees Database

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

Flashback and recycle bin of Oracle11g Database

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

Logminer log mining example

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 database Archive

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

Use dbms_backup_restore to restore the database

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

Total Pages: 12780 1 .... 9363 9364 9365 9366 9367 .... 12780 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.