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

[@StrategicThinkersHQ]

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

[@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

[@vedashwi]

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

[@pavanhr1]

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

[@RamkumarSwaminathan]

Thanks ... Enjoy learning

[@uzzalbasak2517]

Thanks, Sir, for Realy easy and wonderful Explanation!

[@abhishekkashyap4511]

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

[@mohammedwahid2316]

very good and simple explanation

[@manzoor5554]

Very good job..DONE....

[@rahulmittal116]

Useful information sir !

[@hariskeelan9940]

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

[@sujaa1000]

Many many thanks to you Regards, Sujaa

[@pranavdeshmukh9987]

best explainer.. thank you

[@RamkumarSwaminathan]

+pranav deshmukh thanks

[@gianlucarusso8475]

wonderful videos

[@sunandareddy5126]

excellenttttttt sir,

[@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

[@balajichandramohan5117]

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

[@SuperBES49]

amazing video.

[@RamkumarSwaminathan]

Thanks

[@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

[@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 :-)

[@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 ?

[@subhankardutta3093]

Can I delete my temp.dbf file?

[@pranavdeshmukh9987]

please do share database creation manually video

[@RamkumarSwaminathan]

+pranav deshmukh sure shall do that too

[@vishalmisri4722]

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

[@RamkumarSwaminathan]

Ok, shall cover under security

[@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.

[@ncrcottonbalesseeds118]

Guru ji know pulse of a students

[@roysocanalyst9172]

Lower the annoying background music