This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

DB Perf Tuning

//DB Perf Tuning

Scripts To Tune The Database

By | January 4th, 2013|DB Perf Tuning, Oracle DBA|

Buffer Hit Ratio prompt ******************Buffer Hit Ratio****************** ; prompt select sum(decode(name,'physical reads',value,0)) PhyReads, sum(decode(name,'physical reads direct',value,0)) PhyReadsDir, sum(decode(name,'physical reads direct (lob)',value,0)) PhyReadsDirLOB, sum(decode(name,'db block gets',value,0)) DBGETS, sum(decode(name,'consistent gets',value,0)) COnsistentGETS,(1- (sum(decode(name,'physical reads',value,0)) - (sum(decode(name, 'physical reads direct',value,0)) + sum(decode(name, 'physical reads direct (lob)',value,0))) ) / ( sum(decode(name, 'db block gets',value,0)) + sum(decode(name,'consistent gets',value,0)) - (sum(decode(name,'physical reads [...]

Tuning – Enhancing the Performance of Oracle Database

By | June 2nd, 2011|DB Perf Tuning, Oracle DBA|

1). Introduction: Tuning is studying the configuration of a system. Every one involved with the system has some role in the tuning process. By tuning oracle database, you can tailor its performance to best meet your needs.   2). Goals for Tuning: Consider the performance issues when designing the system tuning at hardware level and [...]

Realtime Database Queries

By | May 30th, 2011|DB Perf Tuning, Oracle DBA|

    1). Fragmentation Information about Tablespace:     (a). To get the biggest 10 free blocks available: select * from (select blocks, bytes from dba_free_space where tablespace_name = '&tableSPACEname' order by blocks desc) where rownum < 11; (b). To get the number of free blocks available: select count(*) from dba_free_space where tablespace_name = '&tableSPACEname'; [...]

How to Tune query that cannot modify ?

By | December 20th, 2010|DB Perf Tuning, Oracle DBA|

Query cannot be modified as it is hardcoded in an application or is generated by application code. "Query Tuning issues can often be alleviated by modification of the query in question, either to add hints or to change the query structure to avoid an issue. However in some cases the query cannot be modified because [...]

Query to find table import speed in oracle

By | December 10th, 2010|DB Perf Tuning|

You can use the below query to find table import speed. _______________________________________ Login as sys/system and run the query: select substr(sql_text,instr(sql_text,'INTO "'),30) table_name, rows_processed, round((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes, trunc(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_min from   sys.v_$sqlarea where  sql_text like 'INSERT %INTO "%' and  command_type = 2 and  open_versions > 0; Regards Dinaz