#کتاب_اوراکل

@oracledb
Oracle Database 12c: SQL and PLSQL new features(D90165GC10)

Student Guide + Activity Guide

major differences between RHEL 7 and 6 (1)

major differences between RHEL 7 and 6 (2)

major differences between RHEL 7 and 6 (3)

major differences between RHEL 7 and 6 (4)

major differences between RHEL 7 and 6 (5)

#اوراکل

ممانعت از تغییر پسورد توسط کاربران فاقد مجوز

افزایش سرعت درج انبوه با unusable کردن ایندکسها

.

#کتاب_اوراکل

@oracledb
Oracle GoldenGate 12c: Troubleshooting and Tuning(D85725GC10)

Student Guide + Activity Guide

Real tuning: use less resources. BIG savings: APPROX_RANK Function. Lower Memory use 1G to 3M & Temp (sorting) 1G to 0.

Top Database for Java Developers?

Oracle 19c has been released, but only on LiveSQL (livesql.oracle.com)

if you change the database character set from single byte to multibyte using ALTER DATABASE CHARACTER SET,
CLOB columns will remain in the original database character set.

This may introduce data inconsistency in your CLOB columns!!

#اوراکل

‏Auditing در محیط Active Data Guard

آشنایی با SQL*Loader همراه با چند مثال

.

#کتاب_اوراکل

@oracledb
Oracle Database 12c: Security (D81599GC10)

Student Guide + Activity Guide

Ever wanted to know if the optimizer is obeying your hint?
+HINT_REPORT #oracle_19c

In 18c/19c, you get the best of NOLOGGING and Data Guard that still sends the blocks to the standby.

Docker and Oracle

#اوراکل

نکاتی در مورد shmall، shmmax، sga_target، lock_sga

.

#کتاب_اوراکل

@oracledb
Exadata Database Machine: 12c Administration Workshop(D92887GC20)

Most #SQL expressions and non-aggregate functions using #null return null, so:

1 + NULL => NULL