Oracle Database hang instance analysis

Oracle Database hang instance analysis Symptom: Neither common users nor sysdba can log on, resulting in service interruption. Analysis process: 1. Do hanganalyze and systemstate dump first $ Sqlplus-prelim "/as sysdba" SQL> oradebug setmypid

A simple test of orion

A simple test of orion Orion is a small I/O testing tool that can test random read/write and simulate mixed loads. This tool is already included in Oracle 11g, and does not need to be installed any more. It has brought a lot of convenience for I/O

[ERROR] ORA-09945, ORA-09817 disk space is insufficient

[ERROR] ORA-09945, ORA-09817 disk space is insufficient I. Problem DescriptionWhen you use client software to connect to the database, a ORA-09945, such as, is reported as there is no space as prompted. When using sqlplus to connect, an error

TimesTen memory fragmentation (high water level) recovery steps

TimesTen memory fragmentation (high water level) recovery steps Memory is the most important resource in the TimesTen memory database, just like the Oracle database we are familiar with has only one System tablespace; unfortunately, the memory

Install, configure, and apply MySQL 5.7 in CentOS 7

Install, configure, and apply MySQL 5.7 in CentOS 7 MySQL 5.7 and earlier versions have some differences. The complete installation, configuration, and application process of MySQL 5.7 in CentOS 7 may be useful for beginners.The installation

MySQL 5.6.x multi-instance Configuration

MySQL 5.6.x multi-instance ConfigurationPrerequisites For testing, the installation is in binary mode, which is simple, convenient, and fast.MySQL-5.6.x binary version installation record I do not like to configure multiple instances in mysqlmulti

Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19)

Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19)Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19) I. Preparations 1. database environment Operating system version: RedHat 5.8x64Database Version: Oracle 10.2.0.5 x64 RACCluterware: 10.2.0.5Oracle

Detailed description of Redis info Parameters

Detailed description of Redis info Parameters The official Redis website has clearly explained info. Refer to the documentation. As you can see, the output result of info is several pieces, including Servers, Clients, and Memory. You can specify a

A simple MySQL performance query script

A simple MySQL performance query script A simple MySQL performance query script is as follows: #!/bin/shmysqladmin -P3306 -uroot -p'password' -r -i 1 ext |\awk -F"|" \"BEGIN{ count=0; }"\'{ if($2 ~ /Variable_name/ && ((++count)%20 == 1)){\ print

Import (Restore) Oracle dmp files to different tablespaces and different users

Import (Restore) Oracle dmp files to different tablespaces and different users Copy A dmp backup file from the production environment, build a test environment on another computer, and run the imp command to import the dmp file with the following

Redis Cluster Study Notes

Redis Cluster Study Notes Redis officially introduced the cluster feature in version 3.0. Redis cluster is a distributed (distributed), fault tolerant (fault-tolerant) Redis memory K/V service, A cluster can use a subset (subset) of the functions

MySQL Log File Type

MySQL Log File Type Introduction: MySQL provides various types of log files that reflect different MySQL information and are necessary to understand them. 1. Error log (Error log) The error log records all severe warnings and error messages during

MySQL query database size

MySQL query database size Step 1: First open the Mysql Command line and choose Start Menu> program> MySql-Command line client, as shown in Figure 1-1: Figure 1-1 Step 2: Enter use information_schema 1-2 in the command: Figure 1-2 Step 3: view the

Oracle manual fixed SQL Execution Plan

Oracle manual fixed SQL Execution Plan During the O & M process, we often encounter Oracle CBO selection rather than the expected execution plan due to changes in data and statistics of Oracle, the following is a record of the manual execution plan.

MySQL Cluster in a MySQL Cluster

MySQL Cluster in a MySQL Cluster1. References 2. Introduction MySQL-Cluster is a technology that allows you to deploy "in memory" database clusters in a non-shared system. Without a shared architecture, the system can use cheap hardware without

MySQL 5.7 JSON support

MySQL 5.7 JSON support Recently, a business needs to store Json and perform some simple business logic processing. I have found that it is difficult to use mysql 5.6 for json data analysis. It is very difficult to simply store data. I have no way to

Install the stress testing tool swingbench in Linux

Install the stress testing tool swingbench in Linux Many people may have a irrational idea about graphic tools. They feel that as long as a graphic interface is used, the technical content is lost, and the graphics can be a little bit of something,

ORA-01110 error caused by standby database query and Its Repair

ORA-01110 error caused by standby database query and Its Repair Recently, it helped the business department solve a technical problem because it needed to analyze the problematic data to discover data problems. Of course, one difficulty is to filter

10 things you should know about NoSQL Databases

10 things you should know about NoSQL Databases Since the 1/4 century, relational databases (RDBMS) have been the mainstream database models. But now non-relational databases, "Cloud" or "NoSQL" databases, are gaining an increasing share as an

The method for assigning values to SQL fields unrelated to the business in the CRUD operation, crudsql

The method for assigning values to SQL fields unrelated to the business in the CRUD operation, crudsql Improving efficiency has always been an eternal topic. One of the topics in programming can also mention efficiency, that is, focusing on one

Total Pages: 1013 1 .... 63 64 65 66 67 .... 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.