Oracle transaction exploration and example (2)

For more information, see www.leonarding.com Oracle transaction exploration and instance (II). database version SYS @ LEO1select * fromv $ version; BANNER ----------------------------------------- For more information, see www.leonarding.com Oracle

Oracle Database Simulated Data File Corruption recovery

Sometimes the database cannot be started because the data file is damaged for some reason. How can this problem be recovered? The following is a simulation experiment. 1. first create a tablespace TEST, and then create a table test in the tablespace

OracleASM development and practices

For more information, see www.leonarding.com OracleASM Development and Practice. 1. Let's talk about the development trend of your storage solution. Oracle78: the database backup solution in this period can already use RMAN For more information,

Solve the Problem of Mysql character encoding

Is Chinese character encoding always difficult for a well-known mysql database? This article uses mysql5.5 as an example. The installation method has been considered here. I only want to say one thing: to smoothly insert data into the database for

Oracle data structure (1)

For more information, visit www.leonarding.com to learn about Oracle data structure (1) concept 1 Here I just want to summarize the block size of the extent Section involved in the logical and physical structures of Oracle. For more information,

[Original] Two new password security policy experiences for MySQL5.6

With the GA of MySQL5.6, MySQL becomes more and more beautiful in some details. Today, we are going to experience two security verification improvements. 1. mysql_config_edit tool. It can be used to encrypt users' passwords and enhance database

Oracle variable binding and variable spying Series 1

Database environment LEO1 @ LEO1select * fromv $ version; BANNER ------------------------------------------------------------------------ Database environment LEO1 @ LEO1select * fromv $ version; BANNER -----------------------------------------------

[Original] experience of replacing partitions in MySQL5.6

MySQL5.6.10 official version has been released for many days. MySQL5.6 adds the partition replacement function. Today, let's try out the partition replacement function. Two example tables. t1 is a partition table, t MySQL5.6.10 official version has

Manage Oracle statistics

Under the CBO (cost-based optimizer mode) condition, the execution plan of SQL statements is determined by the statistical information. If no statistical information is available, the execution plan is determined by dynamic sampling! Statistics are

Summary: three methods of MySQL backup and recovery

1. using mysqldump to completely back up mysql logically, and using binary log backup for Incremental Backup 2. use lvs snapshots to achieve almost full hot backup from the physical point of view, and use binary log backup for Incremental Backup 1.

Partitioning is a double-edged sword. It is highly efficient and difficult to use.

This is my table structure: the answer already tells you that this field must be a primary key. Scan all the partitions. The partition does not make any sense here, But degrades the performance. The reason is as follows: This article is from the

What about oraclehints

Introduction: hints translation is a prompt, indicating that it is used in the database to change the execution method of SQL statements, you can use hints to force SQL to execute the SQL statement according to the method you set, which is generally

PHP5.3 an unsuccessful solution for configuring phppdomysql for the YiiPHP framework

Because the project needs to use the PHPYii framework, some colleagues configured php and yii in the Yii framework, and accessed the necessary webpage of the Yii component to show that mysqlpdo has not been loaded: php has been checked. INI file,

Processing of the MISSINGnnnn file after the control file is created

1MISSINGnnnn file cause data dictionary file $ contains a data file, which is not specified when a new control file is created, the database creates a data file entry in the new control file. 1MISSINGnnnn file cause data dictionary file $ contains a

12306 brute force SQL Injection Vulnerability ?! This is a great deal.

On oschina just now, I saw a message about the SQL injection vulnerability on the 12306 website of the Ministry of Railways, which is an absolute high-risk level. I looked at it and it was speechless. This kind of mistake is too low-level and should

MySQL5.5delete table connection syntax change

MySQL5.5 standardizes the writing of SQL statement table connections. Deleteusera, user2bfromuserajoinuser2bona. idb. id; this is written in MySQL5.1 and can be executed normally ,.. MySQL5.5 standardizes the writing of SQL statement table

Whether the SQL Server Computing column occupies space

There is a problem on the internet today: Check whether the SQLServer computing column occupies space. In fact, check the MSDN or BOL to see the result. When creating a calculated column, you can specify PERSISTED as a parameter. Use this There is a

Oracle temporary tablespace solution example

Today, my buddy told me that some modules in OA are invalid. After checking the system logs, it turns out that the temporary tablespace of the Oracle database is full, restart the database during lunch (this method is the easiest and not prone to

Oracle table fragmentation

During the routine use of databases, it is inevitable that the insert, delete, and update operations occur constantly, resulting in fragmentation of tables and indexes. When there are more fragments, the SQL Execution efficiency will naturally be

ETL and oracleVSmssql in Heterogeneous Database Environments

1. Environment Requirement Description: You have an oracle10g Database on the Intranet and an oracle9i database on the Internet. The user publishes information about talent recruitment through the Intranet. All information is stored in a table and

Total Pages: 12780 1 .... 9358 9359 9360 9361 9362 .... 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.