Starting from release 12C there is a new option to pass in silent mode encryption password . The ENCRYPTION_PWD_PROMPT parameter enables encryption without requiring the password to be entered as a command line parameter. The user is prompted for the password during export utility. expdp … ENCRYPTION_PWD_PROMPT=Y Password: <user is asked for encryption password> In…
Leggi tutto
With previous releases PMON (Process Monitor) was responsible for registering database services to the Listener. Starting from Oracle 12C there is a change in architecture with respect to the service registration in Oracle Database Release 12c. Oracle has introduced a new mandatory background process dedicated for “database service registration to the Listener” and named LREG (Listener…
Leggi tutto
The APPROX_COUNT_DISTINCT function was added, but not documented, in Oracle 11g to improve the speed of calculating the number of distinct values when gathering statistics using the DBMS_STATS package. Oracle database 12c (12.1.0.2) now includes the function in the documentation, so we are free to use it in our applications as a supported SQL function.…
Leggi tutto
In Oracle 12c when we create a table we can populate a column automatically via a system generated sequence by using the GENERATED AS ++ clause in the CREATE TABLE statement. We can use GENERATED AS IDENTITY with the ALWAYS, DEFAULT or DEFAULT ON NULL keywords and that will affect the way or when the…
Leggi tutto
Oracle 12c rel.1 (12.1.0.2) introduced a new method for index compression called “advanced index compression” which is more effective in index compression than available methods in Oracle 11g . Creating an index using advanced index compression reduces the size of unique and non-unique indexes. Advanced index compression improves the compression ratios significantly . Advanced Index…
Leggi tutto
Until the release 11g move a datafile was an operation very problematic; We had to put the tablespace offline, copy the datafile to the new destination and rename it : SQL> alter database rename datafile “A” to “B”; From Oracle release Oracle 12c, you can move a datafile from a mount point to another without…
Leggi tutto
Oracle has announced the latest generation of Network-attached Storage or NAS system namely the Oracle ZFS Storage ZS4-4. ZFS Storage ZS4-4 doubles the performance over the previous version , allowing you to access the information they need to make strategic decisions for their business even more quickly . Oracle ZFS Storage ZS4-4 also provides a…
Leggi tutto
In a common situation present in many database we find that some users have been granted more privileges than what was needed and these privileges , over time , have remained . This could be dangerous to the security of the data and the database itself . In Oracle 12c we have a package called…
Leggi tutto
This feature is available starting with Oracle Database 12c Release 1 (12.1.0.2) When to use it: when you have enough memory to keep all segments in memory when you are limited by I/O system and response time Full database caching can be used to cache the entire database in memory. It should be used when…
Leggi tutto
Below is a list of some features desupported and deprecated since release Oracle Rdbms 12C Single character SRVCTL command The Server Control Utility (SRVCTL) command line interface (CLI), used in earlier releases, starting with Oracle Database 12c is deprecated and may be desupported in a later release. Catalog view The following views are…
Leggi tutto
Commenti recenti