StandbyDatabase in the DataGuard environment has two main roles: physicalstandby and logicstandby. Here we will describe the establishment process of physicalstandby.
In the Data Guard environment, the Standby Database mainly has two types of roles:
Key points for setting a reasonable logbuffer size: 1. Default size: MAX (0.5 M, (128 K * numberofcpus) 2. Onmostsystems, sizingthelog
Key points for setting a reasonable log buffer size: 1. Default size: MAX (0.5 M, (128 K * number of cpus) 2. On
Recently, Oracle released several new features in the latest version of MySQL5.7.2. Most of the improvements are in database performance and replication-related functions.
Recently, Oracle released several new features in the latest MySQL 5.7.2
MySQL replication process: each time a write operation is executed, it will save a copy to its own database. At the same time, this write operation will also be stored in a binary log file, and
MySQL replication process: each time a write operation
How to ensure that 10gCRS and 11gGI have the same node, that is, 10gCRS and 11gGridInfrastructure are installed on a set of clusters at the same time, and are implemented through script Switching
How to ensure that 10g CRS and 11g GI exist on the
In Oracle, checkpoints are divided into three types: Full checkpoints, incremental checkpoints, and partial (temporary) checkpoints. Full checkpoints trigger DBWn to set all the dirty data in buffercache.
In Oracle, checkpoints are divided into
Demonstrate NonrepeatableRead and PhantomRead in Oracle
Demonstrate Nonrepeatable Read and Phantom Read in Oracle
Nonrepeatable Read:
Non-repeatable Read: in a transaction, the same data is Read twice to obtain different result sets.Phantom Read:
Oracle's online help system is implemented through the ystem. help table, which stores SQL information in Oracle. First, use the system user to log on to sqlplus, ora
Oracle's online help system is implemented through the ystem. help table, which
Adding indexes is a frequently used performance optimization method. When you encounter a problem, try to add an index to see if the execution plan can be changed. This is why we have analyzed and solved the problem.
Adding indexes is a frequently
Oracle11gRAC + single-instance database construction of DataGuard
Oracle 11g RAC + single-instance database build DataGuard
I. Initial environment of databases and operating systems:
Prepare the RAC database that has been installed and can run
In projects, tasks that need to be completed regularly, such as regularly updating data and defining statistical data to generate reports, can be completed using Oracle jobs.
In projects, tasks that need to be completed regularly, such as regularly
In some cases, very large tables, such as population information statistical tables, are used. If a table is large, the query speed is reduced and the management difficulty is increased. If the disk is damaged,
In some cases, very large tables, such
Step 1: query the idselectobject_idfromall_objectswhereowner of the table from the data dictionary view.
Step 1: query the table id from the data dictionary view select object_id from all_objects where owner =
Step 1: query the table id from
In the shutdown status, the database only has the PLSExtProc service and is in an unknown state. The database is in the nomount status and has SID, SIDXDB, SID_XPT, and PLSExtProc services.
In the shutdown status, the database only has the
Install the Oracle11G single-instance database on Linux under the vmvm
Install Oracle 11 GB single-instance database on Linux under vmvm
Install Oracle 11g single-instance database on Linux under vmvm 1. Environment and pre-installation plan:
After hive-0.11.0 came out, I learned that row_number was encapsulated. It is a great happiness for me who do not know java! Don't hesitate to discard 0.8.0!
After hive-0.11.0 came out, I learned that row_number was encapsulated. It is a great
My answer at the time was: With an index, the statistics changed. After indexing, the execution plan has changed. But does soft and hard parsing mean SQL statements? As long as this SQ exists in the Shared Pool
My answer at the time was: With an
With Oracle11g (11.2.0.3), the configuration process still applies to Oracle10g. During the last 10 replica uard configurations, it was found that the rmanduplicate method was used to create the object.
The version uses Oracle 11g (11.2.0.3) and the
We will discuss the partitioning operations of RANGE, HASH, and RANGE in combination with HASH. Since Mysql5.1, the partition function has emerged, and table partitions are like dividing a large table into several small
We will discuss the
Some DBAs are afraid to delete the REDOLOG in the production database, because they are worried that deleting the redologgroup in the ACTIVE or ACITVE status will cause a database accident. If
Some DBAs are afraid to delete the redo log in the
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