Database Administrator

C # connect to the SQL Server database For different. NET data providers, ADO. NET uses different Connection objects to connect to the database. These Connection objects shield us from specific implementation details and provide a unified

Oracle maximum connections Session Process Oracle maximum connections Session Process 1. view the processes and sessions ParametersSQL> show parameter processesProcesses integer 50 SQL> show parameter sessionsSessions integer 60 2. Modify the values

Oracle 10046 events 10046 events Oracle 10046 is an Oracle internal event. The most common method is to set SQL _trace (alter Session set SQL _trace = true) at the session level, that is, to enable the 10046 debugging event of level 1. After a 10046

Oracle object type Oracle object typeObject Type In PL/SQL, object-oriented programmers are based on object types. The object type is a user-defined Composite data type. It encapsulates the data structure and processes and functions used to

In Access, case when then else end does not support switch instead. caseswitch In Access, case when then else end cannot be replaced by switch. Here, we mainly implement multiple fields in a table, compare multiple fields, and obtain the maximum or

Oracle query sequence and oracle Sequence Query the sequence of a user, where user_name is the login name of your current database SQL> select SEQUENCE_OWNER, SEQUENCE_NAME from dba_sequences where sequence_owner = 'user _ name '; SEQUENCE_OWNER

If garbled code is not dead, continue to work hard .. I thought I had done a good job in dealing with Garbled text, but on this day I gave me a great deal of weight, which made me suffer, self-contained ..... The garbled characters I mentioned here

Hash and encryption (1), hash Encryption Disclaimer: This article is based on the basic principles and differences of Hash and encryption and the learning and arrangement of engineering applications. 1. Differences between hash and Encryption (1)

MongoDB MapReduce practice , mongodbmapreduce Requirement: a log table in the Mysql table requires an average record cycle of the statistical data. In practice, it may be difficult to use Mysql. Use the MongoDB you just came into contact, I can

MongoDB Reading Notes (via3.0) (05) _ [Sharding] (03) _ the theoretical knowledge of Shard Keys and Hash is small, and mongodbsharding The Shard key and Hash concepts must be written first. Shard Keys The most important thing about mongoDB

How to detach and delete an ASM disk group or an asm disk group 1. log on to RAC database Node 1 as an oracle user: Oracle @ node74: ~> Export ORACLE_SID = + ASM1 Oracle @ node74: ~> Sqlplus sys/xxxxx as sysdba   SQL * Plus: Release

SQL development is a language that is easy to learn but hard to master.Can you briefly describe some database objects used in SQL Server 2000?The answer you want to hear includes the following objects: tables, views, user-defined functions, and

Stored Procedures, database Stored Procedures As mentioned in the previous blog, when the child form overrides the GetdbName method of the parent form, you only need to return the database table to be operated. This blog explains why you only need

SQL Summary 4. SQL Summary Speaking of SQL, the stored procedure is undoubtedly very important. This article will discuss the stored procedure with you. 1: storage process A: stored without Parameters USE testGOCREATE procedure wly -- stored

Database Operations-create indexes, databases-Indexes When receiving a task some time ago, You need to query the existence of a data entry from 10 million data entries within two seconds. I was shocked. 10 million pieces of data! Two seconds! Is

In Linux OS, oracle database and listener are started as the OS is started, and lelistener is enabled.   [oracle@hvrhub hub]$ cat /etc/oratab# # This file is used by ORACLE utilities. It is created by root.sh# and updated by either Database

MsSQL disk space is insufficient.ZookeeperI. How does msSQL errorlog cause insufficient disk space?Execute EXEC sp_cycle_errorlog to generate a new errorlog to overwrite the old errorlog. The errorlog can be overwritten once every 7 cycles.Ii.

Oracle flashback and oracleflashbackFlash back: fixed a logic error and returned from the current point.1. There are dedicated flashback logs stored in the FIA, but they are only used in the database. 2. If a full database flash is performed, it is

Extjs5 memo (1) and extjs5 memo Extjs5 1. Install the portable USB flash drive appache server. Then enter rootdir, clear the directory content, and put your own content. 2. Helloworld Html: Index.html is as follows: Welcome to ExtJS!  

Transaction, transactions Transaction Features (isolation level) A: atomicity. Transactions are an inseparable unit. C: consistency. transactions must change the database from a consistent state to another consistent state. (For example, transfer) *