Oracle

Data Guard provides two services:1) Redo transmission service: Transfers Redo logs of Primay to one or more Standby destinations.2) Redo Application Service: The Redo log transmitted from Primay on the Standby side.This article describes the Redo

When the index fragmentation is too large, the query execution speed will be affected, thus affecting our work efficiency. At this time, the most favorable measure is to re-build the index. This article mainly introduces the process of checking

Solution: 1. view which profile policy is used by the user SQL> select username, profile from dba_users; USERNAME PROFILE ----------------------------------- MGMT_VIEW DEFAULT SYS DEFAULT SYSTEM DEFAULT EKPUSER DEFAULT 2. view the valid days of the

An Oracle database creation error cannot be rectified by allocating ports to the following processes within the specified range. Install the Oracle database a few days ago. Configure the Linux environment, install rpm, install the 10.2.0.1

How to monitor the current situation of oracle database tables and tablespaces Declare Unf number; Unfb number; Fs1 number; Fs1b number; Fs2 number; Fs2b number; Fs3 number; Fs3b number; Fs4 number; Fs4b number; Full number; Fullb number; Begin Dbms_

Create test tables, which are frequently used by DBAs. Generally, they are created based on dba_objects. This article is based on the big_table of Master Tom for your reference.1. big_table based on Oracle 10 GB --====================================

When you log on to the scott user using PL/SQL Developer, enter the user name and password and report a solution error for ORA-28000: the account is locked. Solution Method 1 1. log in with an administrator ID 2. view the Users node in the tree

Status of all instances and services [Oracle @ vzwc1 ~] $ Srvctl status database-d zwc Instance zwc1 is running on node vzwc1 Instance zwc2 is running on node vzwc2 Status of a single instance [Oracle @ vzwc1 ~] $ Srvctl status instance-d zwc-I zwc1

Code used The Code is as follows:-- Sample dataDrop table t_collect purge;Create table t_collectSelect mod (rownum, 30) as flag, lpad (dbms_random.string ('l', 3), 4, '') as valFrom dual connect by rownum Collect function (Oracle10g)-- 1: use

To view the physical file path of an oracle database, you must run the command to view the physical file path of the oracle database. Unless the database is installed by yourself and all security configurations have been performed, otherwise, it is

Resets the oracle sequence from a specified number. The Code is as follows:DeclareN number (10 );V_startnum number (10): = 10000001; -- start from the numberV_step number (10): = 1; -- stepTsql varchar2 (200 );V_seqname varchar2 (200): = 'mip _

Concept: Database: a warehouse that organizes, stores, and operates data in batches. Data Warehouse is a basic term in the database field. Here it refers to its conventional meaning. Database Management System (DBMS): A software module used to

Many of my friends only use Oracle to delete the system. However, in many cases, he may find that the next installation page disappears when the system is re-installed, and he may have to reinstall the system, in fact, this is not the case if your

Create a trigger in the Oracle DBA Studio tool. CREATE TRIGGERNameCreate trigger-CREATE a new TRIGGERSyntaxCreate trigger name {BEFORE | AFTER} {event [OR...]}ON table for each {ROW | STATEMENT}Execute procedure func (arguments)InputNameTrigger name.

Steps for effectively disabling the Oracle deadlock process: 1. Check which process is locked Check the V $ DB_OBJECT_CACHE View: SELECT * from v $ DB_OBJECT_CACHE where owner = 'user of the process' and clocks! = '0 '; 2. Check which SID is

The Automatic Import and Export of Oracle databases are widely used in many places. for example, after an Oracle database application system is developed, if you want to install the system on the customer's computer, you need to import the initial

Upgrading hardware is usually easy, But upgrading the database ...... There is no doubt that everyone has a painful experience. An experienced Oracle DBA mainly focuses on the successful completion of the upgrade and the possible downtime. Success

Database security has always been one of the focuses of attention. We know that if a database of an enterprise or institution is attacked by hackers, these databases store very important data, databases such as banks and communications have

Problem 1: to load the JDBC driver: Normally, there are three ways to load the driver: 1) Class. forName (String) is used to initialize the static content of the driver when loading a class specified by a String in classLoader. In fact, the driver

Oracle-related Distributed Data SolutionsThis solution may gradually die out in the cloud computing and SOA architecture, but it is still quite practical. This article briefly introduces common data synchronization solutions because Advanced