| |
41 Search Results Found |
| 1 |
Forum: Performance Tuning «»
Posted on: Sun, 31 December 2023 02:46 «»
By: Michel Cadot
Re: query output speed very slow
…question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
You can also read:
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL Wiki page…
|
| 2 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 27 April 2023 15:01 «»
By: Michel Cadot
Re: How can I speed this query up?
For any SQL performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
|
| 3 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 07 March 2023 15:17 «»
By: Michel Cadot
Re: Identify Groups where 2 or more Clients have bought the same Products - SQL Oracle
A priori, the slowest part will be "equal_sets".
You can post the execution plan as explained at http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888.
|
| 4 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 10 January 2023 15:27 «»
By: Michel Cadot
Re: SQL very slow
…post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.
For any SQL performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information…
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 01 December 2022 08:07 «»
By: Michel Cadot
Re: Performance issue with Update statement having select Statement
…post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.
For any performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information…
|
| 6 |
Forum: Performance Tuning «»
Posted on: Fri, 29 July 2022 00:25 «»
By: Michel Cadot
Re: any option for this query
…ion, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.
And FEEDBACK in your…
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 06 January 2022 10:15 «»
By: Michel Cadot
Re: Query Performance
…ion, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
For what you have posted, I could say activate the parallelism (if you can), partition the table (if you are licensed for), buy …
|
| 8 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 25 May 2021 10:39 «»
By: Michel Cadot
Re: Nested Queries with Select Statement
Please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
|
| 9 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 30 December 2019 06:52 «»
By: Bill B
Re: Pan card insert time validation (3 merged)
This entry is answered in
http://www.orafaq.com/forum/index.php/t/187935/
|
| 10 |
Forum: Programming Interfaces «»
Posted on: Fri, 26 May 2017 08:01 «»
By: kaos.tissue
Displaying Information based on entered value in PHP with Oracle Database 11g R2
…have a simple form (main.php) which takes input as a Phone no. of the customer:
<!DOCTYPE HTML>
<html>
<div style=margin:0 auto align=center >
<form action = "options.php" method = "get"…
|
| 11 |
Forum: Server Administration «»
Posted on: Thu, 28 August 2014 14:17 «»
By: dstolf
Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c
…is a though one, with many variables, so bear with me.
I have created two databases using Oracle dNFS clone. The backup image is stored on ASM and both clones are stored on NFS and use the same backup image. It's a plain simple single instance …
|
| 12 |
Forum: Reports & Discoverer «»
Posted on: Sat, 07 June 2014 07:26 «»
By: mazhar.ehsan
Re: Arabic Language not show in oracle reports 11G
…from the site http://www.araboug.org/ib/index.php?showtopic=48493
yet did not succeed in generating the correct PDF file.
Surprisingly, I get the below error from the report server with the 'unifont.uni' downloaded from your site
REP-1924: …
|
| 13 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Wed, 19 March 2014 10:49 «»
By: mamunbb
How can I configure Virtual host for mod_plsql in Oracle HTTP Server
…
I have configured virtual host in apache httpd.conf and it works fine. Configuration is as follows
My PC has 2 IP configured.
in web browser with link http://192.168.100.93:7778/index.html shows website 1
and with link http://192.…
|
| 14 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 June 2013 15:16 «»
By: Buchas
Disable RedoLog for a single user?
…like all operations on all tables of a SINGLE user not to generate arhive redo logs.
I see this was not possible six years ago:
http://dbaforums.org/oracle/lofiversion/index.php?t6523.html
Did the Oracle got smarter? Is it possible to do this now…
|
| 15 |
Forum: Server Utilities «»
Posted on: Wed, 06 March 2013 13:30 «»
By: BlackSwan
Re: Import million data from excel to Oracle 11g
http://www.orafaq.com/wiki/index.php?title=Special%3ASearch&search=excel&go=Go
|
| 16 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 29 August 2012 10:51 «»
By: BlackSwan
Re: connecting from oracle to excel to copy the results in the cell value.
Please read and follow the forum guidelines, to enable us to help you:
http://www.orafaq.com/forum/t/88153/0/
http://www.orafaq.com/wiki/index.php?title=Special%3ASearch&search=excel&go=Go
|
| 17 |
Forum: Server Administration «»
Posted on: Sun, 18 March 2012 03:17 «»
By: janakors
Re: too many archive log generation
…is an oracle bug
and many redo files generated
follow this link for detail,
http://www.dbi-services.com/index.php/blog/entry/compression-advisor-excessive-redo-log-file-generation
hope someone have the same issue so might be helpful
Regards…
|
| 18 |
Forum: Server Administration «»
Posted on: Sun, 31 July 2011 06:48 «»
By: John Watson
Re: use_large_pages parameter and AMM
… side
http://www.solarisinternals.com/wiki/index.php/Multiple_Page_Size_Support
and this from the DB side
http://developers.sun.com/solaris/docs/solaris-sparc-061110.pdf
They are largely pre-Solaris 2.10 and pre-T3 architecture, but they suggest that…
|
| 19 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 29 September 2010 03:02 «»
By: pointers
Re: forall - collection of records
…
Hey Micheal,
I read the whole article before posting here.
Actually i was doing like below,
SQL> ed
Wrote file afiedt.buf
1 declare
2 v_start_time PLS_INTEGER := DBMS_UTILITY.GET_TIME;
3 v_elapsed PLS_INTEGER…
|
| 20 |
Forum: Windows «»
Posted on: Sun, 10 January 2010 23:43 «»
By: ramoradba
Re: %1 is not a valid win32 application
i agree with Blackswan...we dont know what happend at your side right?
HOpe these will help you...
http://www.dba-oracle.com/t_windows_installer_failure.htm
http://dbaforums.org/oracle/index.php?showtopic=19126
sriram
|
| 21 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Sun, 20 December 2009 21:31 «»
By: ramoradba
Re: ApEx trigger
…out-working-for-a-company-that-innovates-at-such-an-incredible-pace-is-that-you-ar e-constantly-tasked-wit.html
http://wiki.developerforce.com/index.php/Round_Robin_Lead_Assignment_Trigger
Hope the above helpful:)
Good luck
Sriram…
|
| 22 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Fri, 04 September 2009 08:07 «»
By: atul_iiit
Re: EBS startup
…Files , location of logs here
http://onlineappsdba.com/index.php/2009/07/23/adoacorectlsh-adformsctlsh-adoafmctlsh-exiting-with-status-204/
http://onlineappsdba.com/index.php/2009/07/21/adapcctlsh-exiting-with-status-150-204-apache-logs-in-r12…
|
| 23 |
Forum: Forms «»
Posted on: Thu, 30 July 2009 00:40 «»
By: djmartin
Re: Reading data from Serial port: Exception 305500 Un-handled
…can read Thai) in http://wiriya.com/board/index.php?action=recent;start=10
There is also code at http://forums.oracle.com/forums/thread.jspa?threadID=232458 and http://www.narisa.com/forums/index.php?showtopic=27193&bcsi_scan_80CA22F9AD71C623=…
|
| 24 |
Forum: Server Administration «»
Posted on: Mon, 30 March 2009 13:26 «»
By: Orna
10.1.0.4 listener spawns a child listener and DB is hung
…10. but no followup
http://dbaforums.org/oracle/index.php?showtopic=991
http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/spawns-new-rogue-listener-with-same-name-as-original-644065
Thanks in advance for any explanation
…
|
| 25 |
Forum: Text & interMedia «»
Posted on: Wed, 18 March 2009 06:32 «»
By: ramoradba
Re: ORA-00904: "CONTAINS": invalid identifier
i think this article will help you.....http://dbaforums.org/oracle/index.php?showtopic=6519&pid=23419&mode=threaded&start=#entry23419
|
| 26 |
Forum: Forms «»
Posted on: Mon, 01 September 2008 02:17 «»
By: djmartin
Re: when-mouse-Leave trigger in 10g R2
…Paper, April 2002" at http://www.oracle.com/technology/products/forms/pdf/forms9icstowebmigration.pdf
I googled 'when-mouse-enter java' and found http://www.araboug.org/ib/lofiversion/index.php/t27010.html
I hope this helps you.
David…
|
| 27 |
Forum: Forms «»
Posted on: Tue, 06 May 2008 19:04 «»
By: djmartin
Re: Can't paste OS clipboard into Web ORACLE FORM
…67.html Look at the three 'Follow-Ups' and especially the link in the first one to https://bugs.eclipse.org/bugs/show_bug.cgi?id=70077
http://forums.spywareinfo.com/lofiversion/index.php/t85281.html looks like a better bet to fix this problem.
…
|
| 28 |
Forum: Linux «»
Posted on: Tue, 12 February 2008 12:05 «»
By: aoli
Oracle 10g wants swap coould i ovveride it?
…/openvz.org/).
In http://forum.openvz.org/index.php?t=msg&goto=420& topic somebody told, that "Swap is a non problem, it just complains about it but it does not matter." but i really confused. It doesn't want to install.
Have …
|
| 29 |
Forum: Server Administration «»
Posted on: Fri, 25 January 2008 01:18 «»
By: durgadas.menon
Re: Error
Version - 10.2.0.1.0.
Here are the url's
http://forums.oracle.com/forums/thread.jspa?threadID=368529
http://dba.ipbhost.com/lofiversion/index.php/t4606.html
Thanks
- Das
|
| 30 |
Forum: Backup & Recovery «»
Posted on: Thu, 05 April 2007 07:26 «»
By: Mohammad Taj
Re: How set the one home(oracle8i) on windows.
Hi,
Go through below link
http://www.dbforums.com/archive/index.php/t-995254.html
Try to understand your problem... it above link doesn't help...
please provide more information.
Regards
Taj
|
| 31 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Thu, 08 March 2007 12:55 «»
By: prashant_pathak
Re: Interview question
…settlement
http://wiki.ittoolbox.com/index.php/HOWTO:Period-End_Processing_in_Oracle_Payables_%28Release_11i%29
debit memo/credit memo
Uses for invoices in a payment batch to calculate the payment total for your payment and determin on which …
|
| 32 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 14 February 2007 04:28 «»
By: webappdev
passing in nested (multi-dimensional) varray to procedure?
…all,
In my web app I have a large grid of unknown dimensions, the values of which I want to pass into a stored procedure to loop through and merge into a table.
What I want to do is (very much simplified) this:
create or replace TYPE triples IS …
|
| 33 |
Forum: Server Administration «»
Posted on: Wed, 17 January 2007 22:43 «»
By: Mohammad Taj
Re: Export and Import
… DENI 0 rows exported
Export terminated successfully without warnings.
IMP-00058:ORACLE error 904 encountered
Possibly table defination changed.
http://www.dbasupport.com/forums/archive/index.php/t-34251.html
regards
…
|
| 34 |
Forum: Networking and Gateways «»
Posted on: Thu, 07 December 2006 00:48 «»
By: seema.taunk
Re: oracle spawns new listener (Oracle 10GR2)
Hi,
Check this link.
Exactly same problem as yours
http://dba.ipbhost.com/index.php?showtopic=991
|
| 35 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 26 October 2006 03:52 «»
By: tahpush
Re: Tablenames by SQL-Syntax
check out
http://www.techonthenet.com/oracle/sys_tables/index.php
|
| 36 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Sat, 30 September 2006 19:03 «»
By: anilpassi
Re: Oracle workflow training material
…on Workflow.
http://oracle.anilpassi.com/index.php?option=com_search&Itemid=5&searchword=Workflow+training&submit=Search&searchphr ase=exact&ordering=oldest
Alternately, you may decide to visit for Oracle Workflow training …
|
| 37 |
Forum: Training & Certification «»
Posted on: Sat, 30 September 2006 19:02 «»
By: anilpassi
Re: work flow training program in chennai - regarding
…Workflow.
http://oracle.anilpassi.com/index.php?option=com_search&Itemid=5&searchword=Workflow+training&submit=Search&searchphr ase=exact&ordering=oldest
Alternately, you may decide to visit
http://appstechnical.blogspot.com…
|
| 38 |
Forum: Server Administration «»
Posted on: Wed, 06 September 2006 22:00 «»
By: wwllzpz
Re: can't install 8i in Windows Server2003
plesase refer to the following link
http://dbforums.com/archive/index.php/t-329918.html
|
| 39 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Tue, 22 August 2006 05:22 «»
By: gnsblr
Re: TE 040 - Financials
Please refer to http://www.oracleappsblog.com/index.php/forum/viewthread/93/
for financials test scripts. Regards.
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 26 July 2005 08:05 «»
By: Mahesh Rajendran
Re: Need ur help..
…Since, I googled and got these, so can you.
http://www.unix.org.ua/orelly/oracle/prog2/ch20_04.htm
http://www.devarticles.com/index2.php?option=content&task=view&id=589&pop=1&page=0&hide_js=1
Please dont use coloring formats etc…
|
Blog
Search
Help
Members
Register
Login
Home