|
||||
|
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 […] We all know that Oracle has a statistics to calculate the Oracle usage of CPU with “v$sysstat.name=’CPU used by this session’” But this statistic value got a problem, since the value will not be accounted/cumulated until the call on the cpu completed, For example, for a PL/SQL program if it takes one hour to complete […] Hello, A multi-core processor is a single computing component with two or more independent actual central processing units (called “cores”), which are the units that read and execute program instructions.[1] The instructions are ordinary CPU instructions such as add, move data, and branch, but the multiple cores can run multiple instructions at the same time, […] Normally, archived redo log files in a flash recovery area that were backed up to a tertiary device or made obsolete (as defined by the RMAN retention policy) are eligible for deletion. The archived redo log files that are backed up or obsolete can eventually be deleted automatically to make space if the disk space […] A note on tracing when you have dataguard environment, Use the following useful SQL SELECT group#, member FROM v$logfile WHERE type = ‘STANDBY’; SELECT group#, dbid, archived, status FROM v$standby_log; SELECT dest_id,valid_type,valid_role,valid_now FROM v$archive_dest; SELECT process, status, group#, thread#, sequence# FROM v$managed_standby order by process, group#, thread#, sequence#; SELECT name, value, time_computed FROM v$dataguard_stats; SELECT […] Here I log, some important ASM scripts which are very useful for me as well as a ready reference for you all. Before to scripts, here are the important views respective to ASM instances. View Name ASM Instance DB Instance V$ASM_DISKGROUP Describes a disk group (number, name, size related info, state, and redundancy type) Contains […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!