Query to find Tablespaces and Data files in Oracle 11g

preview_player
Показать описание
#Oracle stores #data logically in tablespaces and physically in #datafiles associated with the corresponding #tablespace.
Databases and Tablespaces : An Oracle database consists of one or more logical storage units called tablespaces. The database's data is collectively stored in the database's tablespaces.
Tablespaces and Datafiles : Each tablespace in an Oracle database consists of one or more files called datafiles. These are physical structures that conform with the operating system in which Oracle is running.
A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. A more complicated database might have three tablespaces, each consisting of two datafiles (for a total of six datafiles).

00:00 What is a Tablespace?
01:02 Find Tablespaces in Database
03:30 Files associated with a Tablespace

Рекомендации по теме
Комментарии
Автор

Great tutorial. You explain it in a way newbies like me can understand.

jamal
Автор

Clear explanation👍but how can we find what are the tables present in a particular tablespace or if we have a table, then how can we see which tablespace it resides in

golimounika
Автор

Hi arun I love ur videos. Very well explained.keep it up

siamanawaz
Автор

I also want to see some performance related videos if you can post them it will be a great help to our community

sandeepsindhu
Автор

Hi sir can you please post the RAC course as well

sandeepsindhu
Автор

Hi Arun, can u provide real time interview questions and answers for 2+years of experience

chandrashekharbr
Автор

Hi arun I love ur videos. Very well explained.keep it up

siamanawaz
join shbcf.ru