What are the different types of Tablespaces in an Oracle Database - DBArch Video 23

In this video you will understand about the different types of tablespaces and their use/purpose. .
Our Upcoming Online Course Schedule is available in the url below
docs.google.com/spreadsheets/...
Reach us at [e-mail]

[@electrotech7]

2 hour of class lecture but nothing understand and this 10mint video give all the knowledge in a very easy way Thanks sir

[@hariskeelan9940]

Your training beats Oracle's. This is how good you are.

[@vikrammehta287]

Simply amazing way to teach oracle concepts in short and concise form. I could'nt find any other YoutTube video as good as your's. Thanks for sharing !! Please keep uploading more videos like DB creation, SQL performance tuning

[@RamkumarSwaminathan]

Thanks, enjoy learning.. there is a playlist on tuning... But not yet complete

[@abhishekkashyap4511]

Ultimate personlatiy!! I am big fan of you Sir..
Best explanation i have ever seen .
Thank you so much !

[@uzzalbasak2517]

Thanks, Sir, for Realy easy and wonderful Explanation!

[@vedashwi]

wow..... am really thank full to you... great way of explanation....

[@mohammedwahid2316]

very good and simple explanation

[@pavanhr1]

thank you sir..very brief and precise....keep going with more concepts on DB...

[@RamkumarSwaminathan]

Thanks ... Enjoy learning

[@manzoor5554]

Very good job..DONE....

[@sujaa1000]

Many many thanks to you
Regards,
Sujaa

[@rahulmittal116]

Useful information sir !

[@sunandareddy5126]

excellenttttttt sir,

[@gianlucarusso8475]

wonderful videos

[@balajichandramohan5117]

Hi sir,
Good one. Which tablespaces are created at the time of database creation.

[@pranavdeshmukh9987]

best explainer.. thank you

[@RamkumarSwaminathan]

+pranav deshmukh thanks

[@tirupatiy6735]

Excellent sir, thank you

[@RamkumarSwaminathan]

+tirupati Y thanks... Hope you are liking the videos too... And hitting the like button

[@tirupatiy6735]

Yes Sir, I am learning many things from you. Thank you very much your help

[@surajprasad2291]

Hi Sir, Great Explanation! Just curious to know what kind of performance metrics are stored in the AUX Tablespace. Thanks,Suraj

[@rajinistephen]

.
ll,
.
L
Hvv hv

[@SuperBES49]

amazing video.

[@RamkumarSwaminathan]

Thanks

[@latharupert389]

How to know the given tablespace is temporary,permanent or undo. Suppose i created a temporary tablespace named latha,how can the other users know that it's a temporary tablespace. Any querry?

[@RamkumarSwaminathan]

The contents column of dba_tablespaces will reveal the type of tablespace.... docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_4157.htm#REFRN23287

[@imtiazbasha8584]

Good afternoon sir,
I have a some query.
The question is, I have a database.
Suppose one user u1 is updating 1lakh of records and he has not committed and the database is in undo_ retention_gurantee.
And undo tablespace did not have free space.
Other user u2 is selecting the data from database.
Another user u3 is inserting 1million records in database.
3 users are executing stmts simultaneously.
What error will get u3?
Please reply answer as soon as possible

[@RamkumarSwaminathan]

U1 and u3 will get error in the transactions... u2 may get a snapshot too old if read consistency cannot be met...

[@vinothpalani7861]

What is snapshot sir ?

[@vikram4755]

Very informative, however i liked the earlier technique, as in these latest ones, graphics (before any new topic) interrupt the flow of your explanation. Its my personal view :)

[@RamkumarSwaminathan]

Thanks for the feedback, I shall take care of the graphics not coming before the topic...

[@vikram4755]

Ramkumar Swaminathan thanks :-)

[@subhankardutta3093]

Can I delete my temp.dbf file?

[@vishalmisri4722]

Sir pls, share the video for types of oracle user .

[@RamkumarSwaminathan]

Ok, shall cover under security

[@pranavdeshmukh9987]

please do share database creation manually video

[@RamkumarSwaminathan]

+pranav deshmukh sure shall do that too

[@sarfarazkhankhan2674]

Why your video not working at all

[@NishantTaletiya]

veer narmad south gujarat university

[@aishwaryv8]

Sir please don't use background music,it simply distracts and make it difficult to understand the concepts.

[@roysocanalyst9172]

Lower the annoying background music