Very Informative.. Your examples are very clear and to the point. Please upload some videos related to performance tuning for the oracle interview question segment. Thanks
Nice video sir..pls make a video on local and global index when we create partition table on that time We create local Andrew global index...so pls make a video to describe more about same.
Thanks for the explanation, I have one question though regarding the locking of rows. If we try to fire update on same table from two different sessions without commit/rollback Oracle will not allow anyways, so is it not a universal behavior ?
Welcome, I am not sure, however I guess the locking should be more similar in others databases also, may be the names might differ, but underlying concepts might be the same
What if we try to read the data from other session..? I got it that we can't do dml operations until the commit/rollback done but cant we also retrieve the data using select statement from other session.. Could you please show this as well if that's possible. Thanks!
Pls clear my question: why are clustered indexes not used in Oracle or is there any clustered index concept in Oracle? Is it only used for Ms SQL server?
Number of comparisons within Index segment are same in Table then, what's the advantage? @our example finding rows of P's is similar to finding rows of 1's.
Senario 1 :--one database 2 schema each schema has one table each . Senario 2 :--2 db 2 schema one in each db one table each Write query to retrieve data from both tables in both senario???
@Ash Tyson, Senario 1 - You can give grant to select data from one schema to another schema, and you can access both the table in the second schema and join them or use set operator to retrieve data from both tables. Senario 2 - You can create a DB link between both the database, so that using DBLink, you can access the data of table of one database into another database.Then you can retrieve data from both tables using join or set operator.
Simply great learning from Siva Academy
Great explanation about the locking mechanism for the tables having BitMap index.
Really excellent tutorials sir...
U r explaing very Interestingly...
Thanks for your comment Krishna :-)
Your explanation is awesome .... I became fidaa on pl sql with your outstanding explanation . Doing a great job .
Glad to hear that
Very Informative.. Your examples are very clear and to the point. Please upload some videos related to performance tuning for the oracle interview question segment. Thanks
Thank you again for this perfectly explained video.
Glad it was helpful!
great explanation need information for join methods
Thanks so much ...Cannot think of better explanation
You are most welcome
Awesome !! we really appreciate your effort..
It's my pleasure
Nice video sir..pls make a video on local and global index when we create partition table on that time We create local Andrew global index...so pls make a video to describe more about same.
Sure Shashank,
I will do a video on local and global index soon. Thanks for your comment.
Thanks for the explanation, I have one question though regarding the locking of rows.
If we try to fire update on same table from two different sessions without commit/rollback Oracle will not allow anyways, so is it not a universal behavior ?
Welcome, I am not sure, however I guess the locking should be more similar in others databases also, may be the names might differ, but underlying concepts might be the same
Oracle allows updating a table from different sessions, provided records effected are different in each session.
Hi
I like your videos. Very help full
Thank you
thank you for the valuable explanation
You are welcome!
sir will u give any project coaching or real time project explanation??
you have explained very well, Could you please make a video on BITMAP JOIN index.
please stay tuned
What if we try to read the data from other session..? I got it that we can't do dml operations until the commit/rollback done but cant we also retrieve the data using select statement from other session.. Could you please show this as well if that's possible. Thanks!
Wonderful Explanation Sir
Welcome 🙏
Best explanation 👌👌👌
Thank you
How it will work if multiple indexes overlap for same column.
Pls clear my question: why are clustered indexes not used in Oracle or is there any clustered index concept in Oracle? Is it only used for Ms SQL server?
No clustered index concept in oracle
Hi @Siva very nice video
Can you please explain cluster index and non cluster index with examples
@Amarjeet, Sure Bro, please stay tuned, will post this concept
❤❤❤❤❤❤
Number of comparisons within Index segment are same in Table then, what's the advantage?
@our example finding rows of P's is similar to finding rows of 1's.
BITMAP index is compressed data, and its effective along with bitmap join index too, will post with an example, please stay tuned.
@5:06 , Could you please elaborate the 3rd point of bit map join … please
Thank u Sir... Can u plz tell how can we see the explain plan for a particular table.....
@Abhinav, sure, will post in as part of performance tuning vedio series, please stay tuned.
Hi siva,
Please make a video series on partitioning
Sure bro, please stay tuned
An interviwer asked Explain about oracle architecutre
please stay tuned
thanks sir...
@Karnaraj...Thanks bro :-)
hi sir can you send interview quations and answer.
how this index would speed up the retrieval ?
@Bharath, Please look into this video
ruclips.net/video/m0z73p_kMr8/видео.html
How to use pragma serially reausable in package
pls explain the internal use
@dinesh, I will mostly post this pragma this week itself, please stay tuned
Senario 1 :--one database 2 schema each schema has one table each .
Senario 2 :--2 db 2 schema one in each db one table each
Write query to retrieve data from both tables in both senario???
@Ash Tyson,
Senario 1 - You can give grant to select data from one schema to another schema, and you can access both the table in the second schema and join them or use set operator to retrieve data from both tables.
Senario 2 - You can create a DB link between both the database, so that using DBLink, you can access the data of table of one database into another database.Then you can retrieve data from both tables using join or set operator.
@@SivaAcademy thank you
Bro thanks to u because of your video I have got job ..heartly thanks to u 😀😀
@Ash Tyson, Its my pleasure... best wishes & all the best... you can always reach back to me for SQL/PLSQL questions.....Thanks,Siva