open-menu
closeme
Home
All Oracle Scripts
Scripts & Commands
Links
Oracle Database Documentation
Oracle Enterprise Manager
About
Contact Us
Privacy Satement
🌐
English
Português
rss
Oracle Database Query to Find Tables with Outdated Statistics - Monitor Analyze Progress
calendar
Jul 1, 2025
· 3 min read
·
dba_tables
oracle
database
dba
statistics
performance
monitoring
sql
tuning
·
Share on:
twitter
facebook
linkedin
copy
Show a Count of Analyzed Tables by Schema in Oracle Database
calendar
Jun 30, 2025 /
Jul 1, 2025
· 3 min read
·
oracle
sql
database administration
performance
dba_tables
·
Share on:
twitter
facebook
linkedin
copy
Oracle PLAN_TABLE Setup and EXPLAIN PLAN Usage Guide
calendar
Jun 29, 2025 /
Jul 1, 2025
· 4 min read
·
oracle
database
sql
performance
optimization
explain-plan
query-tuning
dba
·
Share on:
twitter
facebook
linkedin
copy
Oracle ANALYZE Statement: Old-Style Table and Index Statistics Collection Explained
calendar
May 11, 2025 /
Jul 1, 2025
· 3 min read
·
oracle
analyze
table
index
statistics
·
Share on:
twitter
facebook
linkedin
copy
Oracle Segment Waits In-Depth Code Analysis and Insights using v$segment_statistics
calendar
Sep 25, 2024 /
Jul 1, 2025
· 3 min read
·
Oracle
Database
Performance
SQL
Optimization
v$segment_statistics
·
Share on:
twitter
facebook
linkedin
copy
Top 10 Hottest Objects in Oracle by Touch Count using tables x$bh obj$ and user$
calendar
Sep 20, 2024 /
Jul 1, 2025
· 2 min read
·
Oracle
Database
Performance
x$bh
obj$
user$
·
Share on:
twitter
facebook
linkedin
copy
Identify Waits by Datafile in Oracle using tables v$datafile and x$kcbfwait
calendar
Sep 19, 2024 /
Jul 1, 2025
· 2 min read
·
Oracle
Database
Performance
x$kcbfwaitv
$datafile
·
Share on:
twitter
facebook
linkedin
copy
Oracle Database Understanding Lock Conflicts with dba_lock and Column Formatting
calendar
Sep 6, 2024 /
Jul 1, 2025
· 2 min read
·
Database
SQL
Performance
Troubleshooting
Oracle
Database Administration
Performance Tuning
dba_lock
·
Share on:
twitter
facebook
linkedin
copy
Identifying Locked Rows in Oracle Database using tables v$session and dba_objects
calendar
Sep 5, 2024 /
Jul 1, 2025
· 2 min read
·
v$session
dba_objects
Oracle
Database Administration
SQL
·
Share on:
twitter
facebook
linkedin
copy
Oracle Database Uncover & Resolve Blocking Sessions with SQL using v$lock
calendar
Sep 4, 2024 /
Jul 1, 2025
· 2 min read
·
v$lock
Oracle
Database
SQL
Performance
Troubleshooting
·
Share on:
twitter
facebook
linkedin
copy
««
«
1
2
3
4
5
»
»»