Database Administrator

Analysis on Oracle Parameter Modification SCOPE = SPFILEThe change is applied in the server parameter file only. The effect is as follows:For dynamic parameters, the change is valid at the next startup and is persistent.For static parameters, the

Editor's note: expansion of existing systems is a big or small challenge for each technical team. Especially for banking businesses, it is not easy to implement expansion by modifying the architecture or rewriting the system because we need to take

1. Export Export with PLSQL Export table structure: Tools --> Export User Objects (Export User object) --> select the table to be exported (including Sequence and so on) -->. SQL file, all exported are SQL files Export table data: Tools -->

Test code: DECLARE TYPE list_of_names_t is table of VARCHAR2 (100) index by PLS_INTEGER; Happyfamily list_of_names_t; Rochelle row PLS_INTEGER; BEGIN -- Build table data which indexIsNot consecutive. Happyfamily (2020202020): ='Lil'; Fig (-1

Suppose a subprogram declaresINParameter,OUTParameter, andIN OUTParameter. When you call the subprogram,INParameter is passed by reference. That is, a pointer toINActual parameter is passed to the corresponding formal parameter. So, both parameters

There are two main causes:1. There is a large volume of transactions that allow Oracle Undo to automatically expand, resulting in excessive disk space occupation;2. There are large transactions that have not been contracted or are not committed by

Fault description: Check the df-g space on AIX and check that the undo tablespace of the corresponding database has reached more than 90%. The following process the problem of too large data files in the tablespace. -- 1 check the tablespace size

Currently, most websites using MySQL use Memcache as the key-value cache at the same time. Although such an architecture is extremely popular and there are many successful cases, it relies too much on Memcache to virtually make Memcache the root

Both views and synonyms are the object names in the database. They do not correspond to actual data storage and all depend on the existence of other objects.View: A view can be viewed as a virtual table or storage query. Unless it is an index view,

When configuring the data guard network listener, the connection test reports the following error: ERROR:ORA-12514: TNS: listener does not currently know of service requested in connectDescriptor The error is caused by a new db_unique_name = 10 upli

Recently, the project has entered the cut over stage, which is under great pressure and never before. My task is to optimize long running SQL so that it can be completed within three hours. Yesterday, a Long running SQL statement appeared. It ran

1. Download necessary resource packages Download the installation package from the official Oracle website and select Version 10.1.0.5. Http://www.oracle.com/technetwork/topics/linuxsoft-082809.html Version 10.1.0.5 Instant Client Package-Basic: All

MysqlExecution Process: MysqlIt is a single-process service, and every request is responded by a thread. This requires a connector to handle new user requests, responses, and destruction. 1.Client request, server (connector) opens thread to respond

The materialized view stores the View query results to a real table based on the query definition. When you query data in the materialized view, Oracle does not search for a specific base table, this will greatly improve the efficiency. First, let's

Environment Oracle 9 Release 2 User sys Test Table Name ATTRIBUTE_TRANSFORMATIONS $ Tables and views in the used data dictionary USER_TAB_COLUMNS: basic organization information of the User table User_constraints: basic user constraint

The memory structure is one of the most important components of the Oracle service system and a key element that determines the overall performance of the Oracle server. During the running process of the Oracle server, the SGA size directly affects

In the Patchset of Oracle 10g version, only one file Disk1. the size of the Patchset in Oracle 11.2.0.2 and 11.2.0.3 is greatly increased. The Patchset of 11.2.0.2 and 11.2.0.3 is 5 GB. These 5 GB files are composed of seven files. It is a

-- Create a storage process for batch SMS dump and transfer sent SMS messages to the SMS History TableCreate or replace procedure PUB_SHORTMSG_ARCH_BAT As MSG_ID pub_shortmsg_td.shotmsg_id % type; Cursor cur_msg is Select shotmsg_id from

1. Exception HandlingA warning and error in pl/SQL is called an exception. Exceptions include compilation exceptions and running exceptions. 2. Exception ClassificationSystem exceptionCustom exception 3. Abnormal Structure ExceptionWhen... then.. 4.

When I started the Oracle service today, I found that listener was unavailable. Use lsnrctl LSNRCTL> start Start tnslsnr: Please wait... TNSLSNR for 32-bit Windows: Version 11.1.0.6.0-Production The system parameter file is d: \ app \ qiao \