How to view the Oracle database lock and unlock

-- View database lock details select. sid, B. serial #, B. username, B. osuser, B. machine, B. program, C. object_name, D. spid, decode (. type, 'Mr ', 'Media recovery', 'rt ', 'redo thread', 'UN', 'user name', 'tx ', 'Transaction ', 'Tm ', 'dml',

Enable a user connection created before password management Oracle reported ORA-28002 processing 1

The solution is actually very simple, as long:Alter user identified by ; after this operation, it returns to normal. The following is a simple test: SQL> conn HR/hrerror: ORA-28002: the password will expire within 2 daysconnected. SQL>

Oracle tiger trigger instance

Oracle tiger trigger instance-- Instance 1 ------------------------ -- Create a trigger. When you execute DML statements on the test table, the related information is recorded in the log table. -- Create a test table Create Table Test ( T_id number (

Oracle cursor usage

 Oracle uses a cursor to perform joint queries on multiple tables Declare -- defines the cursor mycur is select T. dept_id, M. station_id, M. name from person_inform T left join contacts m on T. dept_id = m. id order by T. dept_id; -- temporary

Oracle case when

1. Standard (the end of a case is an end case, but the end can also be used. 2 is, but the end cannot be used directly in 1, and an error will be reported) if tmpmoshiid is not null then CASE WHEN (main2.allcount 2. End directly at the end.

Oracle Big Table

-- 1: Create Table partition tablespace tab_cc as select * From cc_event_reserve where rownum 3, cascade => true, no_invalidate => false ); -- 6: Enable the logging function of the new table and delete the foreign key constraint alter table

Considerations for Oracle Silent Installation

The environment configuration for Silent Installation is the same as that for graphical installation. Key points: ① Each response file is in the downloaded software package "/database/response /" Major: Oracle software installation, Please modify

In-depth understanding of Oracle partitions (1): How to implement and evaluate partitions

AlthoughHowever, this blog post aims to guide everyone in how to create partitions in the production environment. But never be bound by some so-called Design Guides, especially some absolute suggestions. Exercise caution in the production

In-depth understanding of Oracle indexes (7): Observe the CPU and I/O consumed by B-tree indexes, composite indexes, and bitmap indexes

Environment: sys@ORCL> !sqlplus -vSQL*Plus: Release 10.2.0.1.0 - Productionsys@ORCL> !uname -aLinux Think 2.6.18-308.el5xen #1 SMP Fri Jan 27 17:59:00 EST 2012 i686 i686 i386 GNU/Linux hr@ORCL> conn sh/shConnected.sh@ORCL> select index_name from

In-depth understanding of Oracle table (7): analysis of data storage and application scenarios of 10 Table types

In this blog post, think focuses on two issues: ① Under which circumstances is a certain type of table more suitable than other table types? ② How are the data of different types of tables organized and stored? Let's talk a little about it. Let's

In-depth understanding of Oracle indexes (17): Selection of indexes with the same cost value as CBO

The rules are as follows: The test is as follows: HR @ orcl> drop table t purge; Table dropped. HR @ orcl> Create Table T as select * From dba_objects; Table created. HR @ orcl> alter table t add (object_id_1 number); table altered. HR @ orcl>

Application of temporary tables in Oracle temporary tables

Some people on the Internet have provided the best optimization ideas:1. Extract the records that meet the conditions in the large table to generate a temporary table.2. Associate the small temporary table with another small table.No matter whether

Experience in Oracle Database 11G & MySQL 5.6 development manual

The wave of big data is surging, and a new information technology revolution is about to begin. "Spring River plumbing duck Xianzhi", as a database practitioner, is particularly profound to me. However, whether it is Oracle's exadata, MySQL's scale

Principle Exploration from the balance tree to the Oracle B-Tree Index

Let's look at it first. There are two types of Oracle indexes that are widely used: 1) B-tree: OLTP (transaction-oriented)2) bitmap: OLAP (for analysis) Step into the question, first build a test environment: SQL> Create Table TT as select * From

In-depth understanding of Oracle index (14): Analysis of the two principles of Composite Index

Statement: although the title is Oracle, it is also suitable for MySQL InnoDB indexing. In most cases, compound indexes are better than single-field indexes. Many systems rely on the creation of some suitable composite indexes to greatly improve

Oracle developers analyze SQL Execution Plan concerns

Complicated and complex execution plans, developer eyes may be lost, resulting in a sexy and silly SQL statement running on the server. There are a few important parts here, as for others, of course, not to be polite ,, (I) Number of returned rows

Process Structure of Oracle architecture Trilogy

Oracle-related processes can be divided into user processes and Oracle processes. Oracle processes can be divided into server processes and background processes. Server processes can be divided into dedicated server processes and Shared Server

Adjustment of IPC resources, kernel. shmmax, and Oracle shared memory

(I) view and release IPC Resources [Root @ David ~] # IPCS-M ------ shared memory segments -------- key shmid owner perms bytes nattch status ...... 0xbe3bb918 5439503 Oracle 640 419438592 22 [root @ David ~] # IPCS-m-I 5439503 shared memory

Explain plan for struct and array in Oracle

In previous articles, I introduced how to use struct to input multiple pieces of data to Oracle at a time in a Java program. As we all know, at the end of the SQL statement, we need to make an explain Plan to ensure that there are no statements that

How to use struct in a Java program to input multiple data records to Oracle at a time.

To reduce the number of connections to the Oracle database, multiple data entries need to be input into the Oracle storage process as variables at a time. The method is as follows: Step 1: define the object type.Create type department_type as object

Total Pages: 2147 1 .... 2100 2101 2102 2103 2104 .... 2147 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.