Briefly describe the process of adding a node in the Oracle 10203 for Solaris SPARC Dual-node environment. Shared storage is already configured on a third node, which focuses on the configuration on the operating system and on Oracle.
This article
This article details the use of ORACLE commands to create databases and table spaces on the command line
1, the use of Super User login Sqlplus.
2, create the table space:
sql> Create tablespace Test
2 datafile ' D:\oracle\oradata\test\test.dbf '
1. Table Space (tablespace)
A table space is a basic logical structure in a database, a collection of data files. A table space can contain multiple data files, but a data file can belong to only one table space.
Query table space:
Sql>select *
We used the Oracle materialized view incremental refresh mechanism to synchronize the data of a table on database A to another database B on a regular basis.
The simplest implementation step we often use is this. First, confirm on database A that
1, Table space: Table space is the logical division of the database, a table space belongs to only one database. Each table space consists of one or more data files.
Data from other logical structures in the tablespace is stored in these data files.
First, create and manage tables1. CREATE TABLE syntax
CREATE TABLE table name (column datatype [default Expr][,column ...])
The description of default constraint is slightly
2, use the subquery to create the table
CREATE TABLE Table name
As
SELECT *
The data guard provides the following three kinds of protection modes:
1 Maximum protection mode (Maximum Protection)"Maximum protection" here refers to the maximum protection of the data is not lost, that is, at least one standby and primary
Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix
Open
SQL Server
Can only run on Windows, without the slightest openness, the stability of operating system systems is very important to the database. Windows9x Series products are focused on desktop applications, NT server only for small and
Part I: Profile concept
Oracle database 10g uses a new approach called SQL configuration files to compensate for the drawbacks of storage profiles,
DBAs can use SQL Tuning Advisor (STA) or SQL Access Advisor (SAA) to identify SQL statements that
1, the use of dual table
Dual is an actual table in Oracle that can be read by any user and is often used in a SELECT statement block that does not have a target table
(1) View current connected users
Sql> Select User from dual;
USER
-----------
Absrtact: Oracle database is one of the most widely used large-scale databases, and its optimization is directly related to the operation efficiency of the system. Based on the basic principle of database performance optimization, this paper
1. The concept of the channel
A channel represents a stream of data to a device (disk or tape) and produces a corresponding server session on the target database or a secondary database instance (server sessions)
Multiple channels generate
There are two ways to optimize Oracle's optimizer:
Rule-based optimization method: rule-based optimization (RBO)
Optimization method based on cost or statistic information (cost-based OPTIMIZATION:CBO)
Rbo: When the optimizer analyzes SQL
Oracle's Plsql
CREATE OR REPLACE Package chapter_13 asTYPE RS is REF CURSOR;Procedure founder (ofields out RS);EndCREATE OR REPLACE Package Body chapter_13 asPROCEDURE founder (Ofields out RS) isBEGINOpen Ofields forselect * from person;End founder;
Oracleenterprisemanager (Oracle Enterprise Manager, abbreviation OEM) provides management services for managing distributed environments through a set of Oracle programs. OEMs include a set of DBA tools, a repository, and a graphical display of the
A database is a typical representative of a network database. Users can access the database over the network. Oracle database provides a variety of network interconnection schemes, including structure and driver, whose network communication
Some time ago in a migration of data pump and exp, found that the difference in efficiency is quite large. Here is an example of a simple comparison.
This article discusses the effect of parallelism on the export of data pumps.
Write a few
I. Theoretical part
The materialized view of Oracle is a database pair that includes a query result, which is a local copy of the remote data, or is used to generate a summary table based on the sum of the data tables. Materialized views store data
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