Handling of ORA-39700 with UPGRADE option errors
Scenario: Use rman to recover a database from a different machine, and perform the most critical step. An error is reported when the database is opened. The details are as follows:
SQL> startup mount;
Node where RAC Archive log is written incorrectly
Multiple customers have asked several times that archive logs of node2 In the RAC environment are written to the archive path of node1.
This problem causes some customers to be unable to read logs
Redis database (string and hash type)
I. string type
String is the simplest type in Redis. A key corresponds to a value. redis string can contain any data object, such as JPG images or serialized objects.
The operations on the string type are as
How to delete a database in Oracle 11 without using DBCA
This short tutorial will show you how to delete a database from Oracle 11 without using DBCA (Database Configuration Assistant.
1-SID of the imported database, if not defined
Export
Navicat shortcut, navicatHot Keys
Mian windows
Keys
Action
CTRL + G
SettingsLocationFolder
CTRL + # (# represents0to 9)
Open Object Window from Favorites List
F6
Console
CTRL + H
History
Oracle performance optimization operation 12: Use Case statements to merge multiple scans, oraclecase
We often have to calculate different aggregation based on multiple sets of data tables. For example, the following example uses three independent
Application of nextVal and currVal in the database., nextvalcurrval
X. nextVal gets the next sequence value of x sequence, and x. currVal gets the current sequence value of x sequence.
Note:X.CurrVal must be referenced beforeX. NextVal; otherwise, a
Steps for installing 11gR2 ASM single instance and 11gr2asm instanceEnvironment: Platform: VisualBox 4.3.12OS: Oracle Linux 5.8 Grid Infrastructure: 11.2.0.3Database: 11.2.0.31. Install the Operating System (omitted)2. Configure the software
Database Optimization-vertical segmentation and Application in actual projects, vertical segmentation
I was in charge of a project (China Telecom BDC project), and the purchased Database hardware was a small unit of P590. After the stress test, the
Oracle Performance Optimization Operation 9: shielding useless indexes and optimizing oracle Performance
Example of "oracle performance optimization operation 8"
In actual queries, there are also queries involving DisposalCourseFlag = 6. If the
Database Design Principles
1. The relationship between the original document and the object can be one-to-one, one-to-many, and many-to-many. In general, they are a one-to-one relationship: an original document corresponds to only one entity.
In
How a single commit and multiple commit affect the IOPS of the system.Zookeeper
The name and sensitive number desensitization statement in this article:
In order to protect personal privacy, the real name of the expert is desensitized and replaced
Oracle performance optimization operation 4: Remove "IN", "OR" whenever possible, oracle Performance Optimization
The Where clause containing "IN" and "OR" usually uses a worksheet to invalidate the index;
If a large number of duplicate values are
Simple oracle query, simple oracle
Data Query uses the SELECT command to extract information from the database table.
Syntax structure: simple query
SELECT * | column name | expression FROM table name WHERE condition order by column name
Syntax
Summary of connection timeout in Hibernate + C3P0,
Recently, the background always encounters a connection timeout problem when several game zones concurrently notify the background to write statistics. The following exception is thrown, causing
MySQL slow Query
Slow query (slow log)It can help us locate specific SQL statements for SQL statement optimization. For example, slow query logs record the SQL statements whose execution time exceeds the given value, so as to locate the
Oracle environment variables and identifiers that you don't pay much attention to, and oracle environment variablesSign (?) Represents the ORACLE_HOME Environment VariableEg:SQL> ALTER TABLESPACE TEMP ADD DATAFILE '? /Dbs/temp02.dbf 'size 200 M;Sign
DB notes (Oracle), db notes oracle
DB notes (Oracle)
1. Oracle Installation, Service Startup, database creation, and User Creation (omitted ).
Ii. Select statement:
(1) Single Row functions:
1. Expression and null calculation, the result is null,
Asmack source code entry, asmack source code
The initialization of Smack involves two steps:
1. initialize system properties-initialize system properties through SmackConfiguration. These attributes can be obtained through the getxxx () method.
2.
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.