Database Administrator

TNS-03505 name cannot be resolved TNS-03505 name cannot be resolved Symptom: [Oracle @ db01 admin] $ tnsping pri  TNS Ping Utility for Linux: Version 11.2.0.4.0-Production on 15-JUN-2015 21:57:52Copyright (c) 1997,201 3, Oracle. All rights reserved.

Collection iterator pickler fetch appears in the execution plan Today, when I used explain plan for to view the SQL Execution plan, the following strange execution plan appeared: SQL> explain plan for select * from test where object_id = 100;

Comparison of write time consumption between MongoDB3.0.6 wiredtiger and MMAPv1 EnginesI. Business Requirements: the database of an APP of the company has vertically separated logs from the business, splitting the original RAC into two sets.

MongoDB3.0.x user authorization configuration (standalone environment) By default, the MongoDB database does not have permission control. It can be accessed by connecting to the opened port and has root-level permissions; the production environment

UI 19 database exercises, ui19 database exercises When you click "add to Favorites" for a movie, you can determine whether it is added to the favorites folder.Delete and insert a favorite movie.Create a DataBaseTool # Import # import # import

Mysql table fragmentation cleaning, Mysql fragmentation cleaning Mysql has recently declined in the production environment, and some SQL statements are also slow. First, check whether the slow query log is enabled.Show variables like 'slow _

Basic operations of mongodb and basic operations of mongodb Install mongodb in http://blog.csdn.net/u011575570/article/details/47791135Including linux and WindowsThe following are some basic operations:/Usr/local/mongodb/bin/mongo # Start

Oracle (zero) --> pseudo-column and group aggregation (starting from Oracle, relatively beginner ~), OracleIn the beginning ~It's time to start school .. What does it have to do with me ..), After all, I took up my job even though I didn't know what

Mysqldump: Got error: 1045: Access denied for user 'roor' @ 'localhost' (using pas sword: YES) when tr, 1. Error description C: \ Users \ Administrator> d: D: \> cd MySQL \ Program Files \ MySQL Server 5.6 \ binD: \ MySQL \ Program Files \ MySQL

Xin Xing sorts out some common non-SQL operations in postgresql. Xin Xing postgresql The operations mentioned here are performed after we use psql to enter the postgresql client. They are not SQL statements, but they are usually important. Below

Modify the mysql password and mysql password 1. If there is no password Mysql-u root Mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass ');2. If you already have a password, you can use: Mysqladmin-u root password "newpass"

Mysql Database SQL Optimization-subquery optimization and mysql Database SQL Optimization1. What are subqueries and table join queries:Subquery: The select statement is used in the select or where clause of the primary SQL statement; select. name,

Combined server test (1) and combined Server TestServer test (1) 1) Advance rehearsals of some services on the Intranet, such as level or point ranking information, pvp data, and pve level ranking. 2) create at least two databases in the intranet

Solution for slow SQL query caused by custom functions, function SQL During the report process, one report queries the exchange rate of the corresponding currency, and the exchange rate is in another table, the condition for querying the exchange

MySQL Study -- Use of MySQL-type tools (MySQL Query Browser), -- mysqlbrowserMySQL Study-MySQL-type tools (MySQL Query Browser)System Environment:Operating System: Windows 7 (64)Official introduction:1. installation and configurationDownload: http://

Oracle Temp tablespace switch, oracletemp I. Functions of TEMP tablespace Temporary tablespace is mainly used to provide temporary computing space when the database performs sorting, index management, access view, and other operations. After the

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

Oracle 11g R2 installation tutorial, oracle11g I, Note that Oracle is divided into two files. After downloading, extract the two files to the same directory. In the path name, it is best not to show Chinese characters or irregular characters such as

There was no endpoint listening at net. pipe: // localhost/PreviewProcessingService/ReportProcessing, endpoint When you develop a reporting service report, an error is reported in the report preview. You can skip this error directly and view the

SQL Server queries all Sundays within a period of time, and SQL Sunday /* Query all Sundays within a period of time @ startdate start date @ enddate end date */declare @ startDate datetimedeclare @ endDate datetimedeclare @ week varchar (20) set @