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
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 :)
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?
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
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
2 hour of class lecture but nothing understand and this 10mint video give all the knowledge in a very easy way Thanks sir
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
Thanks, enjoy learning.. there is a playlist on tuning... But not yet complete
wow..... am really thank full to you... great way of explanation....
Your training beats Oracle's. This is how good you are.
Thanks, Sir, for Realy easy and wonderful Explanation!
thank you sir..very brief and precise....keep going with more concepts on DB...
Thanks ... Enjoy learning
Ultimate personlatiy!! I am big fan of you Sir..
Best explanation i have ever seen .
Thank you so much !
Hi sir,
Good one. Which tablespaces are created at the time of database creation.
very good and simple explanation
Useful information sir !
Very good job..DONE....
Many many thanks to you
Regards,
Sujaa
wonderful videos
best explainer.. thank you
+pranav deshmukh thanks
excellenttttttt sir,
Excellent sir, thank you
+tirupati Y thanks... Hope you are liking the videos too... And hitting the like button
Yes Sir, I am learning many things from you. Thank you very much your help
amazing video.
Thanks
Hi Sir, Great Explanation! Just curious to know what kind of performance metrics are stored in the AUX Tablespace. Thanks,Suraj
.
ll,
.
L
Hvv hv
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 :)
Thanks for the feedback, I shall take care of the graphics not coming before the topic...
Ramkumar Swaminathan thanks :-)
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?
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
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
U1 and u3 will get error in the transactions... u2 may get a snapshot too old if read consistency cannot be met...
What is snapshot sir ?
Can I delete my temp.dbf file?
Sir pls, share the video for types of oracle user .
Ok, shall cover under security
please do share database creation manually video
+pranav deshmukh sure shall do that too
veer narmad south gujarat university
Why your video not working at all
Sir please don't use background music,it simply distracts and make it difficult to understand the concepts.
Guru ji know pulse of a students
Lower the annoying background music