Database Administrator

We have a core table t_ms_mdeia_task related to daily operations of an application. This table is a List partition made on a daily basis. The partition key is monthday, and the column value is similar to 'mmdd'. There are 366 partitions in

This is a problem where RMAN is used in the Oracle database for database operations. The backup performance is slow to unacceptable due to the improper configuration in the default configuration. The entire problem solving process involves storage

Permanent tablespace 1. Extended permanent tablespace SQL> alter tablespace users add datafile '/db/Oracle/oradata/yang/users01.dbf' size 100 m; add the data file method SQL> alter database datafile '/db/oracle/oradata/yang/users01.dbf' resize 200 m;

The ultimate goal of backup is to better recover data and restore data. We have finished focusing on the previous chapter.RMANIn fact, we also talked about complex and complete recovery. Of course, in this section, we will discuss in detail the

SQL Script annotation syntax in Oracle DB REM Single line comment -- Single line comment /* Single line comment */ /* Multi Line Comment */ Supplement: REM is short for REMARK. So what is the difference between REM and? -- Or/**/can

Logon to MySQL: Check whether/etc/init. d/MySQL start is enabled for mysql. Mysql-u root-p After the password is entered, the ERROR message is as follows: ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES),

How To Configure Server Side TransparentApplication Failover [ID 460982.1] 1. CreateTAFService [Oracle @ db1 bin] $./srvctl add service-d orcl-s server_taf-r "orcl1, orcl2"-P BASIC -- Here, orcl is the database name, And orcl1 and orcl2 are instance

1. instr In Oracle/PLSQL, The instr function returns the position of the string to be truncated in the source string. Syntax: instr (string1, string2 [, start_position [, nth_appearance]) String1 source string to be searched in this string.String2:

Oracle transaction A general transaction (DML) is a transaction for data modification (addition, deletion, and modification ).The transaction adds a lock (Row-Level Lock) to all the data rows modified in the transaction to prevent others (sessions)

Today, I encountered a problem where Oracle is not equal. I finally searched and found the following information to share with you about Oracle's non-equal sign: In Oracle, <>! =~ =^ = They all mean no. Can be used. But it's strange. When I want

Configure replication and add the following content to/etc/my. cnf: Log-bin =/var/lib/mysql/binlogs/mysql-binMax_binlog_size = 100 MExpire_logs_days = 5Sync_binlog = 1Binlog_cache_size = 1 MBinlog-format = ROW As a result, an error is reported

Oracle supports full-text retrieval from 7.3, that is, you can use the ConText option of the Oracle server to complete text-based queries. Specifically, you can use wildcard search, fuzzy match, related classification, approximate search,

Today, I encountered a problem in a project, which is described as follows: Batch operations must be performed on a batch of data that meets the conditions. If the conditions are met, batch updates are performed. If the conditions are not met, data

The following content is from the patchset document. Oracle Database Patch Set Notes 11 gRelease 2 (11.2.0.3) Patch Set 2 E24903-01Patch Set OverviewOracle Database patch set, release 11.2.0.3 is a full installation of the Oracle Database software.

In a travel_line table, the pub_price and trade_price fields are in the varchar type. You need to extract the content of the fields as pure numbers and write a function to process them: Create or replace function Isnumber

SQL Server 2000 creates a database with the same name, stops the database, deletes files, and Copies files. Start the database. In this case, the database has doubts. Open the query analyzer.Exec sp_configure 'Allow updates', 1 reconfigure with

Error Handling caused by the absence of relevant permissions on the data file on the slave uard.ORA-01111: name for data file 108 is unknown-rename to correct fileORA-01110: data file 108: '/Oracle/product/9.2.0.5/dbs/UNNAMED00108'ORA-01157: cannot

SQL> startupORA-32004: obsolete and/or deprecated parameter (s) spec. The Oracle routine has been started.Total System Global Area 314572800 bytesFixed Size 1248768 bytesVariable Size 171966976 bytesDatabase Buffers 134217728 bytesRedo Buffers 713932

In Oracle 10 Gb, the following table's OBJECT_ID_FACTORY record is repeated. This is a dictionary table used to generate record primary key values for some tables. Duplicate key values cause some business operations to fail. This problem has

Obsolete: it is related to the retention policy. When a backup or copy is discarded Based on the storage policy, it is marked as this state. For example, if you set the recovery window to 7 days, and today's 10, those before the 2 (including the 2)