WebApr 16, 2012 · When the number of users exceed 300, oracle forms become very slow (we wait 1 minute for login form). Oracle aplication server :10.1.2.3.0 Oracle forms 10g. Thank you. Regards Salim. Welcome! It looks like you're new here. Sign in or register to get started. Log In Register Best Answer WebJan 13, 2024 · The article is intended for users of the Oracle10g and Oracle11g database who use the Export Data Pump utility to export data from an Oracle source database and the Import Data Pump utility to import into an Oracle target database. This document is only applicable to the new clients Export Data Pump (expdp) and Import Data Pump (impdp) …
Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
WebMay 9, 2011 · Export/Import performance issue Hi TOm,I have been following your blog since 3 months. This is the first time i got a chance to ask you a question.What are the steps to speed up the export and import process.What is the difference between importing into Database in noarchive log mode and importing after setting _disab WebFeb 23, 2024 · oracle database version = Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi. Forms are Loading/opening Very Slowly in 10g Forms while opening window 7 bit machine , but same form are opening very fast in window xp machine in internet explore . Please gives me any suggestion for performance issue . Report … in bed sick
Improve BLOB Writing Performance in Oracle 11g - Database ...
WebDec 3, 2009 · Apart from actually running the query and counting how many records come back, the only way I can think of is to use Oracle's optimiser stats - i.e. look at the cardinality on the top-level of the explain plan - but I'd only expect them to be somewhat representative to an order of magnitude and I can't see that being a reasonable alternative for any use … WebProperly configured, Oracle 10g should always faster than earlier releases, both for PL/SQL and SQL, so it is likely that any slow performance after an Oracle 10g upgrade is due to initialization parameter settings or incomplete CBO statistics. Oracle 10g Optimizer Issues http://dba-oracle.com/t_top_reasons_poor_performance.htm inbyggnadscistern wc