Table Spaces, users, and schemas
What is a tablespace: Oracle users have their own default tablespace. Most of the memory stored in a tablespace is tables, so it is called...
Read More
Tag: oracle
DBA operation and Maintenance Gospel: 10 minutes, one command to install Oracle database
February 6, 2024
by 吳中山
No Comments
With the widespread application of Oracle database, everyone needs to install Oracle database more or less, such as application on-line, application test, recovery drill, version...
Read More
Best practice | OceanBase transaction engine of technology innovation
February 5, 2024
by Mark Banks
No Comments
First of all, let's talk about a topic we are all interested in: what is the biggest difference between OceanBase and existing classic databases such...
Read More
Oracle ultra full SQL, details crazy
February 5, 2024
by Joshua Collins
No Comments
SQL is used by everyone, but it is not SQL itself that is used to measure output. You need to use this tool to create...
Read More
Chinese Academy of Sciences unveils gait recognition technology Oracle open Autonomous database
February 5, 2024
by Leanne Cooksley
No Comments
Chinese Academy of Sciences "Gait recognition" technology: Ai team joins Siri development team DeepMind to open new AI lab in Montreal Only camera + browser...
Read More
MySQL • Source code analysis • SHUTDOWN process
February 2, 2024
by Stewart Pugh
No Comments
2: Row_drop_tables_for_mysql_in_BACKGROUND does not wait for dirty pages to be flushed. If innodb_buffer_pool_dump_at_shutdown is set, buffer dump is not required.
Read More
Detailed steps for installing Virtual Box on Linux
February 2, 2024
by Kevin Mendoza
No Comments
E1009 23:51:37.685891 358 start.go:174] Error starting host: Error creating host: Error executing step: R...
Read More
Oracle database application, the first understanding of PLSQL-1
February 2, 2024
by Biju Acharya
No Comments
"This is the 15th day of my participation in the First Challenge 2022. For details: First Challenge 2022." Table relation design one-to-many-to-many party references one's...
Read More
Linux: oracle11.2.0dbca silent library construction
February 1, 2024
by 孫哲瑋
No Comments
1, 2, close the firewall, switch user su - oracle3, edit, silent installation file vim $ORACLE_HOME/inventory/response/dbca rsp4, modify the configuration file after 5, install the...
Read More
Oracle11g database silent (text) installation and database creation in Linux5.7
February 1, 2024
by Paul Martin
No Comments
If swapoff -a is commented out and restarted, the swap takes effect.
Read More
Linux7 silently installs Oracle 19C client
February 1, 2024
by Nicola Frost
No Comments
Oracle 19C client can connect directly to 11G 12C 19C database, backward compatible, easy to install.
Read More
How TiKV accesses data (I)
January 31, 2024
by Donna Holmes
No Comments
This paper will introduce how TiKV processes read/write requests in detail. Through this document, students will know how TiKV stores data changes contained in a...
Read More
Oracle data to MaxCompute garbled characters
January 30, 2024
by 周琬婷
No Comments
Integrated Oracle data into MaxCompute, garbled code problem analysis; Why, while Oracle data is not garbled, integration into MaxCompute is garbled? What's the problem? 1.1...
Read More
Asynchronous community this week half price ebook
January 30, 2024
by John Taylor
No Comments
Oracle 12C basics, system performance and features, and how to support cloud computing; The system architecture of Oracle 12C mainly describes the concept of CDB...
Read More
Oracle Varchar2 stores the length of Chinese and the @VALID verification considerations
January 29, 2024
by Patricia Nolan
No Comments
The project verifies all the entities inputting data with @Validated of Spring. However, in the integration test, there are always problems of verification pass and...
Read More
Oracle Next generation Virtual machine GraalVM- Introduction
January 28, 2024
by 朱惠婷
No Comments
GraalVM is the next generation of Java virtual machines released by Oracle, with the first release released in 2019.05
Read More
Install Oracle 11g using Docker on macOS
January 28, 2024
by Zeeshan Halder
No Comments
Download it from docker Store. Download the address is: https://store.docker.com/editions/community/docker-ce-desktop-mac. You can also see other operating system versions, such as centos version, AWS version,Ubuntu version,...
Read More
ORACLE 11G/12C/18C/19C
January 27, 2024
by Abigail Ford-Little
No Comments
ORACLE one-click install standalone 11G/12C/18C/19C and build a library script (shell
Read More
1 “Database real case” -Oracle and mysql stored procedure or function debugging process (JAVA small virtual bamboo)
January 27, 2024
by Rachael Cole
No Comments
1 "Database real case" -Oracle and mysql stored procedures or functions debugging process (JAVA JAVA small virtual bamboo)
Read More
Oracle moves data files
January 27, 2024
by Beverly Lewis
No Comments
This is the 27th day of my participation in the November update Challenge. The activity details are as follows: 2021 Last Update Challenge 11G and...
Read More
Oracle Performance Optimization compares COUNT(*) to COUNT(column)
January 27, 2024
by Manjari Dhingra
No Comments
We get a TEST_TABLE for our own testing, derived from the DBA_OBJECTS table. Note that only sys users can use this table, please log in...
Read More
Wait/Notify mechanism for Java multithreading
January 27, 2024
by Ivana Saha
No Comments
Multiple thread applications, thread execution order is not sequential, random. If you want to execute threads in the specified order, why would you want to...
Read More
Teach you to use a SINGLE SQL to solve cross-database query problems
January 27, 2024
by Barry Harris
No Comments
Recently, an e-commerce user due to rapid business development, the rapid growth of traffic, resulting in database capacity and performance bottlenecks. To reduce database size...
Read More
MYSQL optimization
January 27, 2024
by Susan Jones
No Comments
Control the amount of data in a single table: control the number of records in a single table within 1000W3, control the number of columns:...
Read More
Java 11 is coming, compile & run a command and you’re done!
January 27, 2024
by Anthony Thompson
No Comments
Java 11 is coming. It was originally scheduled for Release in September, less than three months away, so stay tuned for more features to be...
Read More
Java multi-thread
January 27, 2024
by 倪志偉
No Comments
A thread has five states: New, ready, Running, blocked, and dead. Ready. When a thread calls a strat() method, it is ready, creating a method...
Read More
Configure the NTP server in Windows
January 26, 2024
by 張志偉
No Comments
"This is the 28th day of my participation in the November Text Challenge. See the details of the event: the last Text Challenge in 2021"...
Read More
Java 11 is here to tell you whether or not you should upgrade
January 26, 2024
by Renee Shannon
No Comments
Oracle today announced that Java 11 (18.9LTS) is now available in production. In this article, we'll take a look at what Java 11 is, what's...
Read More
Oracle WebLogic Thread Status
January 26, 2024
by Paul Haines-Burr
No Comments
Recently, threads of WebLogic applications have been STUCK for several times in a production system. As a result, threads of WebLogic are blocked, CPU usage...
Read More
Various pits and self-help schemes for migrating from Oracle to MySQL
January 26, 2024
by Nicola Brookes-Williams
No Comments
This article will share some database migration practices from the following aspects: preparation and consideration before migration, identifying target databases, table and data object migration...
Read More