C# 使用OCCI 连接Oracle 数据库
最近因需要研究了一下C#向Oracle数据库中插入数据的问题，通常情况下使用微软自带的组件ADO.NET来连接并操作数据库，这也是最简便
最近因需要研究了一下C#向Oracle数据库中插入数据的问题，通常情况下使用微软自带的组件ADO.NET来连接并操作数据库，这也是最简便的方式，用法也比较简单，即在程序开头加上using System.Data.OracleClient。另外就是使用Oracle提供的ODP.net,这需要下载ODAC,并在程序中引用Oracle.DataAccess.dll。
接下来写程序测试向数据库中插入记录的速度了，首先尝试使用ADO.net。
部分代码如下：
C#程序运行在Windows Server 2008 32位上，机器为Xeon E552O * 2,2.27Ghz,共16核内存12GB。Oracle 安装在RedHat AS4U4,cpu为AMD Opterron 275 * 2 ,2.2GHz,共4核心，，内存16GB,oracle 10g。
测试结果为33秒左右，每秒插入不到700条，之后也采用了绑定变量及调用存储过程等方法，插入速度也没有多大提高。
于是想到了用ODP.net,在网上查到说ODAC的版本必须与安装的oracle对应，虽然这个要求感觉不太灵活，因为实际的使用环境可能与开发环境不一致，到时还要更换ODAC的版本，且ODAC在官网上并不是能对应上所有的Oracle版本。在网上看到使用ODP.net插入速度可以达到数万条每秒，但我多次尝试时，都在运行时出现问题，根本无法运行成功。于是便放弃了。Oracle与MS的东西兼容性不强，或者说是Oracle本身向下兼容的能力弱，真是令人抓狂。
多方查找后发现了OCI这个东西，于是想到了使用封装了OCI的OCCI,这样眼前突然一亮。之后的思路就很清淅了，先用c++做一个dll,里面的函数是对OCCI的进行一步封装，再用c#调用这个dll就可以了。下面就是实现的具体过程了。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1377
52
How to check which table space a table belongs to in Oracle
Jul 06, 2023 pm 01:31 PM
How to check which table space a table belongs to in Oracle: 1. Use the "SELECT" statement and specify the table name to find the table space to which the specified table belongs; 2. Use the database management tools provided by Oracle to check the table space to which the table belongs. Tools usually provide a graphical interface, making the operation more intuitive and convenient; 3. In SQL*Plus, you can view the table space to which the table belongs by entering the "DESCRIBEyour_table_name;" command.
How to connect to Oracle database using PDO
Jul 28, 2023 pm 12:48 PM
Overview of how to use PDO to connect to Oracle database: PDO (PHPDataObjects) is an extension library for operating databases in PHP. It provides a unified API to access multiple types of databases. In this article, we will discuss how to use PDO to connect to an Oracle database and perform some common database operations. Step: Install the Oracle database driver extension. Before using PDO to connect to the Oracle database, we need to install the corresponding Oracle
How to retrieve only one piece of duplicate data in oracle
Jul 06, 2023 am 11:45 AM
Steps for Oracle to fetch only one piece of duplicate data: 1. Use the SELECT statement combined with the GROUP BY and HAVING clauses to find duplicate data; 2. Use ROWID to delete duplicate data to ensure that accurate duplicate data records are deleted, or use "ROW_NUMBER" ()" function to delete duplicate data, which will delete all records except the first record in each set of duplicate data; 3. Use the "select count(*) from" statement to return the number of deleted records to ensure the result.
Implement data import into PHP and Oracle databases
Jul 12, 2023 pm 06:46 PM
Implementing data import into PHP and Oracle databases In web development, using PHP as a server-side scripting language can conveniently operate the database. As a common relational database management system, Oracle database has powerful data storage and processing capabilities. This article will introduce how to use PHP to import data into an Oracle database and give corresponding code examples. First, we need to ensure that PHP and Oracle database have been installed, and that PHP has been configured to
How to use php to extend PDO to connect to Oracle database
Jul 29, 2023 pm 07:21 PM
How to use PHP to extend PDO to connect to Oracle database Introduction: PHP is a very popular server-side programming language, and Oracle is a commonly used relational database management system. This article will introduce how to use PHP extension PDO (PHPDataObjects) to connect to Oracle database. 1. Install the PDO_OCI extension. To connect to the Oracle database, you first need to install the PDO_OCI extension. Here are the steps to install the PDO_OCI extension: Make sure
How to use PHP and Oracle database connection pools efficiently
Jul 12, 2023 am 10:07 AM
How to efficiently use connection pooling in PHP and Oracle databases Introduction: When developing PHP applications, using a database is an essential part. When interacting with Oracle databases, the use of connection pools is crucial to improving application performance and efficiency. This article will introduce how to use Oracle database connection pool efficiently in PHP and provide corresponding code examples. 1. The concept and advantages of connection pooling Connection pooling is a technology for managing database connections. It creates a batch of connections in advance and maintains a
Does oracle database require jdk?
Jun 05, 2023 pm 05:06 PM
The oracle database requires jdk. The reasons are: 1. When using specific software or functions, other software or libraries included in the JDK are required; 2. Java JDK needs to be installed to run Java programs in the Oracle database; 3. JDK provides Develop and compile Java application functions; 4. Meet Oracle's requirements for Java functions to help implement and implement specific functions.
How to query table space size in oracle
Jul 06, 2023 pm 01:45 PM
Steps to query the table space size in Oracle: 1. Log in to the Oracle database using a database administrator account; 2. Use the "SELECT" statement to view the space list; 3. There are three methods to query the table space size: use the dbms_utility package to query, and use the dba_segments view Query, use the dba_data_files view query; 4. Use the "DBMS_OUTPUT.PUT_LINE" function or other methods to display the results to display the query results.
