|
||||
|
Hello, As we all know, We have a profile setting called failed_login_attempts, where and which when a user inputs invalid password for a given threshold default is (unlimited) , then the user will be locked. Means the profile has to part with each and every user. Similarly, if you want to blockade/drop the connections for […] Thanks to Martin’s blog, which show us the data file recovery when it accidentally dropped. (apologies i lost the original link) ***** DO IT ON YOUR OWN RISK ***** Created tablespace and users and some tables. SQL> create tablespace test datafile ‘/oradata/TESTTest01.dbf’ size 100m; Tablespace created. SQL> create user test identified by test default […] I have got a request from the team asking to get the DML statements that ran against a table for a particular period of time For this, I have three options 1) If auditing is enabled, get the statements from the audit trail, but the problem will be no bind variable replacement and also the […] In Theory:- HugePages is a feature integrated into the Linux kernel 2.6. It is a method to have larger page size that is useful for working with very large memory. HugePages is useful for both 32-bit and 64-bit configurations. HugePage sizes vary from 2MB to 256MB, depending on the kernel version and the […] Another little feature in 11g is undo backup optimization. Prior to Oracle 11g, RMAN always backed up all UNDO with a full backup, including UNDO for committed blocks. However in 11g, RMAN is able to skip the UNDO information for those blocks that are already committed and exceeded undo_retnention threshold. This optimization brings in […] Atleast I found hard checking in many other areas,hence writing this You may not find the no rows for gather_stats_job in 11g due to the enhancments in maintainence groups. The collection of statistics along with some other maintainence tasks have been incorporated in to dba auto task admin client procedure First you need to […] With previous post you see the duration of stats job, but how long they can run? Well the answer for that would be depends on the scheduler windows. To understand scheduler windows, according to documentation:- A maintenance window is a contiguous time interval during which automated maintenance tasks are run. Maintenance windows are Oracle […] Here is the small script column job_name format a20 column status format a12 column actual_start_date format a36 column run_duration format a14 select job_name, status, actual_start_date, run_duration from dba_scheduler_job_run_details where job_name = ‘GATHER_STATS_JOB’ order by actual_start_date ;
JOB_NAME STATUS ACTUAL_START_DATE RUN_DURATION ——————– ———— ——————————– ————– GATHER_STATS_JOB SUCCEEDED 21-JAN-10 22.00.03.629836 +00:00 […] Came across this good table while scrolling the documentation, When you need to do a parallel DML and that involves partitions, give a serious thought about the DML locks that can acquire. Below table gives you a handy info for the same. Source:- here
Type of Statement Coordinator Process Acquires: Each Parallel Execution […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!