Tag: oracle

The back-end

Log an online database deadlock debug experience

January 24, 2024

by Dr. Allan Harris

No Comments

Recently online occasionally will report a deadlock problem, last week finally solved, tidy up over the weekend. Although the problem is resolved, the deadlock graph...

Read More

The back-end

Oracle’s method for obtaining execution plans (Excalibur)

January 24, 2024

by Garrett Marks

No Comments

This is the 19th day that I have been involved in the November update Challenge, and the details of the event are as follows: the...

Read More

The back-end

Oracle moves data files

January 24, 2024

by Gillian Patterson

No Comments

This is the 18th day of my participation in the November update Challenge. The activity details are as follows: 2021 Last Update Challenge 11G and...

Read More

reading

Oracle Wants to offload Java EE, who will Take over?

January 24, 2024

by James Gonzalez

No Comments

Oracle announced on its blog that following the promising progress of Java EE 8, Oracle is now considering ways to make Java EE more open...

Read More

The back-end

Oracle open-source three container tools

January 23, 2024

by Joshua Collins

No Comments

[Editor's note] As container technology became popular, Oracle began to apply container technology in cloud services. While preparing applications, Oracle also developed related tools to...

Read More

reading

Oracle database partition table cleanup summary

January 23, 2024

by Dhanush Kota

No Comments

How to select the type of partition, how to select the column of the partition. Before you do that, you need to be clear about...

Read More

reading

SQL detail, multi-table query, grouped query, pagination

January 23, 2024

by Billy Wright-Brown

No Comments

Mysql database, Oracle database, Mysql database, Oracle database I only remember basic SQL statements and related concepts.... Write this blog post

Read More

reading

Oracle initialization parameters & Performance view

January 23, 2024

by Scott Hernandez

No Comments

Oracle Initialization Parameters & Performance View 1. Database version LEO1@LEO1>select * from v$version; BANNER -- -- -- -- -- -- -- -- -- -- --...

Read More

reading

Application of SQL statement in Oracle Database

January 23, 2024

by Tanya Krishnamurthy

No Comments

Because of the requirements of the company, so spent about a week to understand and memory SQL language, based on practical rather than a thorough...

Read More

reading

On SQL Optimization

January 23, 2024

by 黃淑華

No Comments

When you write a SQL statement, the order in which you write it, or the strategy you use to write it, will affect the performance...

Read More

The back-end

Transaction management for the Spring Framework family

January 23, 2024

by Aarav Chaudhuri

No Comments

A transaction is a logical set of operations in which the units of logic that make up the operation either succeed or fail together. Spring...

Read More

reading

Oracle views, indexes, transactions, user permissions, and batch operations

January 23, 2024

by 呂怡安

No Comments

In the first article of Oracle Summary, we have summarized some common SQL related topics. So this article mainly summarizes some content about Oracle CE...

Read More

The back-end

Java connects to the Oracle database

January 23, 2024

by Garrett Marks

No Comments

1.Eclipse creates a New Java project: OracleConnection 2. Add the driver file to the project resource. The driver file is found in: [Oracle installation path]\product\11.2.0\...

Read More

reading

Attacking JavaWeb applications [4]-SQL injection [2]

January 23, 2024

by Mary Roberts

No Comments

Note: This section is mainly about Oracle and SQL injection tools. It should have been used with Mysql but it is too long to read,...

Read More

The code of life

Java programs Atomic packages concurrently

January 23, 2024

by 嶽靜宜

No Comments

Java since JDK1.5 provides Java. Util. Concurrent. Atomic package, convenient programmers in a multithreaded environment, unlocked for atomic operations. The underlying atomic variable uses the...

Read More

The back-end

Oracle Control file loss recovery (Archive mode)

January 23, 2024

by Cody Todd

No Comments

There are two control files in the database, respectively located in the data file path and the fast flashback area path. 2. Simulate the loss...

Read More

The back-end

Have the Database Audit service secure your database

January 23, 2024

by Kelly Watts-Jackson

No Comments

According to Verizon's 2012 data leak investigation and analysis report and technical analysis of information security incidents, two trends of information leakage are summarized: (1)...

Read More

The back-end

ORACLE partition table transform (DBMS_REDEFINITION)

January 23, 2024

by Sheila Davis

No Comments

This is the 15th day of my participation in the Novemberredefinition Challenge. For details, see: the last Redefinition challenge in 2021

Read More

The back-end

Oracle obtains the current system time /trunc/round/ceil/floor

January 23, 2024

by Kayla Long

No Comments

This function does not round off the portion before or after the specified decimal. Decimals indicates the number of digits after the decimal point to...

Read More

The back-end

COPY_TABLE_DEPENDENTS for Oracle online redefine

January 23, 2024

by Kabir Ahuja

No Comments

When using the online redefinition function to perform a non-partitioned table conversion, the process needs to index the intermediate table, constraint and other dependencies to...

Read More

The code of life

Oracle logs in Linux are deleted

January 23, 2024

by 張思穎

No Comments

When the server is running for a long time, it is inevitable that a large number of log files and garbage files are accumulated. In...

Read More

The back-end

【 Seven days to clock 】

January 23, 2024

by Tiffany Blake

No Comments

A view, also known as a virtual table, does not occupy physical space. This is also a relative concept, because the definition of the view...

Read More

The back-end

From SQL Server to MySQL (3) : Open Source power

January 23, 2024

by Anna Saunders-Baker

No Comments

Introduce our problems and solutions. The core ETL tool is YuGONG. It and Otter/Canal are both products of ali middleware team. Otter, on top of...

Read More

The back-end

Oracle APEX series article 9: Why use Oracle APEX

January 23, 2024

by 崔淑華

No Comments

This article is a translation of Oracle APEX. If you don't already know what Oracle APEX is, please read another article of mine: Oracle APEX:...

Read More

reading

JEESZ module development

January 23, 2024

by Frances Jones

No Comments

Do not omit these fields when creating a table.

Read More

The back-end

Large data warehouse practices based on Greenplum,postgreSQL

January 23, 2024

by Vanessa Stewart

No Comments

On October 21, 2017, Gao Yang, co-founder of Shenqi Wisdom, delivered a speech titled "Large data Warehouse Practice based on Greenplum, PostgreSQL" at the "PostgreSQL...

Read More

reading

PreparedStatment [PreparedStatment, batch processing, binary processing, automatic primary key, call stored procedures, functions]

January 23, 2024

by Molly Sellers

No Comments

Tags: JDBC1. PreparedStatement object PreparedStatement object inheritance Statement object, it is more powerful than the Statement object, use rise more simple Statement object compilation

Read More

The back-end

Ali common tools and command collection!

January 23, 2024

by 袁惠如

No Comments

study hard and make progress every day

Read More

The back-end

Struts2 and Oracle database interaction small Demo

January 23, 2024

by Thomas Smith

No Comments

Write in front: this article with the following two articles to read, help to understand. The DbUtil file that links the database and the Struts2...

Read More

The back-end

Jingdong architect said: distributed database system evolution road

January 23, 2024

by Aniruddh Sule

No Comments

Regarding the use of database, there are several trends in JD. In the early stage, JD mainly used SqlServer and Oracle, and MySQL was also...

Read More