|
||||
|
In the previous post we discussed about the Parent & Child Cursors in Oracle and how do they work or shared. To get into deeper, Oracle controls the sharing of cursors with parameter called cursor_sharing. It has three values EXACT SIMILAR FORCE In this post we will create a table which has some records with […] What are PARENT AND CHILD CURSORS IN ORACLE A cursor is a memory area in library cache allocated to a SQL statement which stores various info about the SQL statement like its text, execution plan, statistics etc. Each SQL statement has One Parent cursor One or more child cursors PARENT CURSOR It […] Cluster integrity and cluster membership will be governed by occsd (oracle cluster synchronization daemon) monitors the nodes using 2 communication channels: – Private Interconnect aka Network Heartbeat – Voting Disk based communication aka Disk Heartbeat Network heartbeat:- Each node in the cluster is “pinged” every second Nodes must respond in css_misscount time (defaults to […] Hello, A long notes (confusing) on listeners in 11gR2 RAC. You all aware of we have two listeners running in database servers in Grid Infrastructure (Aka RAC) namely scan listeners and node listeners. How does they work? The SCAN works by being able to resolve to multiple IP addresses reflecting multiple listeners in the cluster […] Hello All, My best wishes for Christmas and upcoming new year to you all! This year has been very promising to me via this blog which earned me a lot of good friends and fellow DBA’s, indeed I have a learnt a lot too via this channel. I recognized that the journey of this blog […] You can find Cluster interconnect traffic from 11gR1 using dba_hist_ic_client_stats This view has a column called name which gives you the ability to measure three different types of interconnect traffic. •ipq – Parallel query communications •dlm – Database lock management •cache – Global cache communications break on snap_id skip 1 compute sum of DIFF_RECEIVED_MB on […] Here is the nice script for finding the row lock (hoping you will find the locked objects easily) select do.object_name , row_wait_obj# , row_wait_file# , row_wait_block# , row_wait_row# , dbms_rowid.rowid_create (1, ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW#) from v$session s , dba_objects do where sid=&sid and s.ROW_WAIT_OBJ# = o.OBJECT_ID ; select * from tablename where rowid=”; […] When transactions hit the database. Each transaction will be allocated one UNDO segment. The transaction will look for extents in the UNDO segment to place UNDO data. It will pick up segments as follows – (1) Pick up an UNDO segment, which has no ACTIVE extent, if none allocate a new segment. If space does […] Hello All, Sometimes we were been asked to provide the object or a table growth, Here is some nice script, which is useful to find the table growth per day for a given table; select obj.owner, obj.object_name, to_char(sn.BEGIN_INTERVAL_TIME,’RRRR-MON-DD’) start_day, sum(a.db_block_changes_delta) block_increase from dba_hist_seg_stat a, dba_hist_snapshot sn, dba_objects obj where sn.snap_id = a.snap_id and obj.object_id = […] Perhaps, you are also one of like me, difficult to understand about Oracle Licensing strategy with respect to CPU and Cores. You will need to know about two types for a processor based licensing, 1) Is your host/server is non-virtual based The Processor license for the Oracle Enterprise Edition is based on the number of […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!