HomeОбразованиеRelated VideosMore From: Ramkumar Swaminathan

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

145 ratings | 12967 views
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 https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Html code for embedding videos on your blog
Text Comments (26)
Imtiaz Basha (3 months ago)
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
Ramkumar Swaminathan (3 months ago)
U1 and u3 will get error in the transactions... u2 may get a snapshot too old if read consistency cannot be met...
Pavan Rh (7 months ago)
thank you sir..very brief and precise....keep going with more concepts on DB...
Ramkumar Swaminathan (6 months ago)
Thanks ... Enjoy learning
Bayu Setiawan (8 months ago)
amazing video.
Ramkumar Swaminathan (7 months ago)
Thanks
MOHAMMED WAHID (9 months ago)
very good and simple explanation
vikram nagalikar (9 months ago)
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 :)
vikram nagalikar (9 months ago)
Ramkumar Swaminathan thanks :-)
Ramkumar Swaminathan (9 months ago)
Thanks for the feedback, I shall take care of the graphics not coming before the topic...
vikram mehta (9 months ago)
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
Ramkumar Swaminathan (9 months ago)
Thanks, enjoy learning.. there is a playlist on tuning... But not yet complete
vishal misri (10 months ago)
Sir pls, share the video for types of oracle user .
Ramkumar Swaminathan (10 months ago)
Ok, shall cover under security
latha rupert (1 year ago)
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?
Ramkumar Swaminathan (1 year ago)
The contents column of dba_tablespaces will reveal the type of tablespace.... https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_4157.htm#REFRN23287
Sunanda Reddy (1 year ago)
excellenttttttt sir,
Pushpjeet Cholkar (1 year ago)
You are one of the best teacher to explain oracle database and teaches very well about any of the concept cristal clear. Thanks for the videos.
Ramkumar Swaminathan (1 year ago)
+Pushpjeet Cholkar thanks
pranav deshmukh (1 year ago)
please do share database creation manually video
Ramkumar Swaminathan (1 year ago)
+pranav deshmukh sure shall do that too
pranav deshmukh (1 year ago)
best explainer.. thank you
Ramkumar Swaminathan (1 year ago)
+pranav deshmukh thanks
tirupati Y (1 year ago)
Excellent sir, thank you
tirupati Y (1 year ago)
Yes Sir, I am learning many things from you. Thank you very much your help
Ramkumar Swaminathan (1 year ago)
+tirupati Y thanks... Hope you are liking the videos too... And hitting the like button

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.