Basic management of Oracle10gRACspfile

--- A SPFILE---SPFILE must be created on a shared volume or a shared raw device when you use DBCA to create a database-all instances use the same SPFILE-if you manually create a database --- A SPFILE---SPFILE must be created on a shared volume or a

DB2 database backup and Restoration

If it is backed up by DB29, the path following from is written to the direct parent directory of the file. If it is backed up by DB28, the path following from is written to the direct parent directory of DBName.0. If it is backed up by DB2 9, the

Test the reading of 10046 data blocks in the table after the index is created in Oracle

Test the reading of 10046 data blocks in the table after the index is created in Oracle Test the reading of 10046 data blocks in the table after the index is created in Oracle Test the reading of 10046 data blocks in the table after the index is

OracleRAC add and delete VotingDisks

OracleRAC backup and recovery VotingDisks reference: www.linuxidc.comLinux2013-0380937.htm add Delete votingDisk example: Environment: Oracle RAC backup and recovery Voting Disks reference: http://www.linuxidc.com/Linux/2013-03/80937.htm add Delete

Collect statistics from Oracle

-- Collect Oracle statistics BEGINDBMS_STATS.GATHER_TABLE_STATS (OWNNAMEgt; -- Collect Oracle statistics BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME = gt; -- Collect Oracle statisticsBEGINDBMS_STATS.GATHER_TABLE_STATS (OWNNAME => 'owner _ name'

Pass Linux/Unixshell parameters to SQL scripts

In the database O & M process, Shell scripts provide great convenience for O & M. The shell script parameter is passed to SQL as a variable, and the SQL script is also DB In the database O & M process, Shell scripts provide great convenience for O &

DataGuard uses altersystemarchivelogcurrent to maintain ArchiveLo

DataGuard uses altersystemarchivelogcurrent to maintain ArchiveLog Data Guard uses alter system archive log current to maintain the Archive Log We can use Archive Log management during routine Data Guard maintenance: ① Alter system switch

RACLocal_listener: An Oracle Appendix

Because it will be found in tnsnames. ora on the server end. If it cannot be found, it cannot be resolved. Because it will be found in tnsnames. ora on the server end. If it cannot be found, it cannot be resolved. First look at a

Linux/Unixshell automatically sends AWRreport

Observe the Oracle database performance. The awr feature provided by Oracle provides us with a nearly perfect solution. With awr features, we can extract awr reports from the database at any time. Observe the Oracle database performance. The awr

SQL built-in functions

1. Create a table: createtabletest (idint, namevarchar (20), quarterint, profileint) insertintotestvalues (1, 1. create a table: create table test (id int, name varchar (20), quarter int, profile int) insert into test values (1, 1. Create a

Oracle Data Dictionary: $ v _

In addition to the preceding view, Oracle also has a set of virtual tables used to record the current database activity. As the name suggests, dynamic performance tables are not real tables. Therefore, not all users In addition to the preceding

OracleRAC-problems encountered during installation and Solutions

This article mainly discusses the problems encountered during the entire RAC installation process and how to solve them. Error 1: Shared disk configuration error. If the shared disk has content This article mainly discusses the problems encountered

SQL statement for obtaining users and permissions

In daily maintenance work, users in the same database need to be migrated to another database. In this process, the same users and related permissions must be created in the target database. In daily maintenance work, users in the same database need

Use of Oracle packages

-- Functions and stored Procedures can be defined separately. At this time, they will appear under the plsql -- functions folder and Procedures folder respectively. At the same time, they can -- Functions and stored Procedures can be defined

Oracle Data Query

When searching for data in the ORACLE database, a table has a character type of CHAR [2000]. Due to the long character length, it cannot be retrieved using String. After google Baidu found When searching for data in the ORACLE database, a table has

Special cases of using consistentgets in Oracle

In Oracle databases, consistentgets is very useful in determining the performance of a SQL statement. Generally, comparing the performance of two SQL statements is not based on who executes the SQL statement for a short time, but on who executes the

Change command in Oracle

You can use the Change command to Change the string (that is, replace the string ). Syntax: C [HANGE] sepcharold [sepchar [new [sepchar] Sepchar is the Separator You can use the Change command to Change the string (that is, replace the string ).

Oracle11gR2 single-instance Database Backup Recovery Based on GRID

1 Application Scenario: Environment: Host Name IPVIPSIDDiskGroupdb11.1.1.11.1.1.11 1 Application Scenario: Environment: Host Name ip vip sid DiskGroup db1 1.1.1.1 1.1.1.11 1. application scenarios: Environment:Host Name ip vip sid DiskGroupDb1 1

What is OracleKey-PreservedTable and what view can be used for DML operations?

When operating the Oracle view through DML, a very important condition is that the base table to be operated must be Key-PreservedTable. So what is Key-PreservedTable? When operating the Oracle view through DML, a very important condition is that

Usage of explain in MySQL

I have encountered some database problems during performance tests recently. I usually use slow query logs to find SQL statements with poor execution performance. However, I cannot find these SQL statements only, I have encountered some database

Total Pages: 12780 1 .... 9458 9459 9460 9461 9462 .... 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.