Database Administrator

I wrote something in my blog on Ubuntu for the first time. I haven't updated it for a long time. Come here today. The first thing we need to consider when installing Oracle-xe-client is whether the swap partition is large enough,This system does not

When the number of records in the MySQL table exceeds 0.3 million, the following error occurs: "Select * from gll_pro_ru WHERE 1 = 1 order by id DESC Select * from gll_pro_ru WHERE 1 = 1 order by id DESC limit 0,10000 Fatal error: Allowed memory

This is the first time I have installed MySQL on Ubuntu Linux 9.04. I have not installed MySQL before. So I have made some configurations by referring to some network articles. The following is the entire installation process. I. Installation and

I. Check whether the Oracle database is in archive mode:1. select name, log_mode from v $ database;NAME LOG_MODE------------------------------------------QUERY NOARCHIVELOG2. Use the archive log list CommandDatabase log mode No Archive ModeAutomatic

I. Oracle10g provides the ADDM function. It is naturally easy to use em to view the ADDM report. The following two methods are available if you use SQL: 1. The following SQL statement can be used to obtain the latest report. Set long 1000000

Oracle 12C R1 RAC installThis article includes the CRS installation of the Oracle 12C R1 RAC real application Cluster The DATABASE will be installed later, and the entire process of NETCA and DBCA for 12cR1 RAC Recommended reading: Installing Oracle

ORA-01017 When connecting to the database, I don't know if the original server-side program didn't stop, so I encountered a few problems with database connection. It was a bit strange. Later, I re-opened the project and compiled it again. When

MySQL is the most popular database management system in the world and the first choice for programming communities all over the world. It has an interesting series of features and is very good at many aspects. Thanks to its popularity, you can find

Environment:Operating System: RedHat 5.3 64bitOracle version: Release 10.2.0.1.0 The following error occurs when you start a test Oracle Database today:SQL> startupORA-27125: unable to create shared memory segmentLinux-x86_64 Error: 1: Operation

During local DAO tests or unit tests, the db environment is sometimes difficult to implement, and even if the database environment is called, sometimes it does not want to add useless data to the db, spring provides a virtual db environment to

ORA-00257 archiving log error Solution In the actual project encountered a ORA-00257 error (insufficient space error), by looking for information, the vast majority of said this is due to archiving too many logs, occupying all the hard disk space

Oracle 10g provides four regular expression functions: regexp function: REGEXP_LIKE, REGEXP_REPLACE, REGEXP_INSTR, REGEXP_SUBSTR. REGEXP_LIKE: (matched) checks whether a string matches a regular expression.(Srcstr, pattern [,

The syntax for querying the total number of records in a table is select count (*) FROM TABLE_NAME. This may be the most frequently used type of SQL statements. This article discusses how to obtain the maximum number of records. This article is

Oracle databases contain many duplicate items because they do not have any constraints. The question now is how to delete these repeated items. Repeat records only keep one of them. The following table creation statement Create table message_student3

If you have encountered a problem before, you need to retrieve all the file names in a folder and store them in the database. Using a php script to test, read a file name and store it in the database immediately. It took me more than 230 seconds to

Preface In addition to installing the Oracle database software, we often need to install the Oracle client on a host without an Oracle database environment to access the Oracle server over the network. The steps for installing the Oracle Instant

Operating System: 64-bit Linux RedHat 6.3 Environment preparations for installing Oracle 12C 1. Install the dependency package Binutils-2.20.51.0.2-5.11.el6 (x86_64)Compat-libcap1-1.10-1 (x86_64)Compat-libstdc ++-33-3.2.3-69.el6

Oracle self-diagnostic tools play a major role in daily performance diagnosis. Since Oracle 8, Oracle has been continuously promoting the development of comprehensive self-diagnostic kits. From the earliest Statspack to the current AWR and ADDM,

After entering the CBO optimization pipeline, the cost calculation value determines the selection of execution plans. An execution plan with good performance is based on the "appropriate" statistics as much as possible. CBO has gone through two

I. Introduction PostgreSQL is a very complex object-relational database management system (ORDBMS). It is also currently the most powerful, feature-rich and complex free software database system. Some features are not even available in commercial