Database Administrator

Oracle 11g change log group size Oracle 11g change log group size 1. Create a New log Group 1. alter database add logfile group 4 ('/u01/app/oracle/oradata/jian/redo04.log') size 1024 k; 2. alter database add logfile group 5

Delay Section Function of Oracle 11gR2 In versions earlier than 11gR2, when creating a table, the segment space is automatically allocated, which has several drawbacks: 1. space needs to be allocated during initial table creation, which naturally

MySQL uses User-Defined variable simulation analysis functions MySQL uses a user-defined variable simulation analysis function to initialize the experiment structure and data: Create table test ( Tid varchar (32) primary key, Stat int not

ORA-01536: exceeds the space limit for tablespace XXXX /******************** ORA-01536: exceed the space quota of the tablespace XXXX *******************/ /******************** ORA-01950: the table space FMISINDEX has no permissions *****************

Mysql Stored Procedure error debugging records, mysql Stored ProcedureZookeeper mysql Stored Procedure error debugging records The company's Platform runs on the mysql database. Some stored procedures report errors, the debugging process is painful,

Delete the same data (only one record is left) across the oracle network and one record from oracle Delete from reg_user t1 WHERE user_name = '2013' and rowid> (SELECT min (rowid) FROM location t2 WHERE t1.user _ name = t2.user _ name ); How to

Summary of oracle psu upgrade, oraclepsu SummaryFirst, go to psu. first, let's take a look at readme.html. From this, we can know the detailed upgrade steps that have been rolled back. And avoids many pitfalls.Before executing the PSU, you must

Soft initial experience and initial experience Software Engineering is the design concept, the mainIt is necessary to use modern scientific and technical knowledge to develop documents and materials related to engineering. Starting from the

Configuration of the SQL Server database connected to the LAN, sqlserver First, make sure that the two machines are located in the same LAN, and then enable the configuration tool → SQL Server Configuration Manager to configure the TCP/IP IP (IP1,

ORA-06575: the package or function NO_VM_DROP_PROC is invalid, wndproc FunctionSQL> drop user aaa; Drop user aaa ORA-00604: recursive SQL Level 1 errorORA-06575: the package or function NO_VM_DROP_PROC is invalidORA-06512: In line 21 SQL> alter

Why not record slow queries ?, Slow recording(I) Background:At on May 18, I received a message from the front-end about player disconnection. I checked the CPU, slow query, and DB Request volume. No exception was found. The DB performance was as

Chapter 1 Securing Your Server and Network (14): restricted functions-xp_mongoshell and OPENROWSET, openrowsetSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I

Only two fields use one SQL statement to query the name, score, and ranking of a student in the table. I encountered this problem when I went to the interview yesterday: There is a two-dimensional table with only two fields, name and score. How can

Oracle transaction processing and instance demonstration jdbc operation batch Delete, oraclejdbc Transactions As the basic unit of logical processing, database operations are composed of one or more SQL statements. Of course, there are also

Mysql optimization and mysql OptimizationMysql Optimization I 've been writing a blog on csdn for a long time. Recently, I 've been learning mysql optimization at Yan 18, and this teacher is still talking about it, today, I just have time to

The idea sky of Oracle GoldenGate-understanding the essence of OGG, goldengateogg This article is an original article. For more information, see the source. Oracle GoldenGate's thought sky-understanding the essence of OGG The title of this article

SQL split string, SQL split Create function [dbo]. [fn_Split](@ SourceSql nvarchar (max), -- source separator string@ StrSeprate varchar (10) -- delimiter)Returns @ temp table (a nvarchar (max ))AsBeginDeclare @ I intSet @ SourceSql = rtrim (ltrim (@

An error is reported when an expression is inserted into mysql. mysql inserts table information. Today, I made a function to get fans and found that an error is returned when I insert a nickname into the database. The length must be

In oracle, the month or part of data is obtained from the specified date. The oracle date Obtain part of the data from the specified date: Such as month: Select to_CHAR (sysdate, 'mm') from dual; Or: Select extract (month from sysdate) from

ORACLE column value combination, oracle Column The most common method for merging column values is to validate a custom function. This describes other methods. In SQL Server, you can use the For Xml Path For the value of the merge column, and