|
||||
|
If you are old junkie and rely more on “grant connect, resource to myself”, then you should look back this. From 12c onwards, resource role will not provide unlimited tablespace privilege and no longer available too. As we already know resource role is deprecated from 11g onwards and will not be available in future releases. […] Hello, There were the cases of denying “select any dictionary” privilege from database security teams especially in banking section since this privilege can access the sensitive views like DEFAULT_PWD$ etc. From 12c Onwards the “select any dictionary” system privilege no longer permits you to query the SYS schema system tables DEFAULT_PWD$, ENC$, LINK$, USER$, […] Going through the documentation and found the following were deprecated which we have may used in our environments. The following tns parameters have been deprecated, When you process a query that involves a connected database link, the server acts as a client to the target database of the database link. For example, suppose you have […] Earlier to 12c, the Flashback data archive option is not used compression of FDA data(the changes happens to the table will be copied to some internal FDA tables, Daily a partition is created for the table and the daily wise changes to the data will be copied to the FDA tables like SYS_FBA*). From […] In the last post you have seen how ADO helps us to cut down the storage costs and also improvise the efficiency. In this post we will test and Before to drill down to practice, ADO works in two steps. When the instance level heatmap is on, the real time statistics i.e data usage […] Before going to the topic, consider this example An enterprise request system where utilized by the IT employees across the globe and raise requests for their needs like Desktop issues, telephone issues, request for software, request for databases, request for procurement etc. On and average daily 5000+ requests across as I know this system exists […] Silent Installation using RunInstaller to install 12c Software, this will be useful when you do not have the X base system running on the machines (of course in real world they do not), either you need VNC or humming bird tools to install the oracle software if you want to use Oracle Universal Installer in […] When an transient disk failures happens the time to take to repair the offline disk from mirror groups will be set by diskgroup_repair_time. For example, If diskgroup_repair_time is set as 3 hours and with in this period if disk repair is not completed, the ASM will drop the disks. ASM keeps track of the changed […] Just to make a note here, (From Jafar notes) The ASM storage hard limits on maximum ASM disk groups and disk size has been drastically increased. In 12cR1, ASM support 511 ASM disk groups against 63 ASM disk groups in 11gR2. Also, an ASM disk can be now 32PB size against 20PB in 11gR2. […] Oracle Cluster Registry (OCR) backup in ASM disk group Before to 12c the ocr backup is located in the master node local disk at GRID_HOME/cdata/backup, but if OCR is corrupted and you have to restore you will need to find the master node and initiate the restore option. Storing the OCR backup in an […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!