Database Administrator

A profile has dual function: toenforce a password policy and to restrict the resources a session can consume; Password Management is always effective It is valid only when the initialization parameter RESOURCE_LIMIT is TRUE for resource management.

Oracle provides three technologies for SYSDBA Auditing: 1. Database Audit user privileges, commands executed and tables accessed, and logon status 2. Use a database trigger to initiate a value-based audit; 3. fine-grained auditing can track which

Generally, imp exp is used to back up and import data to the database. However, in some cases, it is necessary to flexibly retrieve data from two databases. Here I use the dblink method of or1c. First, the listener tnsnames. ora file can be

Help a customer shut down the database. When the instance is closed, alert displaysReference Fri May 14 01:08:49 2010System State dumped to trace file/u01/app/Oracle/oracle/product/10.2.0/db_2/admin/HIS3/udump/his3_ora_634882.trcFri May 14 01:08:49 2

1. Get 00:00:00 of the current day Select TRUNC (SYSDATE) FROM dual; 2. Get 23: 59: 59 seconds on the current day (add one day and then minus one second on the basis of 00:00:00 on the current day) Select trunc (SYSDATE) + 1-1/86400 FROM dual; 3.

I. Description There are three types of SCN in a data block of Oracle, namely the block header SCN, CSC (cleanout SCN) and commit SCN in ITL. You can dump the block to view the specific information in the block. This is organized in my previous blog:

The summary in this document is very comprehensive, but I have made some corrections to some of the errors (such as fal_server and fal_client instructions) or some ambiguous descriptions. to differentiate the network connection string and SID, list

SQL> select name, value $ from props $ where name like '% NLS % '; Name value $------------------------------------------------------------NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS

Expdp and impdp can be used in Oracle 10 Gb.When impdp is used to copy remote data through db_link,If the version of the source database (such as Oracle10.2.0.1.0) is higher than that of the target database (such as Oracle10.1.0.2.0. The following

To eliminate the connection problem between the client and the server, first check whether the client configuration is correct (the client configuration must be consistent with the database server listening configuration), and then solve the problem

Function Introduction The DECODE function is one of the powerful functions of Oracle PL/SQL. Currently, only oracle SQL provides this function, and other database vendors do not yet implement this function. What is the purpose of DECODE? First,

   Declare CursorMy_curIs SelectEmpno, deptnoFromEmp; Employee_id emp. empno % type; Dept_id emp. deptno % type; Begin OpenMy_cur; FetchMy_curIntoEmployee_id, dept_id; While my_cur % found loop

When Oracle 9.04 is installed on Ubuntu Server 10.2, the all_no_orcl error occurs.Open the log file as prompted and find the following error:Information: Creating/opt/oracle/lib/liborasdkbase. so.10.2 Information: gcc:Information:/usr/lib/libstdc ++

1. Concepts of Data Dictionary * Data dictionary is an important logical structure in Oracle databases. It is composed of read-only basic tables and views. All information about the Oracle server is stored in these basic tables. The information

I. handling process 1. Find the locked database table and related sid, serial # And spid: Select object_name as object name, s. sid, s. serial #, p. spid as system process numberFrom v $ locked_object l, dba_objects o, v $ session s, v $ process

-- 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

Today, we demonstrated the switching process between switchover and failover on the virtual machine. The customer is concerned with failover. We directly turn off the virtual storage switch to simulate array faults. Failover steps are as follows: 1.

An error occurred while importing the exp logical backup file to the standby database. The error message is as follows: IMP-00017: The following statement failed due to Oracle error 6550: "Declare srec DBMS_STATS.STATREC; begin srec. MINVAL: = '00

Oracle9i introduces pga_aggregate_target to automatically adjust the PGA;Oracle10 introduces sga_target to automatically adjust SGA.Oracle11g combines these two parts and introduces memory_target to automatically adjust all the memory. This is the

Sun Microsystems sun4u Sun Fire E6900 Oracle 11.1.0.7.0 ASM Database The system time is modified, causing the Oracle 11g database instance to go down. Both the ASM and ORACLE instances are unmounted. Tue Jul 14 20:11:00 1970Errors in