|
53 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: Tue, 17 August 2021 00:17 «»
By: Michel Cadot
Re: SYSAUX IMPACT ON PERFORMANCE
2nd option; 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: Tue, 15 June 2021 14:05 «»
By: Michel Cadot
Re: Help improve SQL Query
For any performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
Also, if you want to continue to get help you should envisage to feedback in your topics.
|
9 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 07 October 2020 00:25 «»
By: Michel Cadot
Re: Improve efficiency of script
For any performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
|
10 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 31 December 2019 00:38 «»
By: Michel Cadot
Re: WITH Clause VS INLINE View Execution
…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 can i make an item large
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/206304/
|
12 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 04 December 2019 02:13 «»
By: Michel Cadot
Re: delete from table where one of the column is nested table is running long.
…question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
How many rows in nested table?
What is the average number of rows in the nested table for each row in the main table…
|
13 |
Forum: Reports & Discoverer «»
Posted on: Mon, 28 January 2019 02:30 «»
By: checks
Re: Arabic Language not show in oracle reports 11G
…le.com/cd/E14571_01/bi.1111/b32121/pbr_font003.htm#i1009745
https://support.oracle.com/knowledge/Middleware/2091306_1.html
https://it.toolbox.com/question/arabic-font-issue-with-pdf-report-121913
http://www.araboug.org/ib/index.php?showtopic=21965…
|
14 |
Forum: Programming Interfaces «»
Posted on: Sat, 27 May 2017 03:52 «»
By: kaos.tissue
Re: Displaying Information based on entered value in PHP with Oracle Database 11g R2
…
1 <!DOCTYPE HTML>
2 <html>
3 <body> Details of:<?php echo htmlentities($_POST["cust_phone"])."<br>";
4
5 $link = oci_connect('hd', 'hd', 'localhost/mydb');
6 if(!$link)
7…
|
15 |
Forum: Programming Interfaces «»
Posted on: Sat, 27 May 2017 02:59 «»
By: kaos.tissue
Re: Displaying Information based on entered value in PHP with Oracle Database 11g R2
…the same thing as I posted in the question
( ! ) Notice: Undefined index: ID in
E:\xampp\htdocs\myfiles\options.php on line 24
Call Stack
# Time Memory Function Location
1 0.0013 137104 {main}( ) ...\options.…
|
16 |
Forum: Server Administration «»
Posted on: Mon, 24 March 2014 05:05 «»
By: d_seng
Re: Confusion about nologging
Dear all, please see this excellent post: http://www.dbi-services.com/index.php/blog/entry/the-consequences-of-nologging-in-oracle.
This clarified everything for me and the results suggest the way forward.
|
17 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 25 March 2013 09:01 «»
By: BlackSwan
Re: Export to Excel Files
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
|
18 |
Forum: Marketplace «»
Posted on: Wed, 29 August 2012 23:26 «»
By: NOADF
Re: New Vision Application Development FrameWork (NOADF)
New Videos Uploaded :
http://www.nvoadf.com/index.php/noadf-features
|
19 |
Forum: Spatial «»
Posted on: Fri, 24 August 2012 07:44 «»
By: gis-man
Re: create SDO_ORDINATE_ARRAY from number array
…
I'm still getting "expression of wrong type" when I use it as follows.
The C1 array is a bound array created in PHP.
Can you tell me what "dual" refers too ?
Thanks again
Steve Smith
CREATE OR REPLACE PACKAGE …
|
20 |
Forum: Networking and Gateways «»
Posted on: Mon, 30 July 2012 05:03 «»
By: Michel Cadot
Re: Steps for Access remote Oracle Db [VB-Oracle-10G]
… on the subject:
http://it.toolbox.com/wiki/index.php/Connect_Oracle_Behind_a_Firewall
http://www.dbasupport.com/forums/archive/index.php/t-19188.html
http://dbaspot.com/database-discussions/54900-connecting-oracle-through-firewall.html
Regards
…
|
21 |
Forum: Forms «»
Posted on: Thu, 23 February 2012 15:03 «»
By: mughals_king
Re: how can i send SMS through oracle 10g - Forms/report(6i)
….22User
Guide:
http://wiki.gnokii.org/index.php/User%27s_Guide* Nokia Mobile
Phone With Data Cable - http://www.gnokii.org/cables.shtml Try to Send SMS Using the Command.Anzish$ echo "This is a test SMS using gnokii-Linux..." | gnokii…
|
22 |
Forum: Windows «»
Posted on: Thu, 30 June 2011 07:17 «»
By: Michel Cadot
Re: Data from Oracle to Microsoft Word
… will help you:
http://dbaforums.org/oracle/index.php?showtopic=2071 with http://www.carlprothman.net/Default.aspx?tabid=81
http://www.pcreview.co.uk/forums/do-connect-oracle-database-t2881161.html with http://www.connectionstrings.com/oracle and http…
|
23 |
Forum: Replication «»
Posted on: Mon, 17 January 2011 10:07 «»
By: sovekconsulting
Re: Is ODI the right technology for me to use?
hello, please review and consider our database replication product for your needs
http://www.sovek-consulting.com/index.php/products/data-replication
Let me know if you any need additional information.
Regards,
SK
|
24 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 20 October 2010 09:19 «»
By: tejas.patel
how to remove space
query string in such like that
index.php?name=tejaspatel
i have table in record is available below
select * from emp where name = :name // it is query string parameter
emp
name
tejas patel
then how to match this record ?
|
25 |
Forum: Enterprise Manager «»
Posted on: Wed, 10 February 2010 07:38 «»
By: ramoradba
Re: Backup Settings Cause Error
Here is an answer fo rthis Kind of problem...
Hope your OS is Windows.
http://dbaforums.org/oracle/index.php?showtopic=5687.
Please post your OS,And oracle version with 4 digits.And check your permissions.
Good luck
sriram
|
26 |
Forum: Programming Interfaces «»
Posted on: Mon, 01 February 2010 02:03 «»
By: gens
Re: How to create Oracle database using Php code?
Please take a look at http://dbaforums.org/oracle/index.php?showtopic=19196
Do you believe that he just try to trick me into buying his recommended book?
|
27 |
Forum: Performance Tuning «»
Posted on: Sun, 31 January 2010 01:24 «»
By: ramoradba
Re: Heap size exceeds warning notification in alert.log
i found the above at http://onlineappsdba.com/index.php/2008/03/10/errors-in-alert-log-file-of-10201-instances/
sriram
|
28 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 30 October 2009 02:07 «»
By: Its_me_ved
Re: MERGE statment in oracle pl/sql
…
SQL> DECLARE
2
3 TYPE aat_id IS TABLE OF source_table.object_id%TYPE
4 INDEX BY PLS_INTEGER;
5 TYPE aat_name IS TABLE OF source_table.object_name%TYPE
6 INDEX BY PLS_INTEGER;
7 TYPE aat_type IS TABLE OF …
|
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: WebCenter Suite & Portal «»
Posted on: Wed, 23 September 2009 15:52 «»
By: atul_iiit
Re: Institutes For Oracle Webcenter Suite
…Oracle University.
If you are loooking from DBA/Administration point of view then check here http://onlineappsdba.com/index.php/2009/09/14/oracle-webcenter-suite-11g-fmw-installation-overview/
Atul Kumar
Oracle ACE
http://onlineAppsDBA.com…
|
31 |
Forum: Linux «»
Posted on: Fri, 19 June 2009 14:49 «»
By: gansvv
Re: Error in invoking target 'ntcontab.o' of makefile $ORACLE_HOME/network/lib/ins_net_client.mk
…
I did come across these discussions though:
http://forums.oracle.com/forums/thread.jspa?threadID=577066&start=0&tstart=0
http://ubuntuforums.org/archive/index.php/t-592064.html
Is there a standard solution for this lagtsh (32-bit) problem…
|
32 |
Forum: Replication «»
Posted on: Tue, 16 December 2008 20:02 «»
By: darren_tao
Re: ORA-06502 in DBMS_RECTIFIER_DIFF.DIFFERENCES
…trace file. i don't know why.
some one tells me that it is a bug, but have not provide more detail information.
please see
http://dbaforums.org/oracle/index.php?s=af6a25b1f89eaa680d95883145748e96&showtopic=17064&st=0&#entry46870…
|
33 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 08 September 2008 03:26 «»
By: rajatratewal
Re: Reg dropping Queue tables ORA-24005:
http://www.dbasupport.com/forums/archive/index.php/t-39345.html
Check This Out.
It May Help
Regards,
Rajat
|
34 |
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…
|
35 |
Forum: Community Hangout «»
Posted on: Sat, 12 July 2008 14:59 «»
By: BlackSwan
The Good Life in Southern California
…of my house & with my 1 meter telescope I can see the folks on the beach.
http://www.camzone.com/index.php?cam=delmar
This real time camera is at the main Del Mar Life Guard station;
which is about 1 mile south of the bocce ball tournament…
|
36 |
Forum: Marketplace «»
Posted on: Wed, 16 January 2008 22:07 «»
By: kasarla2004
Oracle Apps DBA issues
…acle.com/conflicts/
http://www.trutek.com/index.php?id=22---Apps
====================================
-------------------------------------
http://www.trutek.com/index.php?id=75---Apps
http://sabdarsyed.blogspot.com/2007/08/dear-friends-…
|
37 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 03 January 2008 16:22 «»
By: michrony
ORA-06502: PL/SQL: numeric or value error: host bind array too small
…following package works fine inside Oracle, calling demohash.test is OK. But when it is called from php, there is an error:
ORA-06502: PL/SQL: numeric or value error: host bind array too small
Actually, when the element of associative array Result is …
|
38 |
Forum: Server Administration «»
Posted on: Thu, 06 December 2007 12:28 «»
By: ThomasG
Re: 9i installation error
…here :
http://www.dbforums.com/archive/index.php/t-1308827.html
Maybe it is worth a shot to try to install the 9.X Version with the 10.X installer already installed ob the system.
Otherwise, de-install everything with the 10.X Installer, clean …
|
39 |
Forum: Forms «»
Posted on: Fri, 16 November 2007 00:21 «»
By: djmartin
Re: FRM-41810 Menu Error when Menu Security 'YES'
What is the name of your menu? Did you compile and generate it? What is the text of the error message?
Have a look at http://www.dbasupport.com/forums/archive/index.php/t-11753.html
David
|
40 |
Forum: Marketplace «»
Posted on: Wed, 26 September 2007 17:59 «»
By: sanka_yanka
New Oracle Forum Created.
Hi All,
A new oracle forum launched.
All members are invited to discuss on this forum http://forum.oracle.googlepages.com/ or http://www.punbb-hosting.com/forums/oracle/index.php in parrallel with Orafaq forum.
Everyone welcome!!
|