Please turn JavaScript on
Oracle DBA Resource icon

Oracle DBA Resource

Want to know the latest news and articles posted on Oracle DBA Resource?

Then subscribe to their feed now! You can receive their updates by email, via mobile or on your personal news page on this website.

See what they recently published below.

Website title: Oracle DBA Resource – /*+ Databases don't have performance problems, people do.*/

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.38 / day

Message History

Checking staistics history on table

COL TABLE_NAME FORMAT a10SELECT TABLE_NAME, TO_CHAR(STATS_UPDATE_TIME,'YYYY-MM-DD:HH24:MI:SS') AS STATS_MOD_TIMEFROM DBA_TAB_STATS_HISTORY WHERE TABLE_NAME='ORDERS'AND OWNER='OE'ORDER BY STATS_UPDATE_TIME DESC;

Restore Table statistics

BEGIN DBMS_STATS.RESTORE_TABLE_STATS( 'OE','ORDERS', TO_TIME...

Read full story

Identify the number of executions and total elapsed time for the underlying SQL ID

SELECT BEGIN_INTERVAL_TIME,PLAN_HASH_VALUE, sql_profile, EXECS, ROUND(TOTAL_ETIME/EXECS/1000000,4) AVG_ETIME, ROUND(TOTAL_LIO/EXECS,2) AVG_LIO, ROUND(TOTAL_PIO/EXECS,2) AVG_PIO from (select TO_CHAR(begin_interval_time,'DD/MON/YYYY') as begin_interval_time, plan_hash_value, sql_...

Read full story

A practical command reference for Oracle Database 19c Real Application Clusters (RAC) administrators. Use it to check cluster health, nodes, instances, services, ASM, storage, networking and logs during routine operations and incident triage.

Scope: Oracle Grid Infrastructure 19c and Oracle Database 19c on Linux. Run commands as the appropriate owne...


Read full story
Read full story