| |
49 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: Tue, 01 December 2020 00:14 «»
By: Michel Cadot
Re: Need help to rewrite the query
… any performances question, 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…
|
| 9 |
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…
|
| 10 |
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).
|
| 11 |
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 …
|
| 12 |
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
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 29 September 2010 02:44 «»
By: pointers
forall - collection of records
…Hi,
I have been doing some code in collection for testing.
I have been doing the below but getting the error. I am not sure where i am wrong. can you please tell me what is wrong.
SQL> desc t_mine;
Name…
|
| 14 |
Forum: Programming Interfaces «»
Posted on: Mon, 12 July 2010 05:38 «»
By: phplebanon
Cannot Connect to Oracle, PHP cannot load oci dlls
…oci_connect() in C:\wamp\www\project2\index.php on line 3
Also when I start wamp, it cannot load the oci dlls found on:
C:\wamp\bin\php\php5.3.0\ext
I have configured the php.ini file and commented as much options
extension_dir = "C:/wamp/bin…
|
| 15 |
Forum: Replication «»
Posted on: Thu, 10 June 2010 15:10 «»
By: sovekconsulting
Re: Doubt in Replicating Data from DB to another
please try our database replication product -
www.sovek-consulting.com/index.php/products/data-replication
|
| 16 |
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…
|
| 17 |
Forum: Marketplace «»
Posted on: Wed, 09 June 2010 15:22 «»
By: sovekconsulting
data replication between Oracle and non-Oracle databases
…to target database
- Data transformation -
if required, data can be transformed during replication as per defined rules.
- Statistics for captured, parsed and applied changes.
www.sovek-consulting.com/index.php/products/data-replication…
|
| 18 |
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…
|
| 19 |
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
|
| 20 |
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 …
|
| 21 |
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' …
|
| 22 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 23 July 2009 11:41 «»
By: cnvegnix
A question about eliminate duplicates rows from a table
…Cadot.
Url:
www.orafaq.com/wiki/index.php?title=SQL_FAQ&direction=next&oldid=11698#How_does_one_eliminate_duplicates_rows_from_a_table.3F
Diffiences between revisions:
www.orafaq.com/wiki/index.php?title=SQL_FAQ&diff=11699&oldid=…
|
| 23 |
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…
|
| 24 |
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
|
| 25 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Sat, 21 March 2009 16:48 «»
By: PHILLIP@EASYAPEX.COM
Re: Easy way for Upgrade Application Express to Version 3.0.1 or 3.2 in OraXE.
Another good article can be found
here: http://www.easyapex.com/index.php?p=103
|
| 26 |
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…
|
| 27 |
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
|
| 28 |
Forum: Text & interMedia «»
Posted on: Wed, 17 September 2008 21:12 «»
By: jimsang
SOS,SOS,Search,Search,SOS
…will to be a madman.........help...........help me(~!~)...........
create a table: T_SHOP
create some columns: S_ID, S_NAME, S_HOST, S_ADDRESS, S_INTRO
fill the table with some data:
1, 'wine bar', 'jim', 'New York Road', '<i>wine bar</i>…
|
| 29 |
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
|
| 30 |
Forum: Forms «»
Posted on: Mon, 01 September 2008 01:57 «»
By: djmartin
Re: Changing Color of a push button when mouse over
…White 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…
|
| 31 |
Forum: Marketplace «»
Posted on: Mon, 04 August 2008 01:21 «»
By: Sathish_R
Cost Effective Online Oracle Apps Training
…Training:
http://oraappsforum.com/index.php?option=com_mojo&Itemid=58&page_id=21
Oracle Apps Project Accounting Training:
http://oraappsforum.com/index.php?option=com_mojo&Itemid=58&page_id=22
Oracle Pl/Sql Performance Tuning:(…
|
| 32 |
Forum: Unix «»
Posted on: Thu, 17 July 2008 07:26 «»
By: mruravner
Re: Table storing Oracle Home
sorry Michel for not mentioning the source, but i got it from
http://tonguc.oracleturk.org/index.php/2006/09/21/how-to-get-oracle_home-from-sql-or-plsql/
|
| 33 |
Forum: Forms «»
Posted on: Wed, 18 June 2008 22:03 «»
By: wency
Re: Select multiple items in LOV ?
I think you can not do that.
http://www.dbasupport.com/forums/archive/index.php/t-9539.html
http://www.rampant-books.com/t_easy_html_db_multiple_select_lists.htm
|
| 34 |
Forum: Marketplace «»
Posted on: Thu, 29 May 2008 14:03 «»
By: hoonv
Feedback wanted
Hi All,
I have started a software company. Can you please provide your feedback and inputs at this link:
http://74.220.215.219/~coderwor/survey/index.php?sid=71699&newtest=Y
Thanks for your time.
Regards,
Hoonv
|
| 35 |
Forum: Forms «»
Posted on: Sun, 11 May 2008 20:14 «»
By: wency
Re: calculate
here's some links from simple search.
http://www.dbasupport.com/forums/archive/index.php/t-8520.html
http://www.geekinterview.com/question_details/3606
do some programming to solve the problem.
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 03 April 2008 17:41 «»
By: Barbara Boehmer
Re: ORA-00933 when trying out returning clause
…;Single-set aggregates cannot be used with an INSERT statement." In the second link, one of the authors provides some explanation.
http://www.rampant-books.com/book_2003_2_oracle10g.htm
http://dba.ipbhost.com/lofiversion/index.php/t1031.html…
|
| 37 |
Forum: Programming Interfaces «»
Posted on: Thu, 08 November 2007 04:02 «»
By: amcghie
Passing Tables from PHP to PLSQL
…all,
I have an existing database application that requires a "simple" front-end (are these things ever simple?). There is an existing API written which I would like to reuse if possible. Here is a snippet of the API:
TYPE property IS …
|
| 38 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Thu, 04 October 2007 15:44 «»
By: atul_iiit
Re: Oracle Apps Technical Intervew Questions
…DBA Interview Questions and answers
Check
http://onlineappsdba.com/index.php/category/interviewqs/
http://teachMeOracle.com/interview.html
and if you are looking for any Interview question answer Update it here and I'll try to respond…
|
| 39 |
Forum: Server Administration «»
Posted on: Mon, 23 July 2007 09:31 «»
By: DreamzZ
Re: ORA-00600: internal error code, arguments: [16305], [], [], [], [], [], [], []
http://dba.ipbhost.com/lofiversion/index.php/t806.html
|
| 40 |
Forum: Weblogic & Application Server «»
Posted on: Fri, 29 June 2007 17:07 «»
By: DreamzZ
Re: Oracle installation prerequest error message
http://www.orafaq.com/forum/t/84410/105911/
http://forums.suselinuxsupport.de/index.php?showtopic=7445&mode=linear
|
Blog
Search
Help
Members
Register
Login
Home