HomeНаука и техникаRelated VideosMore From: Ramkumar Swaminathan

Connection Pool with an Oracle Database - DBArch Video 19

55 ratings | 6261 views
In this video you will learn the concept of a Connection pool an application uses with a Database. You will learn the need for connection pool and how it helps in optimizing resource utilzation on the Database Server. You will learn that Logon and Logoff are the most resource intensive tasks in a database, and hence both tasks should be avoided during normal operations of the application and database. 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 (18)
Julias Sam (9 days ago)
I prefer making the connection with the Oracle database with the help of ADO.NET data provider https://www.devart.com/dotconnect/oracle/. Has anyone tested out other vendors?
Ramkumar Swaminathan (8 days ago)
Even if you use ADO.NET... there will be options to configure connection specifications... Kindly take care of that...
siva kumar ayachitula (18 days ago)
hi sir, first of all i need to thank you for sharing your experience and knowledge to us... my question is what will be the conection architecture of a oracle database which have both think clients and applications...will it be having dedicated server process for applications and a pool of shared server processes for think clients seperatly? Also can you give examples for think clients in real time.
Ramkumar Swaminathan (8 days ago)
Yeah its possible to have both... in such circumstances you will configure dedicated connections for connection pool and MultiThreaded sessions ( Shared Servers) for thick clients...
m .v kishore (4 months ago)
Hi Sir, I have a doubt We need pfile/spfile to start db. We need control file as well to start db. Pfile has all the parameters mentioned while control file has db physical details. So what is the difference between both? Y can't we maintain a single file.? This question arises as pfile has db name and unique name. Whereas control file also has db name.
srinivasarao boddu (2 months ago)
Sir practiceal videos I need installation Linux in oracle
m .v kishore (4 months ago)
Ramkumar Swaminathan thank you so much for the wonderful explanation 😊
Ramkumar Swaminathan (4 months ago)
Control file is a binary file whereas pfile is a text file. you can create a pfile even if you lose one, but control file is maintained by the server. Pfile is for instance to start and come to nomount state... after that the control file is read and instance gets to mount state and then the data files and redo log files are opened by the instance and the instance is open for users to work with their data.
Sourabh Verma (5 months ago)
great video , Thanks a lot
Padala Sundeep (8 months ago)
How do the application verify the users? Even for verification it needs to check the credentials in DB I hope. Or else does it verify users by using these 10connection pools? Confused..!!
Ramkumar Swaminathan (8 months ago)
Most Welcome... Enjoy Learning...
Padala Sundeep (8 months ago)
Ramkumar Swaminathan Perfect Explanation..!! Thanks for your time.
Ramkumar Swaminathan (8 months ago)
Hi Padala, very good question. When all application users connect to the application and get authenticated as application users maintained by the application( for which the application will have its own authentication mechanism), the DB User for all application users happens to be the same. Thus the database is unaware of who is the real user. Thats the problem with Connection pool... To overcome this.. you have solutions like maintaining a CLIENT_ID or APPLICATION_CONTEXT which are attributes of a database connection. Thus when an application uses one of the connections in the pool to perform an operation for an Application user say USER1, The application should append this information to the DB Connection attribute... thereby the database can be aware of the real application user. Which can be used to audit or other operations in the database where the real users should be known to the Database. Another way to identify the application user in the Database is by using Proxy connections... Hope this helps..
Nazir Hussain (11 months ago)
Sir, very nice explanation, do you have any training lessons on JBOSS SERVER.
Ramkumar Swaminathan (11 months ago)
+Nazir Hussain not from me... Boy shall keep you posted if I find any good channel on jboss
Sain Singh (11 months ago)
nicely explained , like the way it is explained!!!
Ramkumar Swaminathan (11 months ago)
+Sain Singh thanks
tirupati Y (1 year ago)
Thanks you Sir..Nice

Would you like to comment?

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