New Features of Oracle 11g-HM (Hang Manager)

New Features of Oracle 11g-HM (Hang Manager) In this article, we will introduce the new features of Oracle 11g-hang Manager. We need to note that HM only exists in the RAC database. When we diagnose database problems, we often encounter

Redis Client Design

Redis Client Design The Redis client is designed as follows: /* With multiplexing we need to take per-clinet state.* Clients are taken in a liked list .*/Typedef struct redisClient {Int fd;RedisDb * db;Int dictid;Sds querybuf;Robj ** argv, ** mbargv;

Notes for Oracle GoldenGate upgrade

Notes for Oracle GoldenGate upgrade Oracle GoldenGate is being upgraded recently. refer to the following documents:How To Upgrade Goldengate From 11.2.1.x to 11.2.1.y for Oracle Database (Document ID 1601971.1)This document makes it clear:2. Stop

Oracle Stored Procedure instance memo

Oracle Stored Procedure instance memo Oracle Stored Procedure instance memo Statistical report: the number of user logins (platform clicks) at the beginning of each month. The scheduled tasks count the number of logins, number of Logon accounts, and

64-bit installation of Redis in CentOS 6.4

64-bit installation of Redis in CentOS 6.4 I. Introduction REmote DIctionary Server (Redis) is a key-value storage system. Similar to Memcached, Memcached supports more storage value types, including string, list, set, and zset) and hash (hash type )

How to delete a database in Oracle 11 without using DBCA

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

Use local indexes to improve PostgreSQL Performance

Use local indexes to improve PostgreSQL Performance You may not know that PostgreSQL supports partial indexing of table data? Its advantage is that it can accelerate the reading speed of the indexed data without additional overhead. the best way is

Use of quote in Oracle

Use of quote in Oracle To express a special character string in SQL or PLSQL, it is usually packaged. However, if the string itself contains characters like 'or', the implementation is a little complicated. For example, My Name is "Wang Xiu Li"

Database optimization principles and Optimization Principles

Database optimization principles and Optimization PrinciplesRecently, I have summarized the database optimization methods in the database course design and hope to help people who need them:1. Optimize the query to avoid full table scanning. First,

A bug ORA-00064 encountered when sga_target is set to be greater than GB: object is too large, sgatarget

A bug ORA-00064 encountered when sga_target is set to be greater than GB: object is too large, sgatarget Host memory 256 GB, sga_target ready to be set to 160 GB, DBCA always reports an error ORA-00064 when creating a database: object is too large

In the hpux operating system, select the lv from the vg, make the lv into a file system, and then mount the file system,

In the hpux operating system, select the lv from the vg, make the lv into a file system, and then mount the file system, In the hpux operating system, select the lv from the vg, make the lv into a file system, and then mount the File System Create

Oracle Database Synonyms (SYNONYM), oraclesynonym

Oracle Database Synonyms (SYNONYM), oraclesynonym This tutorial uses examples to illustrate how to create and delete Synonyms (SYNONYM) in Oracle Data ). Concept Synonyms refer to database objects (tables, views, sequences, stored procedures, and

Oracle constraints (constraints) affect the query plan, oracleconstraints

Oracle constraints (constraints) affect the query plan, oracleconstraintsOriginal article: http://www.oracle.com/technetwork/issue-archive/2009/09-may/o39asktom-096149.htmlHow constraints in oracle affect the query planIt is generally considered

About Dynamic Sampling (Dynamic Sampling), dynamicsampling

About Dynamic Sampling (Dynamic Sampling), dynamicsamplingDynamic Sampling) Original article: http://www.oracle.com/technetwork/issue-archive/2009/09-jan/o19asktom-086775.html This article will answer: What is dynamic sampling? What is the function

Oracle user password, oracle user password

Oracle user password, oracle user password How to change the user password in Oracle In the Oracle database, use alter user to change the user password. Syntax Alter user user_name identified by new_password; Parameter description:

Non-clustered indexes solve the deadlock problem in big data search,

Non-clustered indexes solve the deadlock problem in big data search, I read a blog by Li you two days ago about SQL Server deadlock. Original article: http://blog.csdn.net/senior_lee/article/details/42275565. 1. Topic description First lookProblem

Oracle query does not mean that the condition contains null values. oracle query contains null values.

Oracle query does not mean that the condition contains null values. oracle query contains null values. Requirement: currently, the is_use field in the oracle database has the following values: null, 0, 1, and 2. Now you need to query data not equal

Linux does not allow MySQL to distinguish the case sensitivity of table names.

Linux does not allow MySQL to distinguish the case sensitivity of table names.Problem description: Today, a project database is transplanted to the liunix server, and the table cannot be found. The query database does exist. After analysis and

A thrilling Percona XTRADB Cluster data restoration process [MySQL], perconaxtradb

A thrilling Percona XTRADB Cluster data restoration process [MySQL], perconaxtradbA thrilling Percona XTRA Cluster DB data restoration process At noon on January 27, the phone rang and was called by YI, a colleague. He told me that there were a lot

Today is much faster than half past one.

Today is much faster than half past one. Yesterday, I helped my former colleague optimize an oracle database. Today I asked the engineers at the site: What feedback does the customer have when doing business? Then, the engineer at the scene replied:

Total Pages: 1013 1 .... 308 309 310 311 312 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.