• Oracle Lock Query

    Is it possible to determine who is locking (not blocking) a row in an Oracle database? This relates to a problem I have with a COBOL program that needs to determine who is locking a requested record. I can determine the rowid of the requested record (after Oracle has informed the program that the...

    RichardReynolds5 pointsBadges:
  • How to begin tracing a connection Oracle 10.2.0.3 server running on Solaris 10

    Developers are telling me a page loads more slowly on one server than another for the same query that is run. how can I trace this connection to find out what it is doing on both servers?

    Szdb25 pointsBadges:
  • Error calling APPS.AR_ADJUST_PUB.Create_Adjustment

    Calling this API from SQL Navigator and working on a Release 12 implementation. This is the error message: ORG ID is required. I'm setting all this in the begining, but still I get the message. apps.fnd_global.apps_initialize(1154, 20678, 222); APPS.ARP_GLOBAL.INIT_GLOBAL; FND_MSG_PUB.Initialize;...

    Mirandai5 pointsBadges:
  • 10g/10app server Forms not running on Dell machine.

    We have custom web forms that have a fit running on Dell Optiplex gx520 and 620 machines. After updating the jvm.dll so jinit 1.3.1.22 will run on IE7, Dell Optiplex gx520 and 620 machines begin to run the app but then a message reading something like "The instruction at memory location XXXXXXXX...

    Sparky850045 pointsBadges:
  • Wait event LNS wait for LGWR redo ?

    I have a PROD database 10gR2 with a physical standby database. In the TOP ten waits in AWR REPORT, there is the event"LNS wait for LGWR redo" which represents 25% of waits. Is there a relationship with standby or with only redo log ? This event is not documented .

    Nanard5 pointsBadges:
  • forms and arcgis

    can any one tell me please. I want to access Arcgis Map on my oracle 6i forms & reports is it possible.

    Alghassan5 pointsBadges:
  • AIM

    What is the literal for AIM?

    SKKelly5 pointsBadges:
  • Error:1327 during installing orcale 10g

    I downloaded 10g express edition and tried to install to windows xp. An error 1327:Invalid Driver:E\ prompted. There is no E drive at all. Not sure what is going on? Anyone could help?

    Canaantt5 pointsBadges:
  • Join clause vs. nonequi join

    pls help, can using clause is simmilar to non equi join,if yes how is it

    Muktioracle50 pointsBadges:
  • Report taking long time before opening

    Hi All We are running Oracla based ERP solution. 9i , D2K and JVM. Everyday after 6 PM all the reports are taking long time before opening I am using HP Proliant DL 380 G5 server with 2 GB RAM having 2 partitions . C mirrored 2 x 72 GB SAS HDD. D drive with 4 SAS 72 GB HDD RAID 5. Wetried changing...

    Vksumanlal5 pointsBadges:
  • Inserting without duplicating

    I need to create a row and to ensure that the row I'm creating does not already exist. I'm doing this in a pl/sql program.

    Marlin325 pointsBadges:
  • Nonequi join and self join as inner join

    pls Help, can we call non-equi join and self join as inner join ,if yes pls give some resion

    Muktioracle50 pointsBadges:
  • RMAN Script

    can anybody provide me script for RMAN backup on HP-UX with option backup on DISK and backup on TAPE too? If possible also tell how to take copy of disk backup on tape by using 'BACKUP BACKUPSET'.

    Parag5 pointsBadges:
  • job problem

    i create a job for updating table and make auto drop after that , the problem that when i create this job, one time it's created and one time not , in regular way , and this is the procedure. begin dbms_scheduler.create_job( job_name => 'DropIp_test', job_type => 'plsql_block', job_action...

    Abdo5 pointsBadges:
  • error in reunnig sql plus

    when runnig sql plus of oracle 9i,after giving puser id and password protocol adapter error is there..iused both id an pw i.e. system and manager or scott/tiger

    Krshah5 pointsBadges:
  • what is the diff between cursor and plsql table

    what is the diff between cursor and plsql table

    Saritha55 pointsBadges:
  • Oracle Database’ Optimization Criteria

    Hi ALL, I want to know - - What are the Criteria upon which one can say that Oracle Database is Designed, Set Up and is Running Optimally ? - Beside BRTOOLS ( in SAP on Oracle Db), is there any other Tool through which we can Validate the Oracle Database Structure ? ( Any Specific Parameters to...

    Eklavya5 pointsBadges:
  • ORA-27101 error when migrating Oracle 9i to AD domain

    We are running Oracle 9 on a Windows 2003 box. We moved the server from a Windows domain to an AD domain. We then get an error messages looking like this: ORACLE not available ORA-27101 When we back out of the changes, everything works fine again. Any ideas? Thank you.

    OracleATE190 pointsBadges:
  • Oracle export causes DBMS_EXPORT_EXTENSION error

    I am facing a problem with the EXP command. The execution starts normally, but during the execution about midway, the command gives the error: dbms_export_Extension must be declared. After that, only the structure of the tables goes to backup and no data! This issue never happened in my 3-4 years...

    OracleATE190 pointsBadges:
  • Developer 10g

    I want to connect my forms and reports of developer 10g to other data sources. e.g. Sql Server. How can i connect to it through odbc?

    Kelp115 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following