Today there is a customer that had a database error, let me see. Error: 1601, Severity: 17, State: 3 There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator t
database configuration, open database, maximum connections, maximum number, database system, parameter name, intervals, database error, transaction log, system administrator, case need, drawback, severity, human intervention, case log, server message, sybase database, message number, database option, error 1601October 22
First check D: \ oracle \ product \ 10.1.0 \ Db_1 \ NETWORK \ ADMIN in the tnsnames.ora file. Has the following configuration files ORCL = / / can take the individual to the database instance name for PL-SQL in the log when the value selected in the
database instance, instance name, oracle database, oracle product, data server, logical structure, control permissions, pl sql, drawback, default table, database files, database security, table space, physical database, network admin, connect data, log time, database description, allocation table, logical areasOctober 9
Am finally out of the environment in which to spend the linux fcitx the English. Take a lot of costly mistakes. Why do we have in English environment? Chinese environments fcitx or sicm are very easy thing, installed ready for use. But the Chinese en
premise, ctype, command prompt, yum, server configuration, fedora, drawback, system registry, configuration command, chinese environment, readme, costly mistakes, gnome, command shell, english environment, shell programs, cd profile, shell interface, desktop linux distributions, sicmOctober 9
For the select, poll, epoll know not by much, the following is from "Building high-performance Web site" excerpt introduction, and so after the real exposure to select, poll and epoll write in detail about the development of the use of the diffe
data storage, cross platform support, address space, maximum number, multiple file, epoll, linear growth, replication, performance web, drawback, file descriptor, system call, time delay, active state, storage structure, select system, macro definition, tcp connections, linear scan, network response timeOctober 2
1 install a digital certificate Execute java InstallCert test.ldh.com: 443 Download digital certificate, InstallCert.java Annex, test.ldh.com you tune into the interface of the domain name, the certificate only needs the next time the machine can be
quot, jdk, interface, lib, protocol, annex, domain name, time 2, drawback, class implements, client certificate, digital certificate, security directorySeptember 27
Because business needs, repair to modify a field data types are number (5), into a number (5,2)-type If no data, then the following statements can be directly alter table tb_test modify permile number (5,2); But data can not be used if the above meth
column name, oracle, migration, premise, data types, column names, table test, drawback, redefinition, drop column, tb testSeptember 26
Database indexes to increase query speed and additional fields in a table identifier. Many people understand the concept of indexing machinery, that an increase in the index can only be good. In fact, as far here as much detail as some of its introdu
principle, sql statement, match, default method, execution, absence, index case, storage space, full table scan, drawback, speed optimization, size comparison, companyname, word section, database indexes, search result, field query, scan lineSeptember 26
ConcurrentHashMap and CopyOnWriteArrayList comparison. Blog categories: Java ConcurrentHashMap ConcurrentHashMap introduced Segment, each Segment is a hashtable, the equivalent of two Hash table, and then lock in the Segment level, and increased conc
implementation, data storage, map, object reference, implements, interface, efficiency, conflict, elements, opera, hash table, iteration, reference point, hashtable, drawback, random access, data segment, entire collection, accurate dataSeptember 18
Slackware version: Slackware 7.0 and above Slackware uses BSD-style init script, and many other distributions use System V style init scripts. SysV and BSD scripts are able to make people read, that they are shell scripts, not compiled program. The m
parameters, bind, many things, squeeze, startup script, shell scripts, drawback, script execution, symbolic link, distributions, startup scripts, script design, style scriptSeptember 7
23 commonly used in Java Design Patterns 1, the factory pattern: separate customer classes and factory class. Consumers need a product at any time, simply a request to the factory. Consumers can not modify the admission of new products. The disadvant
model model, hierarchy, subclass, instances, model mode, prototype object, construction mode, abstract factory, internal representation, original model, category product, hierarchical structure, java design patterns, customer classes, drawback, singleton pattern, product creation, product category, object construction, construction stepSeptember 6
1 Why should I use LVM In LVM, before the system administrator (referred to as SA) should be aware that although traditional disk management has played good enough to use fdisk can directly create, delete partitions, but the traditional disk manageme
data transmission, positive integer, hard disk, system administrator, drawback, storage unit, storage management, lvm, volume group, physical volume, logical storage, partitions, disk management, logical partition, aix system, explosive growth, logical volume management, logical volume manager, management storage, external hard driveAugust 27
PCTUSED parameters: When the actual data block (block header information and datas data) occupies the space below the set value will be added to the freelist. For example, PCTUSED = 40. However, deleting data, the remaining space is greater than (1-4
oracle, parameters, migration, pointer, data space, drawback, datas, space utilization, ssd, access oracle, pctfree, water level, freelist, space reference, frequent need, availabeAugust 22
Select the cloud: shop around 2011-8-15 Author: David Strom Translator: Liang Yingzong Source: TechTarget to China I want to comment Share: Digg This English-language blog references | Medium | Small REVIEW: This article covers the Amazon, Verizon, G
vm, storage size, translator, english language, loading data, first instance, estimates, drawback, virtual machines, culprit, fuss, amazon web, virtual private network, pricing model, network vpn, verizon, david strom, environment area, maner, rackspaceAugust 18
1 Chinese-style Dashboard Chinese-style reporting and Dashboard have a lot of similar place. Mainly used to display summary data. Most appear in the page (screen), closely arranged. Used to make a quick comparison of data and scanning. The biggest di
interface, target, advantages and disadvantages, accuracy, queries, instrument panel, dashboard, deficiencies, sales staff, shortcomings, drawback, effective solution, style text, chinese style, style statements, scan data, compactness, relative change, style reportsAugust 17
Tried to use scp for file transfers, this command is better, not the machine or what services are installed on the client machine, but has a drawback, the need to manually enter the password I set on the server had a plan A, weekly a copy command, th
localhost, key generation, google, linux, administrator privileges, 5d, drawback, rsa keys, key file, file transfers, local host, 4d, split line, fingerprint, server backup, backup directory, host usersAugust 10
Within the department to implement code review in this activity a few months ago started looking for tools to support the beginning of this phase is jupiter eclipse plug-in the beginning also wrote a user guide (see annex), but later I found It is cl
first experience, lt, quot, eclipse, img src, code quality, management tool, file format, dashboard, scm, quality management, static code, core function, drawback, findbugs, jupiter, pmd, personal assessment, stage activities, team assessmentAugust 9
This article comes from: http://hi.baidu.com/suofang/blog/item/e45d5a4e883e9e07b3de0519.html Is to generate a GUID it? SQL> select sys_guid () from dual; SYS_GUID () -------------------------------- F18031C69D8345DEB305D4B2E796A282 You can put a tabl
import java, java util, string args, main string, public class test, 10 million, random number, key field, drawback, core idea, current date, digits, java reference, ethernet card address, open software foundation, clock sequence, chip id, tianya cn, global import, nanosecond timeAugust 1
Blog: obsolete or irreplaceable? More than a decade since the advent of blog, this was once considered the most influential web2.0 new media now seems to gradually lose its irreplaceable position. With SNS, micro-blog, and so the emergence of new onl
current events, emergence, business model, share information, shortcomings, higher degree, drawback, advent, grass roots, operational elements, model change, time update, web2, social networking sites, consumer internet, social networks, authoritative voice, core strength, challenger, enormous challengesJuly 24
Virtual machine through the host computer in several ways: 1, Bridged (bridge) mode, if the host is through the LAN access the Internet, allows the virtual machine using the host network segment, the same gateway and DNS settings, use a valid LAN IP.
first approach, virtual machine, bridge mode, drawback, network settings, network segment, virtual nic, local connection, nat gateway, host computer, host network, gateway ip, dns settings, network cable, dhcp service, virtual network adapter, virtual card, win98 system, tcp ip settings, shared connectionJuly 12
Third, the development stage First, the configuration management tool There are a lot of code management tools, and now the company with more than code management tools CVS, VSS, SVN. For a team is only 2-5 individuals, and this is the same office tw
apache, eclipse, cvs, open source, technical staff, gnu org, linux, development stage, svn, code management, version management, configuration management tool, management tools, source organization, drawback, systems architect, x86 linux, tortoisecvs, woe, directory recordJune 14
Official module description: http://wiki.nginx.org/HttpUpstreamModule http://www.howtocn.org/nginx:Nginx% E6% A8% A1% E5% 9D% 97% E5% 8F% 82% E8% 80% 83% E6% 89% 8B% E5% 86% 8C% E4% B8% AD% E6% 96% 87% E7% 89% 88 Talk about the upstream in the server
server default, hash, load balancing, response time, nginx, chronological order, default configuration, e5, e6, drawback, 8b, 8c, heartbeat, error type, command server, incoming requests, server command, server group, unsuccessful attempts, backup serversJune 13
Optimistic locking and pessimistic locking is the corresponding, so to talk about optimistic locking, it is inevitable to talk about what is pessimistic locking, optimistic locking is what? The so-called pessimistic locking is that the query after th
failure, concurrent users, life cycle, queries, application logic, data processing, cursor, probability, realization, isolation level, drawback, database concurrency, time period, pessimistic locking, transaction time, database applicationJune 10
tmp_table_size If the in-memory temporary table exceeds this value, MySQL automatically converts it to the hard disk MyISAM table. If you perform many advanced GROUP BY queries and there are a lot of memory, you can increase the value of tmp_table_si
variable name, variables, xxxx, ini, size 16k, buffer size, hard disk, server configuration, mysqld, session scope, drawback, memory heap, information show, dynamic changes, table space, cnf, maximum size, memory table, max rows, advanced groupJune 7
http://blog.csdn.net/tianlesoftware/archive/2009/10/15/4677378.aspx http://ajava.org/readbook/db/oracle11gjctg/5762.html In Oracle 10g which, is the introduction of flashback version query, flashback transaction query, flashback database, flashback t
query object, high availability, point in time, data changes, oracle 10g, oracle 11g, complement, drawback, storage area, space requirements, new member, availability database, database objects, flashback, database change, transaction query, policy settings, data archive, archive area, protection strategyJune 5
Requirements: Required database objects (eg: Table, Trigger, View, Function, StoredProcedure, etc.) to migrate to the same database server or a remote database server, and renamed required to support migration, and migration of certain objects can be
implementation, amp, configuration files, migration, two ways, match, database server, interactive mode, batch file, mode 2, database object, script form, database script, drawback, relationship between objects, database backup, database objects, ps1, club secretary, powershell scriptsMay 31
The model was to address resource allocation ﹑ frequent problems caused by the release. To address these problems, you can use database connection pool. The basic idea of the database connection pool is to establish a database connection "pool.&quo
database connection, data source, c3p0, lib directory, performance test, google, database connections, connection pool management, maximum number, performance tuning, jakarta commons, test report, two versions, server configuration, jdbc drivers, drawback, resource allocation, buffer pool, java connection pool, frequent problemsMay 28
TokyoTyrant MemcacheDB TreapDB Redis LightCloud Berkeley DB MongoDB Cassandra Voldemort First, read and write performance to meet the high demand for Key-Value Database Key-Value performance of the main features of the database is a highly concurrent
memory database, data structures, key value, berkeley db, database data, memcached, useful functions, drawback, mass data, asynchronous operation, physical memory, functional version, memory operations, cassandra, maximum limit, extensibility, 1mb, intersection of sets, performance message, value performanceMarch 31
offers three advanced backup oracle advanced replication (Advanced Replication) Stream replication (Streams Replication) Prepared by the library (Dataguard) A dataguard: high availability and disaster recovery in terms dataguard generally dba choice,
oracle, storage, operating systems, high availability, ddl, mode 2, technical characteristics, drawback, disaster recovery, streams, competitor, management costs, heterogeneous environment, investments, flexible replication, replication strategies, standby database, existing equipmentMarch 21
Sometimes, this thing can omit a lot of things ~ INSERT INTO table (column_a, column_b, column_c) VALUES (1, 2, 3) ON DUPLICATE KEY UPDATE column_c = column_c + 1; A better way to add or update MySQL rows Recently, we needed to iterate over a fairly
memory, database server, table column, syntax, queries, dataset, timestamp, drawback, unique key, c valuesMarch 3
1. Avoid hard parsing - use a prepared statement (JDBC in use PreparedStatement) (2) avoid soft parse - reuse the prepared statement (JDBC PreparedStatement in the run does not close after next check occasionally also the object database) 3 The clien
quot, connection pool, jdbc, oracle, preparedstatement, server side, object database, optimize, parse, database engine, prepared statement, cursor, drawback, bind variables, fuss, oracle database serverMarch 1
1, if the field is simply a big change, such as numeric (16,2 )---> numeric (16,4), can be directly alter table table name modify (field name numeric (16,4) 2, due to changes in demand, now to a type NUMBER (8,2) field types to char. General idea is
column name, oracle, migration, field names, type conversion, premise, data types, table test, general idea, number 8, drawback, type changes, drop column, update table set, tb testFebruary 28
GROUP BY clause there is a drawback, is that the returned result set only aggregate data, without detailed records of the original. If you want to do this in SQL SERVER, you can use the COMPUTE BY clause. COMPTE generate a summary of the total listed
select statement, conjunction, drawback, final result, clauses, statistical functions, front row, sum total, aggregate data, detailed records, initial termFebruary 11
PERCONA PERFORMANCE CONFERENCE 2009, and several engineers from Yahoo, brought an " Efficient Pagination Using MySQL "report, there are many bright spots, this article is based on the further extension of the original. First look at the pages of
lt, sql statement, quot quot, efficiency, len, pagination, desc, yahoo, message type, drawback, clue, type index, scan lines, line performance, bright spotsJanuary 20
Introduction: Before the downpour with a paste (http://www.iteye.com/topic/143714) discusses how to use mysql in java the master-slave mode (master-slave mode description, see Qieqie this paste: http:// www.iteye.com/topic/162717), which greatly that
java code, java sql, production environment, datasource, props, main string, singleton, master slave, shortcomings, downpour, drawback, hack, mode description, mysql jdbc driver, slave mode, tutorial javaJanuary 11
Simple needs analysis: 1 to achieve unlimited classification. 2 for unlimited level navigation links 3 to achieve progressively classified information under various inquiries, including the most page views, up to comment on the amount of the latest i
inquiries, query time, implementation class, parameters, parent id, auto increment, category classification, drawback, recursion, cid, page views, level navigation, classification level, information url, classification tableJanuary 5
Turn http://hi.baidu.com/wschao2005/blog/item/fe037089d5a18eb80e2444ad.html High Water Mark (HWM) means that when we build a segment of time, an indicator within the segment, defining the segment has been configured within the block level. Segment ha
data storage, oracle, oracle 9i, decline, indexes, full table scan, level segment, drawback, segments, segment name, redefinition, buffer pool, high water mark, water level, scan time, hwm, auto segment, water levels, fts, reservoirsDecember 30
Determine success of the project's core role? I consider the three roles: project manager, technical manager and demand manager. Project Manager: how to solve management problems, the progress of the project and responsible for the quality. Specific
change management, project success, management quality, management problems, validation requirements, design verification, quality management, marketing departments, drawback, verification and validation, technical feasibility, technical solutions, quality technology, feasibility assessment, core elements, core role, troika, prioritization, control risk management, business project managerDecember 10
Because there is a demand to study the next redis, a high-performance of key-value database. Here the record about it, need it to prepare for follow-up time has also brought to share with you. Redis is essentially a type of Key-Value-memory database,
memory database, data structures, high performance, key value, database data, memcached, hard disk, useful functions, drawback, mass data, asynchronous operation, physical memory, functional version, memory operations, maximum limit, 1mb, performance operation, performance message, range sort, support preservationNovember 28
Tangle of the place; a latitude of 7, the other a latitude is 7, but have a duplication; collection of latitude is 100 +, but also too much, two have? How to integrate it; full join; that you can take advantage of are taken out; weight after 7 to 8 +
yyy, drawback, emp, debut, latitude, col1, sal, tangleNovember 11
Others written in SQL to improve the efficiency of a good summary of the method, very practical, down In the massive data tables, each table has a basic or more indexes to ensure efficient query, the index during the ETL process needs to use the foll
oracle sql, efficiency, index column, gt 4, data tables, sql data, cursor, better solution, indexes, insertion, full table scan, drawback, mass data, massive data, emp, optimizer, dbms, oracle9i, index function, index columnsNovember 3
1: index, our first thought is to create an index, an index can be multiplied to create a query to enhance efficiency and save time. However, if the data is too great amount of time, this time simply to create the index is useless, we know that if a
efficiency, primary key, first thought, query data, avail, serial number, queries, amount of time, indexes, drawback, emp, query optimization, statistical query, invalid indexOctober 28
Oracle Dataguard provides three data protection modes, respectively, to sum up in three data protection mode features. 1. Maximum protection mode 1) This mode provides the highest level of data protection; 2) requires at least one physical standby
logs, emergence, database transaction, master database, default mode, maximum performance, drawback, library services, main library, compromise approach, standby database, protection mode, mode features, library libraries, maximum availability, maximum protection, submission requirements, oracle dataguard, library transactions, library equipmentOctober 19
Promote software progress in the end? It is said that the software they are big lazy cow, because lazy and invent new things, so we too lazy to benefit, too lazy to bear fruit. Also said to be enthusiastic, passionate or something? Sound is not too p
string type, quot, c language, data structures, basic elements, software progress, invention, drawback, cattle, language language, human nature, phenomena, complicated question, brief history, atl, 1960s, 1990s, databases tools, history of windows, lazy cowOctober 7
First, an overview I believe a lot of people often ask the same question: When MySQL The total number of records more than 100 million later, there will be a significant decline in the performance of it? The answer is yes, but the performance> of the
throughput, system architecture, time interval, decline, queries, server hardware, drawback, single file, column values, outdated data, 100 million, aggregate functions, partitions, system partition, partition function, range partition, apparent advantagesOctober 1
EXISTS, IN and JOIN Performance Analysis EXISTS, IN and JOIN, can be used to achieve the form "A table in the query (or not) B records in the table," the query logic. In the forum to see a lot of people are misunderstanding (such as in the doubt
two tables, doubts, test code, execution time, test test, high efficiency, query field, external connections, simple test, drawback, performance analysis, query execution, implementation plan, query logic, execution plan, time ratio, resolution mechanism, unwanted results, intuitive logic, programming suggestionsSeptember 27
Database indexes to increase query speed and added a field to the table identifier. Have seen many people understand the concept of indexing machinery, that an increase in the index can only be good. This study notes the index before trying to sum up
implementation, sql statement, match, optimization, default method, execution, absence, index case, storage space, full table scan, drawback, size comparison, companyname, word section, database indexes, database index, field query, scan lineSeptember 26
http://www.bitscn.com/pdb/oracle/200810/152282.html A: sql loader features oracle himself with a lot of tools can be used for data migration, backup and recovery work. But each tool has its own characteristics. For example, exp and imp data in the da
oracle, bind, blob, oracle sql, oracle database, data migration, export import, raiders, drawback, little trouble, database backup, password control, recovery tool, oracle corporation, logical records, discards, versatile tool, imp data, export work, oracle issuesSeptember 17
sql loader can store some data in text format smoothly into the oracle database, is a kind of data migration between different databases is very convenient and versatile tool. Drawback is slow, the other types of data on the blob so little trouble. s
database sql, oracle, orcl, blob, two ways, yyyy, oracle database, source data, data migration, users log, file upload, csv file, batch file, dd, drawback, little trouble, pl sql developer, truncate, login date, versatile toolSeptember 17
imp import data specified table space, roughly the following ways: 1. There is a simple method for the data relatively few cases: the direct use UltraEdit to fight side DMP file, the default is hexadecimal, switch to text mode, the inside: TABLESPACE
schema, table structure, database tables, implementation methods, empty database, export table, user1, drawback, data tools, text mode, toad, dmp files, table space, pl sql developer, developer tool, user2, ts1, export tables, export user, log cSeptember 10
Today in the All Programs menu option to enter the oracle, suddenly can not find it on their own ways to do one, just create a bat file, enter the command: F: \ oracle \ ora92 \ bin \ oemapp.bat console One path can be changed to your own oracle inst
oracle, interface, installation path, drawback, menu option, enterprise manager, oracle installationSeptember 7
icefaces datatable within radiobuttonrestart samba ubuntu 10.4DELL Can not find script file C:remindpopup2.vbsquartz SQLCODE=-911, SQLSTATE=40001indexdb serverhppt: shared.comhttp: 202.196.97.25 vvis cicx.asphttp: url.cn dlL4Ashuawei ec1308 iptvORA-12170 Location: