Database Administrator

Troubleshooting ORA-12516 At work in the morning, my colleague told me that the database can not connect, the prompt "ORA-12516" error, I tried to connect to the database remotely through PL/SQL Developer, and indeed, the error "ORA-12516: TNS: the

PostgreSQL Stream mode construction PostgreSQL Stream mode construction 1. Compile and install Yum install-y gcc-c ++ automake autoconf libjpeg-devel libpng-devel freetype-devel libxml2 libxml2-devel zlib-devel glibc-devel glib2 glib2-devel bzip2

Profile_oracle sets a user password to never expire, and the oracle Password Never Expires Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/46888139   Setting a user password in oracle

Add, delete, modify, and query hibernate associated objects ------ query, hibernate ------ This blog post is the addition, deletion, modification, and query of hibernate-related objects in the previous blog. the settings of this Code have been

Simple sqlite performance test, sqlite Performance It mainly tests the performance of sqlite insertion and query in large data volumes: Test environment: Centos6.4 1 GB memory single-core Data Volume Size Index Field Retrieval (Time

Insert child table fields in Birt dynamically, and insert fields in birt dynamically The database table dColThread is the primary table and the primary key is tID. DColQuestion is a sub-table and the foreign key is tID, as

SQL split string, SQL split string /* The Delimiter is ',' */declare @ depid varchar (100) declare @ location intdeclare @ length int -- Sample string set @ depid = '2017, 13434, 34, 567,12, 9998, 'set @ location = 1 set @ length = 0 while @

Mysql technology insider InnoDB Insert (Insert) operation, mysqlinnodb What is the internal reaction of an innodb table after the client sends an insert command? This article will reveal this story to everyone. Of course, I am not very easy to

MySQL (8) ---------- MySQL thread pool summary (2), mysql Thread PoolThis article is a supplement to the previous article. It focuses on the following two aspects: one-connection-per-thread implementation and epoll usage in the thread pool.

Oracle password management allows a user to log on up to three times with an oracle Password If a user fails to log on three times in a row, the user is locked for two days. After two days, the user can log on again.Create a profile file: Update

Tracking exp with 10046 AND exp with 10046 I wrote a blog about why Oracle expdp is faster than exp. What is the principle? I learned from the official documentation. Now I am going to analyze the exp process through 10046. C: \ Users \

Datazen Map Chart custom data and datazenchart Custom DataZookeeper This article describes how to associate data with Datazen map charts. We map the data in the database to the map.   First, view the data bound to the default map chart. The

Oracle-based SQL Optimization Methodology and oraclesql methodologyThe ultimate goal of SQL Optimization in Oracle databases is to shorten the execution time of target SQL statements. To achieve the above purpose, we usually have the following three

New Features of 11g rman blockrecover, rmanblockrecover Reference:New Rman Blockrecover command in 11g (Recover upload uption list) (Document ID 1390759.1) New Features of 11g rman blockrecover:Note: The blockrecover command for 10 Gb is discarded,

Mongodb Study Notes 01 and mongodb Study NotesMongodb Overview Mongodb is a document-type NoSQL database that stores bson-> json binary. The internal execution engine is a js interpreter that stores documents into a bson structure and converts them

RHEL5.8 if the ext3 file system is damaged, only the file system is not repaired (fsck, RHEL5.8 if the ext3 file system is corrupted, it will only detect and not repair (fsck-n) [root@lei1 ~]# df -ThFilesystem Type Size Used Avail Use%

A small problem with the auto-scaling feature of Oracle 11g partitions, oracle11g It is very convenient to use the automatic partition Extension function in Oracle 11g, but it also brings about a problem, that is, after the export and import, the

Database transactions and Database Transaction ProcessingConcept of database transactionsAn operation between two consecutive successful COMMIT or ROLLBACK is called a transaction. In a transaction, data modifications are committed or withdrawn

A few questions about SQL and a few questions about SQL When we get a question, we are not eager to answer the question. It will not be worth the candle, but to analyze the ideas, methods, and objectives, we also need to think about whether there

Encountered ORA-14047: alter table | index rename may not be combined with other operations error, altertablerename Encountered ORA-14047: alter table | index rename may not be combined with other operations Error [oracle@rhel63single ~]$ sqlplus lc0