Database Administrator

The following error is reported in the Oracle warning log: ReferenceORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [], []Current SQL statement for this session:Select value from NLS_INSTANCE_PARAMETERS where

I. Windows Environment 1. Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql on the computer of localhost, and change the "host" entry in the "user"

In Java Development, when using Oracle database, it is often encountered with ORA-01000: maximum open cursors exceeded. Error. In fact, the cause of this error is mainly caused by code problems. Ora-01000: maximum open cursors exceeded. Indicates

Mysqldumpslow:Died at/usr/local/mysql/bin/mysqldumpslow line 161, <> chunk 236. Conclusion: The number of top jobs is too large, and mysqldumpslow cannot be traversed. /Usr/local/mysql/bin/mysqldumpslow-s-t 15/root/db01-102-slow.log 1. Try removing

Jessonlv-lu guodong Original article, reproduced please indicate the source: http://blog.csdn.net/jessonlv The interview questions I encountered during the interview mainly focused on the joint query of SQL. google made a mistake, but I fixed the

Oracle 12C has been released... Next I will learn about silent installation and configuration of Oracle 12C and the example users. Installing Oracle 12C in Linux-6-64 New Features of Oracle 12C: Paging Query 12 new features of Oracle 12C 1. Obtain

Introduction Recently, a project is being developed. The database used by the project is oracle, and the old version of this project uses sqlserver. Unfortunately, only mysql is installed on my computer. However, these three databases are urgently

Note:I originally wanted to create a replica uard test for the no target database by using the backup set of the target database. I found that it could not be implemented in principle, but it has a very useful function, allows you to quickly recover

Steps for migrating a single Oracle DataBase instance to Oracle RAC: -------------------------------------- Split line -------------------------------------- Detailed illustration of the entire process of VMware + Linux + Oracle 10G RAC Install

Normally, when the current control file is lost or the current control file is inconsistent with the control file to be restored, we need to re-create a control file or use unsing Backup controlfile to restore the control file. To put it simply, as

When we use the MySQL database, we may encounter many unexpected damages to the database table, and the data is new data. We usually look for the backup data, but in general, it cannot be found. This chapter describes how to detect MySQL database

I. Preface After the new installation of SQL Server 2005/2008, We need to configure SQL Server Based on the Server's hardware and software facilities to achieve better performance. However, the default configuration is used in most cases. Ii.

BKJIA: You may have seen this message in some places. Facebook has developed a new social inbox, integrates email, instant messaging, text messages, text information, and Facebook site information. Most importantly, they need to store 135 billion

I haven't updated my blog for a long time. One reason is that the technologies used in the development projects are old technical points, and the knowledge I have come into contact with is the logic process of the industry, so I just made a summary

Index: You can use indexes to quickly access specific information in database tables. An index is a structure that sorts the values of one or more columns in a database table, for example, the name column of the employee table. If you want to search

In a large database, performance has become one of the focuses of attention. How to Make the efficient and effective operation of the database become an issue that must be considered by database administrators and developers. Performance is the

Currently, the following technologies or solutions are available for remote replication and Disaster Tolerance of oracle databases: (1) Disaster recovery replication solution based on the storage layer The replication mechanism of this technology is

MySQL4.1 supports encoding, so it is a little troublesome to convert old data. However, you only need to pay attention to the following: 1. dump the original data before conversion. Generally, the original data is encoded in gb2312 format. The dump

Bkjia.com comprehensive report tips and tips: how to deploy operational business intelligence solutions for your Enterprise PrefaceChapter 2: transforming data explosion into business intelligenceChapter 2: Operational BI-opportunities for

There are many reasons for slow query speed in SQL Server databases. The following are common causes: 1. No index or no index is used (this is the most common problem of slow query and is a defect in programming) 2. Low I/O throughput, resulting in