Oracledataba.se
  • Home
  • About
  • Labs (Free)
  • LinkedIn
Sign in Subscribe

operational

A collection of 2 posts
Configuring a baseline using queries
Paid-members only
operational

Configuring a baseline using queries

Here are some queries that can be used to check the best execution plan using the tables dba_hist_sqlstat, dba_hist_sqltext, and dba_hist_snapshot: 1. List the SQL statements with the highest CPU usage in the last hour: SELECT sql_id, elapsed_time_delta/1000000 as elapsed_
Mar 14, 2023 1 min read
Managing tablespaces
Paid-members only
operational

Managing tablespaces

Mar 5, 2023 1 min read
Page 1 of 1
Oracledataba.se © 2023
  • Account Portal
  • Climate
  • LinkedIn
  • Donate
Powered by Ghost