Know the free space in Oracle database
Hello everyone.One of the most important tasks we face when administering an Oracle DB is to control the growth of the different components that form it. That is why we …
Renaming an Oracle DB using the NID command
Hello everyone, today we are going to share the way that exists in Oracle to rename a DB. To perform this action a command line application found in the installation …
ADDING A MIDDLEWARE SERVER TO CLOUD CONTROL
Hello friends! In today’s post we are going to continue “playing” with the Oracle Cloud Control platform. Let’s see how to add a Middleware server to Cloud Control, it is …
SQLTXTRACT y SQLTXPLAIN. How are they installed?
Hello friends!!! This week we are back with a post about ORACLE. Have you had problems with bugs, execution plans… and from support_oracle you have been asked for information having …
Bug in Oracle listener on Windows
Hello everyone! This week we are going to see a very common and simple problem to solve. It is a bug in Oracle trace files when they are more than …
Find a query in Oracle with stats$sqltext
Hello, today we are going to teach you how to find a query in Oracle with system views. First let’s see what the situation is in which we must analyze …