Oracledataba.se

Home
About
Labs (Free)
LinkedIn

Sign in Subscribe

operational

Managing tablespaces

Useful queries to manage tablespaces

Luis

Mar 5, 2023 • 1 min read

Photo by Verne Ho / Unsplash

This post is for paying subscribers only

Subscribe now

Already have an account? Sign in

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

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

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