|
||||
|
To tune the cluster interconnect performance typically the messages buffers size that should transmit between the nodes, the following kernel parameters should set. 256K is fairly adequate. net.core.rmem_default = 262144 net.core.rmem_max = 262144 net.core.wmem_default = 262144 net.core.wmem_max = 262144 -Thanks Geek DBA Hello, I have got two questions from my friend. 1) What is the difference between object_id and data_object_id? 2) Will be there any performance impact if data_object_id changes? For the question #1, a) Object_id represents the primary_key or the unique identifier for the object b) data_object_id is the pointer […] 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 […] Hello All, We have got an issue about time zone differences in alert logs , crs logs with system timestamp and with system timestamp. System date time [oracle@TESTRAC1]/ # date Tue Apr 24 04:10:11 CEST 2013 But database Alert log shows, Thread 1 advanced to log sequence 235 (LGWR switch) Current log# 11 […] Dear Readers, We have few good posts in Oracle community this week and here are they, and very interesting though Jonathan Lewis on Systimestamp puzzles:- systimestamp Oracle optimizer blog comes up with method_opt parameter significance in dbms_stats How does the METHOD_OPT parameter work- Randolf Geist on ASM AU Size And LMT AUTOALLOCATE Arup Nanda […] To identify the clustername in Oracle CRS use $CRS_HOME/bin/cemutlo –n or Use OCRDUMP which will create a text file called OCRDUMPFILE open that file and look for this entry #ocrdump -stdout -keyname SYSTEM | grep -A 1 clustername | grep ORATEXT | awk ‘{print $3}’ or In the script $ORA_CRS_HOME/install/rootconfig: ORA_CRS_HOME=/oracle/product/CRS CRS_ORACLE_OWNER = Oracle […] We have got a call from team asking about a high cpu usage, and here is our hunting down load averages: 97.5, 98.8, 100.0; up 11+22:24:01 01:14:52 410 processes: 276 sleeping, 118 running, 3 zombie, 13 on cpu CPU states: 0.0% idle, 89.6% user, 10.4% kernel, 0.0% iowait, 0.0% swap Memory: 32G phys mem, 17G […] 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 […] Hello All, This is the first post and test post for this new site, if you are encountering any issues with site please drop me an email with issue, will fix it. For those who enrolled post to email subscription, they should receive this post via email, if not can you please spare sometime […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!