Lin Hong's TECH Blog!

【学习】 2025年阅读清单

Oracle 23c New features - Real-Time SQL Monitoring Enhancements Tips

2022-12-20

Oracle

Oracle 23c Features Tips

Oracle 23c New features - Real-Time SQL Monitoring Enhancements Tips

Real-time SQL Monitoring works independently and concurrently across multiple PDB containers in an efficient manner. SQL statements, PL/SQL procedures and functions, and DBOPs (Database Operations) are monitored at PDB and CDB levels. You can efficiently query SQL Monitor reports across ad-hoc time ranges, DBIDs (internal database identifiers), and CON_DBIDs (CDB identifiers). This data is also accessible through SQL History Reporting.

Additionally, SQL Monitoring data can be exported along with the Automatic Workload Repository (AWR) and imported into another database or container for longer term storage and analysis.

Real-time SQL Monitoring is now supported per-PDB and CDB levels efficiently by default. As a PDBA persona, you can get a more accurate view of the monitored SQL for your application.

SQL Monitoring data can be transported through the AWR framework to a different container or database for longer term storage and offline analysis.

Read All
Oracle 23c New features - Automatic Parallel Direct Path Load Using SQL*Loader Tips

2022-12-20

Oracle

Oracle 23c Features Tips

Oracle 23c New features - Automatic Parallel Direct Path Load Using SQL*Loader Tips

The SQLLoader client can automatically start a parallel direct path load for data without dividing the data into separate files and starting multiple SQLLoader clients. This feature prevents fragmentation into many small data extents. The data doesn’t need to be resident on the database server. Cloud users can employ this feature to load data in parallel without having to move data on to the cloud system if there is sufficient network bandwidth.

SQL*Loader can load data faster and easier into Oracle Database with automatic parallelism and more efficient data storage.

Read All
Oracle 23c New features - Evolution of Oracle Homes Tips

2022-12-20

Oracle

Oracle 23c Features Tips

Oracle 23c New features - Evolution of Oracle Homes Tips

Oracle base home, Oracle base config, and orabasetab.

Read All
Oracle 23c New features - Control PDB Open Order Enhancements Tips

2022-12-20

Oracle

Oracle 23c Features Tips
Oracle 23c New features - Control PDB Open Order Tips

Control PDB Open Order

To Set the Priority of a PDB
```
Use the ALTER PLUGGABLE DATABASE <databasename> Priority <value> set the priority.
```
Read All
Oracle 23c create user values Tips

2022-12-20

Oracle

Oracle 23c Tips

Oracle 23c create user values Tips

Read All
Oracle 23c New features - Encryption of Tablespaces in an Oracle Data Guard Tips

2022-12-19

Oracle

Oracle 23c Features Tips

Oracle 23c New features - sql_transpiler Tips

About the Encryption of Tablespaces in an Oracle Data Guard Environment

Read All
Oracle 23c New features - DBCA Support for Standard Edition High Availability Tips

2022-12-19

Oracle

Oracle 23c Features Tips

Oracle 23c New features - sql_transpiler Tips

Oracle DBCA Support for Standard Edition High Availability

Using the Oracle Database Configuration Assistant (Oracle DBCA) and facilitating Oracle’s Automatic Storage Management or Oracle’s Advanced Cluster File System, you can now quickly create a Standard Edition High Availability Oracle Database fully configured for automatic failover.

Oracle Standard Edition High Availability Database can now be created very easily with more automation, eliminating manual steps and the associated complexity.

Read All

MacOS restart ssh Tips

2022-12-19

Linux

Linux ssh Tips

MacOS restart ssh Tips

 % sudo launchctl list | grep ssh
 % sudo launchctl load -w /System/Library/LaunchDaemons/ssh.plist 
 % sudo launchctl list | grep ssh                                
-	0	com.openssh.sshd
 % sudo launchctl unload /System/Library/LaunchDaemons/ssh.plist
 % sudo launchctl list | grep ssh                               
 % sudo launchctl load -w /System/Library/LaunchDaemons/ssh.plist
 % sudo launchctl list | grep ssh                                
-	0	com.openssh.sshd
 % sudo systemsetup -getremotelogin 
Remote Login: On
 % 

Read All

Oracle 23c Store AWR Snapshots In User Defined Tablespace Tips

2022-12-16

Oracle

Oracle 23c awr Tips

Oracle 23c Store AWR Snapshots In User Defined Tablespace Tips

The AWR warehouse is built in the SYS schema, using the SYSAUX tablespace by default. Oracle Database, by default captures snapshots once every hour; the snapshot size varies depending on the database load. These snapshots will be stored in SYSAUX tablespace.

Starting with Oracle Database 19.1c, the user can specify a user defined tablespace for AWR data/snapshots by using the ‘dbms_workload_repository.modify_snapshot_settings’ procedure, using ‘tablespace_name’ parameter.

Read All
Oracle 23c New features - sql_transpiler Tips

2022-12-15

Oracle

Oracle 23c Features Tips

Oracle 23c New features - sql_transpiler Tips

Automatic PL/SQL to SQL Transpiler PL/SQL functions within SQL statements are automatically converted (transpiled) into SQL expressions whenever possible.

Transpiling PL/SQL functions into SQL statements can speed up overall execution time.

Read All
Oracle 23c New features - Parallel DML Tips

2022-12-15

Oracle

Oracle 23c Features Tips

Oracle 23c New features - Parallel DML Tips

Oracle Database allows DML statements (INSERT, UPDATE, DELETE, and MERGE) to be executed in parallel by breaking the DML statements into mutually exclusive smaller tasks. Executing DML statements in parallel can make DSS queries, batched OLTP jobs, or any larger DML operations faster. However, parallel DML operations had a few transactional limitations. This included the touch-once restriction of a parallel DML statement, which meant that once an object is modified by a parallel DML statement, that object cannot be read or modified by subsequent statements within the same transaction.

This feature removes the touch-once restriction, you can now run parallel DMLs and any combination of statements such as queries, serial DML, and parallel DML on the same object, within the same transaction. This enhancement helps provide flexibility in ETL application development using parallel DMLs, and enables data transformation and cleansing tasks before the commit of the transaction.

You can now accelerate critical business processes using parallel DML without previous transactional constraints.

Read All
Oracle 23c New features - Update Using Direct Join Tips

2022-12-14

Oracle

Oracle 23c Features Tips

Oracle 23c New features - Update Using Direct Join Tips

Read All

6/37