Hello, in this article, we will examine a script that prepares information about the database that we need to check daily and sends mail as Html. If you would like to read an article in a previously published article, which describes the daily, weekly and monthly procedures to be done as a DBA, you can […]
Processes use memories as pages, in the future these pages can be set to 4kB, 2MB or even 1GB specifically, in new systems this value is usually 2Mb. When processes want to use a memory space, this space is allocated as a page and this page is usually a very small unit, so processes that […]
We can use the following sql for Datafile Controlfile and Logfile control, we can check it again at the end of the drop process. SQL> select name from v$datafile; SQL> select name from v$controlfile; SQL> select * from v$logfile; Let’s connect and close the database SQL> shu immediate; Let’s open the database in Exclusive Mode […]