473,725 Members | 2,168 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

It's urgent (Oracle running slow)

20 New Member
I m working on a application importing data into oracle.But after few import into Oracle DB my import process is taking so long time.My oracle is getting slow after running import few times.Can somebody suggest me some performance tips.


Thanks And Regards
Dinesh
Apr 2 '08 #1
2 3528
amitpatel66
2,367 Recognized Expert Top Contributor
I m working on a application importing data into oracle.But after few import into Oracle DB my import process is taking so long time.My oracle is getting slow after running import few times.Can somebody suggest me some performance tips.


Thanks And Regards
Dinesh
What are you trying to exactly import? the whole schema or some tables of a particular schema?
Apr 2 '08 #2
dineshchand
20 New Member
What are you trying to exactly import? the whole schema or some tables of a particular schema?
I m importing data in in something around 50 tables in my database.And row insert that are executed in a single import are in lakhs.THis is my import scenario .When i load data in these tables in clean database performance is OK.but for the 2nd time around when i delete all my tables in which i m importing data and then start new import ,my performance dips down .what could be the reason ??
Apr 2 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
4016
by: mwang | last post by:
We just upgraded JDBC Thin driver from 9.0.1 to 9.2.0.3. After the upgrade we found the applications ran significantly slower. Our test showed the same app running up to 5 times slower with the new driver than with the previous driver. The database server is Oracle 9.2.0.1.0 E.E.. Has anyone else also experienced similar performance degradation with JDBC 9.2.0.3?
9
3003
by: AnandaSim | last post by:
Hi All, I've had Access 97, 2000 connections to the corporate Oracle database for a few years now - but seldom use it. When I did use it years ago, performance was not fast but the features were good enough. Now, the version of Access is 2003 with Office SP1 applied, Windows XP against Oracle 9.2. And attached tables are real slow - 5 mins to get to datasheet view and data is incorrect - the same row is repeated several times even in...
0
2140
ekekakos
by: ekekakos | last post by:
Hello, I am having a serious and urgent problem with the character settings of an oracle database. The database is sitting in a solaris unix server and when we run the env command we have the following in the NLS_LANG parameter: AMERICAN_AMERICA.WE8ISO8859P1 (I do not know if this is helpfull). When I retrieve data from oracle database (through a VB.NET 2005 program) to a dataset I use a special font in order to see the greek characters...
0
1338
by: innovarajesh | last post by:
Hi guys, I am a technical recruiter working in USA. We are in need of Oracle CRM consultants to one of our clients in Bay Area. The Project period is 1 year. The Requirement is VERY URGENT Kindly forward your friends, if you not matches this profile Regards
3
2451
by: optionsindia | last post by:
hi partners, we are having a urgent requirement for one of our client cmmi level5 company in hyd if u intrested Kindly mail your responses to gangadhar.sadhu@optionsindia.com Project Lead - JAVA / ORACLE Job Profile Through understanding and expertise in the various phases of SDLC
1
1782
by: Imran | last post by:
JOB ID : JM 1202 >>Please refer to the Job ID in all your communication both in subject line of your email and in the body text. * Note: My new Yahoo MSGR ID < mji_imms > Hi Friends, Hope you doing good ! Urgent requirment for Oracle DBA
4
8416
by: paulnamroud | last post by:
Hi guys, I need your help!!!! I have installed and configured a new server called "intranetnew" in order to replace the old server "intranet." With the new server, i'm able to connect to Oracle and do SQL queries using the SQL-Plus. However, when i try to connect to Oracle via a test page written in ASP, the following error message appears on the screen "2147467259: ."
1
1544
by: musai | last post by:
Hi Members I have created VB/Oracle Application Application is going to use multiple client (user machine) What I want to know is whether Oracle should be installed or not. I checked two machine one is oracle has been installed and another one is not install Application is working fine in the installed machine, but not in another machine(not installed machine) what i have to do
6
3103
by: Anthony Smith | last post by:
How can I make these inserts faster? $insert = "INSERT into AFF_KIAC_ACCT_ALIGNMENT " . "(KIAC_ACCT_NBR, REGION_CD, ORIGIN_LOC_CD,TERRITORY, FISCAL_HALF, FISCAL_YEAR, MAINT_USER_ID)" . " values (:acct, :region, :origin, :territory, :half, :year, :userid)"; $stmt = $con->prepare($insert);
0
8888
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8752
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9401
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9257
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9176
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8097
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6702
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4784
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3221
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.