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

Managing tablespaces

Useful queries to manage tablespaces

  • Luis

Luis

Mar 5, 2023 • 1 min read
Managing tablespaces
Photo by Verne Ho / Unsplash

This post is for paying subscribers only

Subscribe now

Already have an account? Sign in

Configuring a baseline using queries
Paid-members only

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
ORA-20000 in a multitenant database while doing an export
Paid-members only

ORA-20000 in a multitenant database while doing an export

When doing a expdp of a PDB, you may see the next error message: ORA-20000: Resource Manager Plan Is Not Active or is not managing CPU usage This are the steps to avoid the error message and be able to do the export:
Feb 8, 2023
ORA-65149: PDB name conflicts with existing service name in the CDB or the PDB
Paid-members only

ORA-65149: PDB name conflicts with existing service name in the CDB or the PDB

After refreshing a database with a container database, you need to restore the refreshed name of the pluggable database to the expected in the non-prod environment. For this, you would first connect to the PDB and restart it on "open restrict" mode: SQL> alter session set container=DBONEPDB; Session altered.
Jan 26, 2023 1 min read
Oracledataba.se © 2023
  • Account Portal
  • Climate
  • LinkedIn
  • Donate
Powered by Ghost