Tag: oracle

reading

Inventory hot chip storage technology implementation

January 9, 2024

by Ivana Dave

No Comments

Inventory module is a update database intensive modules, all have inventory updates, although the online inventory using the Oracle database independently, already meet the business...

Read More

The back-end

Ali offline data synchronization tool DataX trampling record

January 9, 2024

by 錢佩珊

No Comments

Recently, I have been doing some work related to data migration, investigated some tools, and found DataX is a good thing, so AMway will give...

Read More

reading

New features in Java 11

January 9, 2024

by 梁信宏

No Comments

In terms of Java releases, the release cycle has officially changed to every six months -- a major release every six months and an intermediate...

Read More

reading

Oracle uses built-in functions

January 9, 2024

by Ashley Lopez

No Comments

1. nvl(expression1, expression2) 2. decode(field_name, value1, new_value1, value2, new_value2, Default_value) 3. Row_number (order by field_...

Read More

The back-end

The standby Oracle DataGuard database is configured in flash back mode

January 9, 2024

by 方淑慧

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". If the primary database deletes data by mistake,...

Read More

The back-end

Oracle creates N tablespace data files quickly

January 9, 2024

by Seth Harvey

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". An Oracle database consists of an infinite number...

Read More

The back-end

Oracle exports imported data

January 9, 2024

by Anay Agarwal

No Comments

Summary as follows: Oracle export export has two ways: first, use exp IMP export import; Two, use Oracel data pump EXPDP IMPDP export import.

Read More

The back-end

The Oracle database enables the archive mode

January 9, 2024

by Nicholas Blake

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". You are advised to enable the archiving mode...

Read More

The back-end

Oracle adjusted the password management policy PROFILES

January 8, 2024

by Badal Saran

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". Click "Like", "Favorites", "follow", and "comment" if you...

Read More

The back-end

Oracle Distributed transaction 2PC troubleshooting

January 8, 2024

by Billy Wright-Brown

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". 📚 Foreword When we use Oracle database, sometimes...

Read More

The back-end

Oracle database migration 1 click create source database tablespace SQL statement

January 8, 2024

by Rebecca Hunt

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". ⭐️ To obtain the users to be migrated,...

Read More

The back-end

Oracle kills session-related SQL statements

January 7, 2024

by Mehul Rama

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". Kill SpID corresponding to a waiting event: Syntax...

Read More

The back-end

Oracle RedoLog- Binary format analysis, file headers, DML, DDL

January 7, 2024

by Kayla Long

No Comments

In my previous article, I briefly introduced what RedoLog is and how to Dump binary logs from Oracle. Redo Log binary file formats: file headers,...

Read More

The back-end

Oracle Data Pump migrates users to create SQL statements

January 7, 2024

by Andrew Morris

No Comments

When migrating data pumps, you usually import and export by user, so you need to verify that non-system users exist in the current database! Query...

Read More

The back-end

Oracle pfile parameter file

January 7, 2024

by Christine Hughes

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". 📚 About This topic When the Oracle database...

Read More

The back-end

Oracle spfile Parameter file

January 7, 2024

by Aaryahi Babu

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". 📚 Preamble Oracle pfile parameter file, this article...

Read More

The back-end

Oracle redo log tuning SQL statement

January 7, 2024

by Ashley Diaz

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". After the Oracle database is installed, the default...

Read More

The back-end

Oracle queries SESSION and SQL information through siDs

January 7, 2024

by Bhavin Thaman

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". 📢 Note: To query conditions, enter SPID! This...

Read More

The back-end

Oracle looks at database and client character set SQL statements

January 7, 2024

by 遊信宏

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". Oracle database is divided into database character set...

Read More

The back-end

Oracle OMF parameters

January 7, 2024

by Parinaaz Tailor

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". 📚 Introduction To the Oracle DBA, it is...

Read More

The code of life

Oracle to_date error caused by different locales

January 7, 2024

by 唐惠雯

No Comments

To_date (dateFrom, 'YYYY /mm/dd'); insert data' 0001/9/14 '; I don't know why it's here

Read More

The back-end

Oracle SQL statement: Query the redo log switchover count per hour

January 7, 2024

by 錢冠霖

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". Sometimes, you can view the number of online...

Read More

The back-end

Oracle temporary tablespace SQL statement

January 7, 2024

by Valerie James

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". SQL > create temporary tablespace temp; create temporary...

Read More

The back-end

Oracle displays SQL statements in database files

January 7, 2024

by Jackson Thomas

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". Oracle database files are divided into: tablespace data...

Read More

The back-end

Oracle RedoLog- Basic concepts and components

January 7, 2024

by Justine Twidle

No Comments

The redo log records all changes made to an Oracle database. In the process of studying how to extract DML operations in Redolog, there are...

Read More

The back-end

SQL statement used by Oracle to query tablespace usage

January 7, 2024

by 王惠如

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". If the tablespace usage exceeds 100%, the Oracle...

Read More

The back-end

SQL statement to check rMAN backup status

January 7, 2024

by Stephanie Caldwell-Webster

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". RMAN backup is the most common backup method...

Read More

The back-end

Oracle Performance Tuning Tips – Get a true execution plan

January 7, 2024

by Sarah Barrett

No Comments

1. Background In SQL optimization, we often use the execution plan, such as navicat or PLSQL interpretation plan, in fact, the result is only an...

Read More

The back-end

Ora-12154: TNS: Cannot resolve the specified connection identifier

January 6, 2024

by Heer Konda

No Comments

SQL Plus is a management and development tool that automatically installs along with the installation of Oracle database server or client. All management operations in...

Read More

The back-end

Switch Oracle 11G memory management mode

January 5, 2024

by Hazel Thakur

No Comments

At 10G, Oracle introduced Automatic Shared Memory Management (ASMM), which implements self-tuning of Oracle SGA and PGA internal structures......

Read More