Alter session example Hello everyone and welcome. I hope that you are doing fine in this lecture we will understand the altercation statement. We will do a very simple and nice example. First thing, I am connected on CIS user and my virtual machine is up and running. I will make this query select name comma value from video sign parameter order by name. So this view, it will show you all the parameters or all the database parameters in the current session I would execute this and you can…

Initialization Parameters & Parameters Files Hello everyone and welcome back. Welcome to this new chapter. In this chapter we will talk about managing database innocence. This chapter is very important and we will learn many important things. We will start by initialization parameters and parameters files. And this is one of the most important topics in Oracle database course. So now let’s start. First thing when you start up the instance, it reads instance configuration parameters. We call these parameters initialization parameters and the innocence read it from a file…

cdb_tablespaces / V$TABLESPACE Hello everyone and welcome back. I hope that you are doing fine in this lecture. We will understand how to query the table space. And we have two main tables CDB underscore table spaces and visualar sign table space. And I assume that you know from now what is the difference between these two. Anyway, maybe you will ask yourself. It is a very huge subject. We have thousands of tables, we have thousands of views. How we can remember all these things? The answer no need…

query the temps files Hello everyone and welcome. In the previous lecture we understand how to query the data files. In this lecture we will understand how to query the temp files. I just want to tell you a very important note. Don’t try to go deep about this subject. In this lecture only I need you to know how to write the query for data files and temp files and whatever. We will understand the concept of all these in details in the next chapters. So just relax, okay?…

Understanding Dynamic Performance Views Hello everyone and welcome. In this lecture we will understand the concept of dynamic performance views and many people they name it V dollar sign views because it starts by the dollar sign. The purpose of this lecture is only to understand the concept. We have thousands and thousands of video sign views, but at least we should understand what is the meaning of video sign views are a set of underlying views that are maintained by the server and accessible to the database administrator user…

oracle data dictionary concept Hello everyone and welcome in this new chapter. In this chapter we will talk about many things and we will take helpful query that will help you a lot. Now in this lecture we will talk about Oracle data dictionary. I assume that you have a big information about this subject, but I just want to add new information for you. So now the Oracle data dictionary, it is a meta database about the database. Like for example, you need to know how many objects you…

connecting using tnsnames Hello everyone and welcome back. In the previous lecture we understand what is the meaning of easy connect. In this lecture we will learn how to connect using the Tnsnames aura. So we will go to the home other location computer u one app Oracle products 18 DB one and you will go to network and I will go to admin. Then you will find T in its name or I will open. You can see now that I have entry called ORCL. Now what I will…

Moving from container to pluggable Hello everyone and welcome back. In the previous lecture we learned how to connect as Sys. As Sysdba. In this lecture we will connect also as Sysdba and we will do some nice things. We will learn how to move to the Blogger build databases. Remember that Oracle twelve C, 18 C, that we have the concept of multitenant database. I have a big database, a rule database. Inside this database. I have bloggable databases. Okay, remember this very well. So now I will log…

Unplugging and plugging in PDBs part 1 Hello everyone and welcome back. In the previous lectures, we understand the cloning of bloggabil databases. In this lecture we will understand a very nice topic which is unblogging and blogging in blogabill databases. What is the meaning of this? Now suppose that I have a server and in this server I have two container databases container Database One and Container Database Two. Remember that each container should have at least one root and one bloggable database seed and zero or more bloggle…

Dropping pluggable using SQL Hello everyone and welcome back. I hope that you are doing fine. In the previous lectures we understand how to create new bloggers and databases from the seed. And also we learn how to connect to this bloggabel. Now we will learn how to drop the blogger database. But before that why we need to drop a bloggable database actually. Because maybe we created this Blogger Bell for training purpose. Or maybe we created this bloggle to test a patch or to test assumption. So that’s…