Oracle

Today, I will talk about my understanding of these two operation modes and give some feasible suggestions to improve the security of Oracle databases.I. Advantages and Disadvantages of non-archive mode. The non-archive mode is a log operation mode

When you use start with connect by nocycle priorWhen performing recursive data search, the performance of the following two sections of code must be significantly different. For more information, please note that the code can be directly summarized

Modifying a project involves modifying many tables in Oracle (including adding, deleting fields, and modifying comments ). As no records are recorded at the beginning, the tables that have been modified are missing during the test. Later, I found

The following describes the hard-working processes in the background. System Monitor (SMON), Process Monitor (PMON), Database Writer (DBWn), Log Writer (LGWR) checkpoint Process (CKPT)1. SMON: Install and open the database. Install the database by

This article will introduce some interesting functions that trisi often uses in daily life, or which are rarely used. There are two types of introduction:Famous functions-frequently used functionsNon-famous functions-although rarely used, they are

The permission system of the oracle database includes system permission and object permission. Database system privilege allows users to execute specific command sets. For example, the create table permission allows users to create tables, and the

1. Check which users are in the database? Select username from all_users;2. Check which DBA users are in the database? Select username from dba_users;3. view the tables owned by the current user? Select table_name from user_tables;4. How do I create

Recently, many people in the group have discussed oracle Security Issues. Today I have found some materials to learn more.Obtain the attributes of the current Oracle SESSION (useful for determining the SQL Injection environment)The SYS_CONTEXT

In general, there are not many chances to use fetch in batches, but we 'd better get familiar with this feature provided by Oracle, and maybe it will be used at any time.Copy codeThe Code is as follows:DeclareCursor c1 is select * from

The following shows an implementation method of ORACLE. Two steps are required:1. create sequence create [or replace] SEQUENCE sequence_identity start with initial seed increment by step MAXVALUE upper bound [NOMAXVALUE] NOCYCLE [empty]2. create

The ORACLE tutorial is a brief analysis of Oracle Data dictionary technology. A data dictionary is a place where Oracle stores database information. It is used to describe data. For example, the Creator information, creation time information,

The ORACLE tutorial is: Oracle capture problem SQL to solve the excessive CPU consumption. This article attempts to provide a diagnosis method for common CPU consumption problems through a case adjusted in the actual business system. in most cases,

Write a circular deletion process.Create or replace procedure delBigTab (p_TableName in varchar2, p_Condition in varchar2, p_Count in varchar2)AsPragma autonomous_transaction;N_delete number: = 0;BeginWhile 1 = 1 loopEXECUTE IMMEDIATE'Delete from' |

The ORACLE tutorial is about space management of Oracle databases. In Oracle databases, DBAs can observe tables or views to understand the usage of the current space and make possible adjustments.I. Free Space for tablespaceBy observing the free

The ORACLE Tutorial we are reading is: Experience in Oracle Database System 6. 1. having clause usageThe having clause controls the row groups determined by the group by clause. The having clause conditions allow only constants, clustering functions,

The ORACLE tutorial is: Oracle constraints management script. As an Oracle database administrator, you may encounter such a database management requirement to stop or open the constraints and triggers for all tables under the current user (mode.

The ORACLE tutorial is: how to set up PB7 to connect to Oracle. System Environment: 1. Operating System: Windows 2000 2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3. installation path: C: \ ORACLE Access

The ORACLE tutorial is: Fully uninstall Oracle9i in the Win2k environment. 1. Delete the primary entry of Marshal in the registry:Regedit.exe-> LocalMachine-> Software-> Oracle2. Delete the Marshal Service:Regedit.exe-> LocalMachine-> System->

The ORACLE tutorial is: quickly delete duplicate records in oracle. When I was doing a project, a colleague accidentally duplicate all the data in a table while importing data. That is to say, all the records in this table have a record. This table

The ORACLE tutorial is: Excellent Oracle performance. Increasing the SGA buffer seems to have not significantly improved the performance, and the loading time has only increased by 1.73%. Next we will increase the size of the SGA redo log:DB3: Log