Oracle 23c create user values Tips
SYS@cdb1> alter session set container=pdb1;
Session altered.
SYS@cdb1> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB1 READ WRITE NO
SYS@cdb1> create user lin1 identified by oracle123;
User created.
SYS@cdb1> grant create session,connect,resource to lin1;
Grant succeeded.
SYS@cdb1> select name,password,spare4 from user$ where name='LIN1';
NAME PASSWORD SPARE4
------------------------------- -------- ----------------------------------------------------------------------------------------------------
LIN1 S:5C99D4EC0ECB789E3F6C20FD6540CBEC53E0D6F1DD9B549183E0F76FD6E8;T:8B2315DEEE500DB9A233B8CC58B25EC9E17
F1A59D8DEEF0D4CA7D6B3479B3C4818E3A1C19245B93A1104146CB5F4CD76A45F29398E1488A4FFC1135327F7BEA7A7C896C
413897D77E4C682713370E2D3
SYS@cdb1> create user lin2 identified by values 'S:5C99D4EC0ECB789E3F6C20FD6540CBEC53E0D6F1DD9B549183E0F76FD6E8;T:8B2315DEEE500DB9A233B8CC58B25EC9E17F1A59D8DEEF0D4CA7D6B3479B3C4818E3A1C19245B93A1104146CB5F4CD76A45F29398E1488A4FFC1135327F7BEA7A7C896C413897D77E4C682713370E2D3';
User created.
SYS@cdb1> grant create session,connect,resource to lin2;
Grant succeeded.
SYS@cdb1> conn lin1/oracle123@pdb1
Connected.
LIN1@pdb1> conn lin2/oracle123@pdb1
Connected.
LIN2@pdb1>
Oracle 23c New features - sql_transpiler Tips
About the Encryption of Tablespaces in an Oracle Data Guard Environment
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.
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
%
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.
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.
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.
Oracle 23c New features - Update Using Direct Join Tips
Oracle 23c New features - IF EXISTS and IF NOT EXISTS with CREATE, ALTER, and DROP commands Tips
Oracle 23c New features - Develop role Tips
Oracle Developer Tools for VS Code (SQL and PLSQL) Tips
Oracle 23c recover table from rman Tips