Oracle 19c Linux 8 Install Tips
Some tips for oracle 19c in Linux 8 install.
Oracle 23ai Linux 9 Install Tips
Some tips for oracle 23ai install.
Oracle 23c Shrink Bigfile tablespace Tips
Oracle database 23ai onward we can use the DBMS_SPACE package to shrink a bigfile tablespace to reclaim unused space.
Oracle 23c ock-free reservation Tips
Lock-Free Reservation这项特性可用于实现更细粒度的并发控制。 它的本质是相对于传统的行锁,能以更细的粒度(即列值级别)进行锁定,从而减少锁争用,提高并发性能。
Oracle 23c SSB setting Tips
A small data pump export file for the SSB schema that can be used on a laptop
Oracle 23c SQL Diagnostic Report Tips
SQL Diagnostic Report
DBMS_SQLDIAG has a new function called REPORT_SQL
Oracle 23c set user password limit Tips
There is below errors while set simple password for test user.
ORA-28003: The password chosen did not meet the required complexity rules set
by your organization.
ORA-20000: password length less than 9 characters
Oracle 23c dbcs basic Tips
Some info
Oracle 23c create acfs in dbcs Tips
Create ACFS for oracle user.
Oracle CONTROL_FILE_RECORD_KEEP_TIME Tips
CONTROL_FILE_RECORD_KEEP_TIME
CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused.
Note:This parameter applies only to records in the control file that are circularly reusable (such as archive log records and various backup records). It does not apply to records such as data file, tablespace, and redo thread records, which are never reused unless the corresponding object is dropped from the tablespace.
Oracle NLS_DATE_FORMAT Tips
Setting NLS_DATE_FORMAT in the shell environment variable using setenv or export command is not effective. When querying dates from SQL*Plus, it does not reflect the NLS_DATE_FORMAT.
% setenv NLS_DATE_FORMAT 'YYYYMMDD'
% sqlplus / as sysdba
SQL> select sysdate from dual;
SYSDATE
---------
17-SEP-18
Oracle 23c Free rpm install Tips