Oracle

Oracle An RDBMS is used in practice for various types of related locking mechanisms, andOracle latch is one of the most frequently used, and the following articles are mainly about the concept of latch (latch) and understanding the implementation of

A Set the appropriate SGA People often complain that server hardware is good, but Oracle is slow. It is likely that the memory allocation is unreasonable. (1) Assuming that the memory has 512M, this is usually a small application. Oracle's SGA is

Trigger-related concepts and syntax Overview This blog post focuses on the following topics: What is a triggerApplication Scenarios for triggersSyntax for triggersTypes of TriggersCase Data: The concept of triggers and the first trigger A

//***********************************************************************Function name: Of_zy_yzfy for N_medicare_minihisFunction Note: The doctor's advice should be submitted to the doctor after entryFunction arguments:1.s_yb_zy_yzfy Astr_jyxx

Demand Oracle invokes third party external programs. Oracle uses SQLULDR2 to quickly export large amounts of data and then send messages with WinRAR compression. Source Java source Create or replace and compile Java source named

1. Query this node and all nodes below this node: 2. All hierarchy relationships in the query node SELECT rpad (', 2* (LEVEL-1), '-') | | Depname "Depname", Connect_by_root depname "ROOT", Connect_by_isleaf "IsLeaf", Level, Sys_

1. EXTRACT (xmltype_instance,xpath_string) This function is used to return the corresponding content under the XML node path Example: Copy Code code as follows: SELECT Extract (Value (a), '/root/main ') data from xmltable A; 2.

When designing a database table, it was found that Oracle did not have a set of self-adding primary keys, and Google learned that Oracle itself does not support the Sequence key, which needs to be implemented through sequences (Trigger) and triggers.

1. Pop-up Error Box: Sample code: DECLARE v_count number; Begin Select COUNT (*) into the v_count from dept; If V_count Execution results: 2. Console display: Sample code: DECLARE v_count number; My_exp exception; Begin

The Oracle tutorial you are looking at is: Oracle performance optimization. Linux Journal published an article that optimizes the Oracle database and feels very useful. Briefly introduce its summary and everyone to share Linux in enterprise database

PHP, or "Php:hypertext preprocessor", is a versatile scripting language that is widely used for open source and can be embedded in HTML. Its syntax is close to C, Java, and Perl, and is easy to learn. The main goal of the language is to allow web

DB Storage Hierarchy (Drawing a sketch, will take a look ...) XD) Managing Table Spaces -system Storing data dictionary information, it is necessary to create a database when creating the first -sysaux 10g new, necessary, auxiliary sharing

Recently the project encountered a very tangled problem, due to the business relationship, DB data table can not be determined, in the use of the field may be increased, so when the insert caused me a lot of trouble. Let's take a look at how I

The most we deal with in Pl/sql programming is the stored procedure. The structure of the stored procedure is very simple, and we are here to learn some useful knowledge about how to write stored procedures in addition to the basic structure of the

There are generally two possible reasons for password expiration: One, due to the default in Oracle set "Password_life_time=180 days" in the defaults profile. Second, the default profile in Oracle is set to "failed_login_attempts=10", which causes

Blocking in a RAC environment is different from a single-instance case, because we need to take into account the sessions that are in different instances. That is to say, the v$session,v$lock corresponding to the previous query to the global scope

The Oracle tutorial you are looking at is: Oracle three upload file technology. There are several ways to upload files to a database or server file system in Oracle, and here are three of the following: Oracle HTTP server (OHS) Mod_plsql modules

Check the information on the internet for a few days, try to comprehensively clear the alarm log content and the way to build the external table to solve this problem. One: Back up and clear the alert log contents The daily alarm log is backed up

Due to some project requirements, it is necessary to import data from Oracle to MySQL regularly, noting that the timeliness of data is not high. Requirements high can use GoldengateFirst, you need to export the Vid,userid,goodid,time4 fields from

If we give each user permission directly, it would be a huge and cumbersome task, and it would be inconvenient for DBAs to manage it. By adopting a role that enables: Privilege Management is more convenient. Assign roles to multiple users,