Oracle

After reading the second chapter, I have a general understanding of Oracle's architecture principles. What I like most is to compare other things in my life. It is easier to understand why Oracle works and why I did it. Select a role or position to

Address: http://tech.e800.com.cn/articles/2009/710/1247207067745_1.html   Solution 1: Check which table is locked Select sess. Sid, sess. Serial #,Lo. oracle_username, Lo. OS _user_name, ao. object_name, Lo. locked_mode FromV $ locked_object Lo,

Before that, I made an oracle call to WebService. Since I had to leave, the company had no one to take over, so I didn't do the solution to call WebService using Oracle. I switched to Java instead, there is no way to call WebService with Oracle, but

1. automatic Installation selected during installation. Because the user name and password have been forgotten for a long time, I have tried several default user names and passwords (The table contains the default user name and password ), the user

Oracle creates a table that automatically adds a primary key // creates a table Create Table T (Pk Number Primary Key, name varchar2 (20 )); // Create a sequenceCreate sequence t_seqIncrement by 1Start with 1 maxvalue 999999999; // Create a

Transferred from:Http://bbs.bccn.net/thread-310552-1-1.html The main problem is that the character encoding of the Oracle client is inconsistent with that of the server. Oracle Server character encoding: zhs16gbkOracle client character encoding:

  Oracle data block principle in-depth analysis of data blocks (Oracle data blocks), referred to as blocks in this article, is the smallest storage unit of Oracle, Oracle data is stored in the block. A block occupies a certain amount of disk space.

An Oracle 11.2.0 instance was installed and an instance named orcl was created. However, it was found that the database could not be connected, saying that Sid given in connect descriptor cocould not be resolved. Disable the firewall and do not

Database development or management personnel often need to create a large amount of test data, and tens of thousands of data records are required. If one data entry is required, it will waste a lot of time, this article describes how to quickly

ORACLE: primary key, foreign key, Uniqueness constraint, and index of the query (View) Table 1To search for all indexes of a table (including index names, types, and columns ):Select T. *, I. index_type from user_ind_columns T, user_indexes I

Abstract: This article gives a comprehensive introduction to the structure and internal management of B-tree indexes. At the same time, I have discussed some widely-spread statements related to B-tree indexes, such as the impact of deleting records

Question: One by one analysis: A: Correct. user_synonyms describes the private Synonyms (synonyms owned by the current user). Its columns (could t for owner) are the same as those in all_synonyms. You can determine through his description. In a

There are many date functions in Oracle, such:1. add_months () is used to increase or decrease the number of months from a date value.Date_value: = add_months (date_value, number_of_months)Example:SQL> select add_months (sysdate, 12) "next year"

Segment: SegmentAfter a segment is created, Oracle assigns it a zone, which is usually eight blocks (empty blocks ). Em creating a tablespace: the items to consider when creating a tablespace are: 1: Number of data files; 2: Automatic Management of

1. =========create text index authorization for mode with document tables === Connect to the database as a system user and authorize zyfileup. Grant "ctxapp" to "jdcdc ";Alter user "jdcdc" default role all;Grant execute on "ctxsys". "ctx_adm" to

Oracle accounts are frequently locked I logged on to the department knowledge base this morning and found that the knowledge base application could not log on again. I was wondering why I had reset all my expired passwords yesterday. Why have I been

For example, if the column name is no and the type is varchar2, W1 ~ is stored in the 100 rows of data ~ W100. If the query statement is: Select * from Table order by no Press W1, W10, w100, W11, W12 ,......, W2, W20, w21 ,...... . What if we want

-------------------- Custom array typeCreate or replace type varchar2varray is varray (100) of varchar2 (40 );/ ------------------ Split by specific symbols and store them in an array Create or replace function sf_split_string (string varchar2,

Oracle mail storage process: Create or replace procedure bsd_sendemail (P_receiver varchar2,P_sub varchar2,P_txt varchar2)IsP_user varchar2 (30): = '';P_pass varchar2 (30): = '';P_sendor varchar2 (20): = 'gni ';P_server varchar2 (20): = 'mail _

Automatic workload repository (AWR) collects, processes, and maintains performance system information, providing powerful help for performance tuning problem detection. Statistics collected and processed by AWR include: 1. segment statistics; 2.