|
||||
|
Ofcourse you will have a manual that states about your environment. But how to get it from the database. In otherwords if you have given a database to check your tablespaces that is running in exadata storage and you want to uae hybrid columnar compression (possible only with exadata) Humor; dont say you run create […] My friend has an issue yesterday which took sometime to figure out in important time during a release. Hooe this may help you too. ORA-01031: insufficient privileges , while creating DB Link SQL> select * from dba_sys_privs; USERNAME PRIVILEGE ADM —————————— —————————————- — TEST321 ALTER ANY PROCEDURE NO TEST321 CREATE DATABASE LINK NO TEST321 CREATE […] What is a Checkpoint? A synchronization event at a specific point in time Causes some or all dirty block images to be written to the database thereby guaranteeing that blocks dirtied prior to that point in time get written Brings administration up to date Several types of checkpoint exist Types of Checkpoints? Full Checkpoint Thread […] SQL> recover database ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done Am trying to recover a database after a controlfile lost and restored from the backup. But How does Oracle knows that we are using a backup control file where does it look after to get […] What kind of records that control file maintains in Oracle database? Lets have a look. SQL> oradebug setmypid Statement processed. SQL> oradebug unlimit; Statement processed. SQL> alter session set events ‘immediate trace name controlf level 9’; Session altered. SQL> oradebug tracefile_name; /home/oracle/app/oracle/diag/rdbms/testdb/testdb/trace/testdb_ora_1238.trc SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit […] If you are experiencing the log file sync wait after an upgrade to 11.2.0.3 and most importantly that as there are no other symptoms of issues with I/O or in other areas, the problem could be with excessive switching between post/wait and polling wait methods. While writing previous post, came across the another interesting note […] Log file sync event can appear in any busiest system or the environment that configured badly or might be due to some bugs. But log file sync is an accumulated time taken of other aspects which is not alone a foreground process that is waiting for commit post/poll acknowledgement from LGWR. The log file sync […] Hi How to track the password change for a user in Oracle? A) Oracle only tracks the date that the password will expire based on when it was latest changed. So by looking at the DBA_USERS.EXPIRY_DATE and subtracting PASSWORD_LIFE_TIME you can determine when password was last changed. The last password change time can also directly […] Hi, Quick reference from documentation on Oracle Database limits Reference:- http://docs.oracle.com/cd/E11882_01/server.112/e24448/limits.htm Datatype Limits: Talks about the limits for each data type eg: raw size, char size etc. Physical Database Limits: Talks about limits of datafile, blocksizes, maxlimits etc Logical Database Limits: Talks about limits of max subqueries, constraints, partitions,users and roles etc. Process and Runtime […] Opatch: Enable/disable the one off oracle patch to all of the databases using opatch util Problem: ======== Consider this situation, 1) You have Shared Oracle Home 2) 2 Databases running 3) You need to apply a patch for one databases only Many of us know once we apply the patch to a home this […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!