On Oracle

Monday, April 27, 2026

One Oracle TDE Performance Test

›
In this Blog, we will test the performance difference of SQLs on TDE table and non TDE table. Note: Tested in Oracle 19.27 on AIX and Lin...
Sunday, January 25, 2026

Oracle ORA-01426: numeric overflow and PL/SQL Runtime MCODE

›
Oracle PLS_INTEGER data type stores signed integers in the range -2,147,483,648 through 2,147,483,647, represented in 32 bits. ORA-01426:...
Sunday, January 11, 2026

Oracle SQL MEMBER vs. IN Comparison Condition Performance - Part1

›
(I)-Oracle SQL MEMBER vs. IN Comparison Condition Performance - Part1       (II)-Oracle SQL MEMBER vs. IN Comparison Condition Performance ...

Oracle SQL MEMBER vs. IN Comparison Condition Performance - Part2

›
(I)-Oracle SQL MEMBER vs. IN Comparison Condition Performance - Part1       (II)-Oracle SQL MEMBER vs. IN Comparison Condition Performance ...
Friday, January 2, 2026

"Disk file operations I/O" with (FileOperation: 8, fileno: 0, filetype: 8) Test

›
In this blog, we will make a test to demonstrate Oracle Wait Event "Disk file operations I/O" with (P1/FileOperation: 8, P2/filen...
‹
›
Home
View web version

About Me

ksun
View my complete profile
Powered by Blogger.