Database Administrator

Case Study of Oracle Study-view the "strange phenomenon" of shared memory through IPCS" In the Oracle 11gR2 environment, using the ipcs command to view the shared memory, we found that the memory allocated to Oracle is only 4096 Bytes, and this

Oracle 11gR2 ASM single instance installation stepsEnvironment: Platform: VisualBox 4.3.12OS: Oracle Linux 5.8 Grid Infrastructure: 11.2.0.3Database: 11.2.0.3 1. Install the Operating System (omitted) 2. Configure the software installation

Shell batch import MySQL database, batch delete database Due to project collaborative development, my colleague sent an SQL file of the project and opened it in a directory containing hundreds of databases. Each database is used as a separate

What MySQL must think of before creating an index MySQL introduced metadata lock in version 5.5.3His intention is to solve several bugs in the transaction isolation feature of previous versions, but the introduced problems are not small. Let's talk

The random relationship between SQLServer and Oracle corresponds to sqlserveroracle The requirements are as follows: Now we need to complete the singing fields in tb1. The condition is to search for songs sung by the same artist in tb2 and randomly

MySQL can be used to change the root password. Method 1: use the set password command Mysql-u root Mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass '); Method 2: Use mysqladmin Mysqladmin-u root password "newpass" If the root

Full Set of Vue usage methods and vue usage New recruits transferred from an Oracle DBA to Mongodb follow the Oracle Learning Style Start to share some MongoDB management experience: 1. Export vue data After a normal connection, such as data,

Coalesce and coalesce There is such a demand. There are several contacts in the community. If there is a power outage, first notify contact 1. If not, then notify contact 2; otherwise, notify contact 3. Create table test (Id number,Name varchar2 (20

[HTTP: 101216] Servlet: "FICMaster" failed to preload on startup in Web application, 101216 ficmaster I recently obtained an Oracle OFSAA software, which encountered a problem during program deployment. Currently, knowledge sharing of ofsaa on the

Oracle like fuzzy query and oracle fuzzy query In some queries, you may not be sure about the exact value to be queried. For example, when Baidu searches, you can enter keywords to query the relevant results. Such queries are called fuzzy

Oracle performance optimization operation 18: determines whether to use full table scan or index. oracle Performance Optimization Like all tips, the last trick will go back to the starting point. Finally, let's discuss whether to create an index,

Duplicate from active dg run script sfile is a complete configuration that may cause some errors, duplicatesfile Oracle 11g RMAN: Interpretation of the command for creating dg in Active Database Duplication for standby database If the previous

How to remotely connect oracle11G and ploracle11g from a virtual machine through PL/SQL Environment requirements: 1. win8.1 Operating System 2. Download instantclient_10_2 must be 32-bit:

ERROR 1044 (42000): Access denied for user ''@ 'localhost' to database 'mysql'. Solution: 104442000 The newly installed mysql database encountered a problem when accessing the mysql database: ERROR 1044 (42000): Access denied for user ''@ 'localhost'

07. Stack (1) storage structure and operations of stacks, 07 storage structure operationsI. Stack1.Stack): It is a linear table that is only inserted and deleted at the end of the table. The end that allows insertion and deletion is called the top,

In Oracle, the field content format specified in the data table is converted from pinyin to numbers. oracle cursor Application Scenario: Convert [sannanyinv] to [3 male and 1 female] In the NNDP field of the data table TB_USER. Main Script: A cursor

Database Optimization-create and classify oracle table partitions, database-oracle When the amount of data in a table increases, the speed of data query slows down, and the performance of applications degrades. In this case, you should consider

MYSQL service cannot be started: InnoDB:. \ ibdata1 can't be opened in read-write mode, innodbibdata1 I did an experiment there today and dumped the mysql database. Later I found that the service could not be started. The following error was

T-SQL view, t-SQL View View [Younger brother build view previously is visual operation rarely write T-SQL statement, but in the work of release version is necessary, write some T-SQL statements, so we still write more points better] 1. What is a

Principles and usage of Oracle rownum and oraclerownumFor each row returned by the query, a number is returned using the rownum pseudo column, indicating the order in which oracle selects rows from the table or adds rows. The first row rownum is 1,