| |
58 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: Mon, 11 October 2021 07:37 «»
By: Michel Cadot
Re: Long query with WITH not responding
…post the CREATE TABLE statements for all the tables and related objects and, of course, the query, so we can reproduce the problem.
Please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information…
|
| 8 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 April 2020 13:48 «»
By: Michel Cadot
Re: Adding a from () to a query made it so slow
For any performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
|
| 9 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Tue, 14 January 2020 05:59 «»
By: cookiemonster
Re: Pricing - Analysis
http://orafaq.com/forum/index.php/f/26/
|
| 10 |
Forum: Performance Tuning «»
Posted on: Tue, 10 December 2019 08:58 «»
By: Michel Cadot
Re: Select query too slow
…m.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
For any performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information…
|
| 11 |
Forum: Forms «»
Posted on: Mon, 09 December 2019 04:53 «»
By: cookiemonster
Re: How to enlarge an item within a region by clicking it
So how come we've got the same question, with the same image, from the same IP, from two different users?
http://orafaq.com/forum/index.php/t/206305/
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 03 July 2017 14:13 «»
By: banach600
Re: Recursive select
…you very much for your response. Here is the version of oracle :
SQL> SELECT * FROM V$VERSION;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL …
|
| 13 |
Forum: JDeveloper, Java & XML «»
Posted on: Mon, 08 June 2015 13:55 «»
By: manubatham20
Re: Please help with XML parsing
…data here.
http://www.xmlvalidation.com/index.php?id=1&L=0&target=/xmlvalidation/start.jsp;jsessionid=BBFD8738C79E8CC8B340B8438D457FD3
WITH wnp_incoming_trx
AS (SELECT 1 id,
'<?xml version="1.0" encoding…
|
| 14 |
Forum: Forms «»
Posted on: Mon, 10 February 2014 05:37 «»
By: shahzaib_4vip@hotmail.com
Re: size of folder/directory
Maybe this will help you
http://www.bish.co.uk/forum/index.php?topic=58.0
Create a batch file and use host command
Regards
Shahzaib Ismail
|
| 15 |
Forum: Training & Certification «»
Posted on: Mon, 26 November 2012 03:45 «»
By: smois
Re: Exercises in PL/SQL
Oracle is now available at sql-ex.ru (sql-ex.ru/exercises/index.php?act=learn).
|
| 16 |
Forum: Client Tools «»
Posted on: Tue, 21 August 2012 22:37 «»
By: BlackSwan
Re: excel & oracle database
…rum/t/88153/0/
http://www.orafaq.com/wiki/index.php?title=Special%3ASearch&search=excel&go=Go
http://www.lmgtfy.com/?q=import+data+from+excel+file+to+oracle+database
Excel can log into Oracle DB using ODBC & issue SQL directly against …
|
| 17 |
Forum: Training & Certification «»
Posted on: Mon, 30 July 2012 06:22 «»
By: muralikri
Re: oracle jobs basic tutorials
Very useful.....
http://sqle.ru/index.php/Oracle_PL/SQL_Tutorial/System_Packages/DBMS_JOB
|
| 18 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 24 July 2012 09:48 «»
By: BlackSwan
Re: transfer from excel sheet to oracle
…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
https://forums.oracle.com/forums/thread.jspa?threadID=2174552#9360007…
|
| 19 |
Forum: Server Utilities «»
Posted on: Mon, 13 February 2012 01:39 «»
By: Kamran Agayev
Re: impdp takes huge time in oracle11gR2 !
As Michel has already mentioned, you need to enable trace or debug the export session. Check the following link:
http://www.dbi-services.com/index.php/blog/entry/how-to-debug-a-data-pump-error
|
| 20 |
Forum: Programming Interfaces «»
Posted on: Sun, 29 January 2012 02:46 «»
By: widiarifki
How To Update oracle data from php, by using 'Commit' ?
… well, without error. But, when I go back to index.php which showing fetching data from department table. The data which I have updated doesn't change. I think it needs 'COMMIT'. But how I use it on PHP??
Please help your Junior.
Thanks for your …
|
| 21 |
Forum: Server Administration «»
Posted on: Thu, 10 November 2011 01:13 «»
By: ramoradba
Re: Error While Starting Database
By Looking at the above post..I think he is just reading Blogs whenever he got a problem But not even try to understand it.
http://www.oraclekonsulent.dk/en/index.php?blog_id=114
Sriram
|
| 22 |
Forum: Forms «»
Posted on: Tue, 25 January 2011 06:04 «»
By: owais_baba
Re: Communication form Serial / Parallel port via Oracle Forms
…c?rev=1.22User Guide: http://wiki.gnokii.org/index.php/User%27s_Guide* Nokia Mobile Phone With Data Cable - http://www.gnokii.org/cables.shtmlTry to Send SMS Using the Command.Waseem$ echo "This is a test SMS using gnokii-Linux..." | gnokii --…
|
| 23 |
Forum: Backup & Recovery «»
Posted on: Thu, 24 June 2010 11:05 «»
By: Mahesh Rajendran
Re: How to schedule rman hot backup daily,,,
http://www.saraie.net/index.php?option=com_content&view=article&id=35:schedule-oracle-online-backup-rman-with-oem-using-rman- catalog&catid=5:recovery-manager-rman&Itemid=19
|
| 24 |
Forum: Replication «»
Posted on: Thu, 10 June 2010 15:08 «»
By: sovekconsulting
Re: Replication in 10G without DB links.
… table A will be automatically replicated and applied to table B to meet your requirements.
No DB links, no any other modifications within your source schema (no triggers).
www.sovek-consulting.com/index.php/products/data-replication
Regards…
|
| 25 |
Forum: Forms «»
Posted on: Sun, 18 April 2010 19:22 «»
By: Only-Oracle
how to use Java instead Jinitiator
…start the listener or check your runtime preferences".
reference that I also check is this page
http://www.orafaq.com/forum/index.php/m/442273/0/
could anyone help me please to overcome this problem.
I attached a copy of formsweb.cfg…
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 07 April 2010 07:21 «»
By: ramoradba
Re: COLLECTIONS AND METHODS
here is a similar case you can refer...
http://www.orafaq.com/forum/index.php?t=rview&goto=375967&th=137407#msg_375967
sriram
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 04 April 2010 18:22 «»
By: BlackSwan
Re: Date / Time Conversion
please use SEARCH of this forum
http://www.orafaq.com/forum/index.php/m/449180/136107/?srch=sequence+nextval#msg_449180
SQL*Loader can be used but can be a challenge for novice to master
|
| 28 |
Forum: Weblogic & Application Server «»
Posted on: Tue, 12 January 2010 02:19 «»
By: ramoradba
Re: How to get Client IP from stored Procedure/Function
…help you...
http://dbaforums.org/oracle/index.php?showtopic=2764
http://www.oracle.com/technology/sample_code/products/forms/extracted/getclientinfo/readme.html
SQL> SELECT SYS_CONTEXT('USERENV', 'IP_ADDRESS') FROM dual;
select …
|
| 29 |
Forum: Backup & Recovery «»
Posted on: Mon, 28 September 2009 04:50 «»
By: Kamran Agayev
Re: rman comamnd guide
You've posted the same question in another forum
http://dbaforums.org/oracle/index.php?showtopic=18718&st=0&gopid=53829&#entry53829
I've replied you there
|
| 30 |
Forum: Training & Certification «»
Posted on: Tue, 11 August 2009 04:02 «»
By: atul_iiit
Re: switch to oracle dba or oracle apps dba
Check this on How to become Oracle Apps DBA
http://onlineappsdba.com/index.php/2006/07/29/how-2-become-oracle-apps-dba/
|
| 31 |
Forum: Forms «»
Posted on: Thu, 30 July 2009 20:23 «»
By: djmartin
Re: Reading data from Serial port: Exception 305500 Un-handled
…dID=232458 and http://www.narisa.com/forums/index.php?showtopic=27193&bcsi_scan_80CA22F9AD71C623=RRYOARToIU1eFH4Y95QEbhYAAAAqq7o/&bcsi_scan_ filename=index.php I think that you have too many 'PostOpen' commands and you are not testing 'hold' …
|
| 32 |
Forum: Linux «»
Posted on: Fri, 19 June 2009 15:31 «»
By: gansvv
The infamous "cannot find -lagtsh" problem; any standard solution?
…Severity: 1
I found some relevant discussions here:
http://forums.oracle.com/forums/thread.jspa?threadID=577066
http://ubuntuforums.org/archive/index.php/t-592064.html
Could someone help me proceed with the installation??
Thanks in advance…
|
| 33 |
Forum: Performance Tuning «»
Posted on: Wed, 20 May 2009 12:18 «»
By: bangalibor
Re: Performance degrades with big block size tablespace
…i got.
http://dbaforums.org/oracle/index.php?s=88c3135eb43f11105d87705b6541cf12&showtopic=18038
And stop browsing through the questions with your high-thought,shakespeare attitude.
Thanks for your interest what you have shown to my problem…
|
| 34 |
Forum: Forms «»
Posted on: Sun, 17 May 2009 00:42 «»
By: mustafagamiel
Re: RUN REPORT ON FORM(merged 3)
my dear
take this and
read good you will find your request
http://www.araboug.org/ib/index.php?showtopic=33645
|
| 35 |
Forum: Server Administration «»
Posted on: Tue, 06 January 2009 02:35 «»
By: ashish1986
Re: Issues with Trace
…on Versions 9.x.x.x and 10.1.x.x
Please suggest
Kind Regards
Ashish
I found this link which also gives info regarding the same.
However i couldn't make much out of it.
http://dbaforums.org/oracle/index.php?showtopic=3945
Please help…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 22 December 2008 23:43 «»
By: panyam
Re: calling procedure inside a procedure
Hi Shasking,
Check over here u will get the answer :
http://dbaforums.org/oracle/index.php?showtopic=10328
|
| 37 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 18 September 2008 17:14 «»
By: BlackSwan
Re: XML parsing function
GOOGLE is your friend but only when you use it.
http://forum.springframework.org/archive/index.php/t-25300.html
http://www-01.ibm.com/support/docview.wss?uid=swg21142469
|
| 38 |
Forum: Server Administration «»
Posted on: Mon, 15 September 2008 23:36 «»
By: BlackSwan
Re: Not able to drop tablespace
…[Archive] - dBforums Feb 10, 2004 ... [Archive] HOW TO DROP TABLESPACE if datafile is missing Oracle. ... HOW CAN I DROP TABLESPACE IF A DATAFILE IS MISSING ...
www.dbforums.com/archive/index.php/t-982598.html - 6k - Cached - Similar pages - Note this…
|
| 39 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 10 September 2008 05:45 «»
By: dwarak.k
Re: joining conditions
Are you talking about ANSI syntax? These dont use '=' sign.
http://oracledoug.com/serendipity/index.php?/archives/933-ANSI-Join-Syntax.html
|
| 40 |
Forum: Marketplace «»
Posted on: Tue, 19 August 2008 10:24 «»
By: richa87
Online Oracle Apps DBA Training commencing on 23rd August 2008
…following link:
http://onlineappsdba.com/index.php/2008/08/11/online-oracle-apps-dba-11i-training/
Please have a look at the feedbacks from our trainees given in the link below:
http://onlineappsdba.com/index.php/oracle-apps-dba-training/oracle-apps…
|
Blog
Search
Help
Members
Register
Login
Home