Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does the Oracle database on Windows work? How do I tune the Oracle database on Windows?

April 26, 2017oracle database tune Windows

0

Posted

How does the Oracle database on Windows work? How do I tune the Oracle database on Windows?

1 Answer

0

Posted

The Oracle RDBMS on Windows web site describes how the Oracle database operates on Windows, as well as provides tips on performance tuning. Q: I use C#, Visual Basic, Active Server Pages, Visual C++, or another Windows-specific programming language. How does Oracle provide data access? A: Oracle offers a variety of data access methods for COM-based, .NET-based, and Win32/64-based programming languages. Oracle developers can use any one of the following data access drivers based on the Windows programming language employed: • .NET: Oracle Data Provider for .NET, OLE DB.NET via Oracle Provider for OLE DB, ODBC.NET via Oracle ODBC Driver • COM: Oracle Objects for OLE (OO4O), Oracle Provider for OLE DB via Microsoft’s ActiveX Data Objects (ADO) • PL/SQL and Java (server-side programming) to COM Automation servers (e.g. Microsoft Office): COM Automation Feature • Win32/64: ODBC Driver, Oracle Call Interface (OCI), Oracle Provider for OLE DB These data access drivers have been engineered to