|
||||
|
Folks! this subject line may sound silly, but most of us really think how for a moment. Business Requirement is some want to add a column to high volatile table, So they want to understand, Does it cause issue as its high volatile and access by Website? What is the best time to add a […] Hello, I am bumped on the following to answer in a exact sequential way, hence want to note it here. While in a rac installation, when you run root.sh , what are the sequence of actions that take place? Node 1 Initial Setup Setup OLR for storing Oracle local registry data Setup GPnP wallet and […] 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 All, In continuation of my previous post, Quick Question: When is my table last accessed? Does my index is in use? I have another questions when is my table last modified and what are the ways i can view it. Here you go, 1) Enabling audit on segment 1)Enable auditing […]
My friend is having a problem while import using IMPDP, which poses us some questions here. The impdp is hung or just processing at constraints enabling around 7000+ (massive 2TB database) and apparently ran for 3 days. Note, He had already used parallel = 10. Now question is, 1) Does parallel clause work […] Why do we have a Virtual IP (VIP) in Oracle RAC 10g or 11g? Why does it just return a dead connection when its primary node fails? The goal is application availability with the shortest disruption time possible. When a node fails, the VIP associated with it is automatically failed over to some other […] My old good friend has a question, am not sure whether I have cleared when we discussed but here I made this attempt. “What is the difference between undo,flashback log, redo log files.” First Flashback log vs. Redo log 1) Flashback logs and redo log files are similar in nature 2) LGWR writes to redo […] Very old thing, but to just refresh, Ever wonder how the extent sizes is managed if your tablespace is in LMT and autoallocate as like below.
CREATE TABLESPACE large_tables DATAFILE ‘/u01/oracle/data/DB1/large_tables_01.dbf’ SIZE 100M EXTENT MANAGEMENT LOCAL AUTOALLOCATE; When you specify auto allocate, Oracle will allocate extent sizes of 64KB, 1MB, 8MB, […] We all know that when a query/statement is running from long time (actually this post is meant to know at what times :)) , the access path will be shown in v$session_longops Some of the access paths are as below Table scan; Index Fast Full Scan; Hash join; Sort/Merge; Sort Output; Rollback; Gather Table’s Index […] How to measure the GES Resources (enqueues for RAC ) limit in RAC? Oracle preserves the integrity of the users data during simultaneous use of the same data blocks by different instances using GCS. In addition to data blocks, many other shared resources can be concurrently accessed by end users. Oracle uses a queuing mechanism […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!