Database Administrator

ORA-12520 error resolution instance Problem description: An error was reported when I suddenly found a connection to the database today. When I use pl/SQL dev to connect to data, sometimes I can connect to the database. Sometimes I can report the

Oracle user name and password Modification After the Oracle database is copied or cloned, you often need to modify the user name and password. The following describes the modification methods and steps: 1. query the table USER $ Select name, USER

Create and apply PL/SQL packages Create and apply PL/SQL packages ① IntroductionA package is a combination of PL/SQL programming elements, such as related processes, functions, variables, constants, and cursors. It has the characteristics of an

Oracle locks the temporary table statistics and whether the hint can be dynamically collected after the lock The statistical information of the global temporary table cannot be collected. If it is collected, its statistical information must be 0,

Innobackupex full backup database For MySQL Database Hot backup, xtrabackup is the best choice except MySQL enterprise backup. This tool provides Hot Backup Based on the innodb Storage engine, supports full, Incremental backup, partial backup, point-

How to configure an ACL report ORA-24247 Preface: ORA-24247 errors when sending messages to external via Oracle 11, detailed error messages are as follows: ERROR at line 1: ORA-24247: network access denied by access control list (ACL) ORA-06512: at "

Java Redis and javaredis The related concepts of Redis are not introduced. You can also understand Memcached first, and then compare the differences between the two, so you will have an overall impression. The server usually chooses Linux, and

ORA-01591: lock held by in-doubt distributed transaction troubleshooting, ora-01591in-doubt Oracle errors occurred when running the batch data program yesterday: $ Tail-f INDB_ERROR_8.LOG[Time] 2014-12-01 04: 10: 31: activeAccountDeposit in oracle

Common Redis commands-INFO, MONITOR, SLOWLOG, and redisslowlog Author: zhanhailiang Date: 2014-12-02 1. INFO The info command returns information about the server, including: Server: General information about the Redis server Clients: Client

Lo exception: The Network Adapter cocould not establish the connection, myeclipseestablish (1) recently it was really depressing to use DB Browser in Myeclipse, but the teacher encountered the following problems: (2) then hurry up to Baidu and

Oracle Database accidental deletion recovery method, oracle Database accidental deletion 1. If you just accidentally delete some data or a piece of data, you can use 1. If select * from is deleted by mistake, it indicates the where query condition

Oracle startup error ORA-00845: MEMORY_TARGET not supported on this system solution, memorytarget Oracle start error ORA-00845: MEMORY_TARGET not supported on this system Possible cause: the ORACLE MEMORY_TARGET parameter exceeds the memory of the

[MySQL Case] tpcc test -- run tpcc_start to report Segmentation fault and segmentationfault Original article URL:Http://blog.csdn.net/jason_asia/article/details/41543947 [Error message] An error occurs during the tpcc_start test: Tpcc_test.sh:

[MongoDB] Seven major implementation skills of MongoDB and seven major mongodb skillsTip 1: using the correct type to store data with the correct type is of great benefit. The data type affects the data query method, data storage sequence, and

Blue growth note-chasing DBA (11): After going home, I woke up and went home.   Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be

Mysql common time functions Reprinted please indicate the source: curtain roll west wind column (http://blog.csdn.net/ljxfblog) Recently, I have been playing the game back-end tool for some data statistics work. I have used a lot of mysql time

When synchronizing transactions and snapshots, the system prompts: When IDENTITY_INSERT is set to OFF, the displayed values cannot be inserted to the table. (Source: MSSQLServer; error code: 544 ), Cause: During SQL2008 synchronization to

Basic SQLite operations, sqlite operationsSQLite basic operations: database creation, table creation, data insertion, data modification, data deletion, table deletion, and database deletion. 1. Enter sqlite3 test in the command line to create a

Vertica interrupt session, vertica session When using Vertica, you often encounter the need to forcibly end or interrupt a time-consuming query. In this case, you can use the INTERRUPT_STATEMENT () provided by Vertica () INTERRUPT_STATEMENT requires

Intent is called by the intent browser for telephone and browser calls. 1. Create an xml file and button Android: orientation = "vertical"Android: layout_width = "match_parent"Android: layout_height = "match_parent">Android: id = "@ +