Oracle 10g IMP - After Tables Are Loaded Procedure Appears To Hang?
Oct 14, 2011
I have an Oracle IMP that seems to complete, but there are two things that I don't understand:
1) The tables seem to load successfully in about 4 hours. After the tables are loaded, the IMP procedure appears to hang for10+ hours. I can query the tables at this time, so I'm not sure what it's doing. Is it maybe applying constraints?Is it normal for applying constraints to take 3-4X as long as importing the data?
2) I see a few of these messages in the alert log during the import.Thread 1 cannot allocate new log, sequence 2754 I don't see errors in the IMP log so are these messages informational or warnings, or will there be something wrong with my imported data?
View 1 Replies
ADVERTISEMENT
Mar 18, 2011
How to hide oracle in-built message which appears at the bottom of the window(just above the task-bar) to the left side.
View 2 Replies
View Related
Apr 29, 2012
all of the client cann't connect the db,and using sqlplus / as sysdba also cann't login there are many error of TNS-12535 and in the listener.log
alert.log:
Sun Apr 29 18:10:36 2012
opidcl aborting process unknown ospid (42992060) as a result of ORA-604
Sun Apr 29 18:10:54 2012
opidcl aborting process unknown ospid (26280196) as a result of ORA-604
[code]...
View 5 Replies
View Related
Nov 11, 2012
I am trying to determine the number of times a value appears and display the count. However the value can only be counted once per 'trip' even though it may appear several times per trip.
for e.g.
Quote:trip table
-------
trip_id start_date end_date duration
445 01-jan-12 03-jan-12 3
Quote:pickup table
--------
pickup_id trip_id company
1 445 randomname
2 445 randomname
3 445 google.inc
4 878 randomname
with the above data the expected value would be two because the trip id appears twice so it was just the one trip - given a count of one. I am not sure how create a query to check this.
View 2 Replies
View Related
Mar 28, 2013
SELECT * from TABLE_1 where a=b;
Is it possible to make the SELECT (PL/SQL is OK ) wait/block in case there are no rows found until another session inserts rows that match the condition?
Something like this
cursor c is select * from TABLE_1 where a=b order by column_a for update skip locked;
row c%rowtype;
begin
open c;
[Code].....
Or the INSERTing session should send some kind of notification (semaphore?) to the reading session?
View 29 Replies
View Related
Sep 14, 2011
problem is: Our HFM application is running very slow, but we don't know where the bottleneck is. I would like to prove that the DB is not the one causing the issue.
solution: Show AWR metrics that indicate that utilization of the DB
I've been reading thru a lot of articles in the net (Oracle sites and others), but I cannot find a clear AWR baseline that will tell me if my database is heavily loaded. how much of my DB capacity am I using in a said time period. The different OEM graphs show: During non-peak: DB is relatively Idle Peak time: the graph suggest we are just using 30-40% of max capacity. This is when a dataload into the DB happens
So, is my DB loaded if my AWR Load Profile stats are:
CODELoad Profile Per Second Per Transaction Per Exec Per Call
~~~~~~~~~~~~ --------------- --------------- ---------- ----------
DB Time(s): 1.0 0.3 0.00 0.00
DB CPU(s): 0.8 0.3 0.00 0.00
Redo size: 408,893.4 125,411.1
Logical reads: 5,606.3 1,719.5
Block changes: 2,119.2 650.0
Physical reads: 455.9 139.8
Physical writes: 83.0 25.5
User calls: 469.4 144.0
Parses: 82.4 25.3
Hard parses: 44.5 13.7
W/A MB processed: 2,383,203.7 730,949.0
Logons: 0.2 0.1
Executes: 345.9 106.1
Rollbacks: 0.0 0.0
Transactions: 3.3
CODETop 5 Timed Foreground Events
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Avg
wait % DB
Event Waits Time(s) (ms) time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
DB CPU 8,687 79.5
db file sequential read 1,699,159 1,539 1 14.1 User I/O
log file sync 35,518 170 5 1.6 Commit
direct path read 418,577 165 0 1.5 User I/O
enq: TX - index contention 8,136 121 15 1.1 Concurrenc
Host CPU (CPUs: 64 Cores: 8 Sockets: 1)
~~~~~~~~ Load Average
Begin End %User %System %WIO %Idle
--------- --------- --------- --------- --------- ---------
1.03 1.29 1.7 0.5 0.0 97.8
Server Stats show CPU is 975 idle
Snap TimeLoad%busy%user%sys%idle%iowait
04-Aug 12:00:591.45
04-Aug 13:00:051.003.082.550.530.0096.92
04-Aug 14:00:111.291.951.460.490.0098.05
View 2 Replies
View Related
Jan 5, 2011
i'm facing a problem when i run form om forms 11g
that error appears :
frm-10142 HTTP listener not running on weblogic on port 80
and when i ran it on weblogic server after compiling it on internet explorer a blank window appear and written DONE
View 1 Replies
View Related
Jan 22, 2013
I am working on Oracle apps. I have developed a custom screen. On the screen, if the user press 'F4' on final step, it will ask the dialogue..Do You want to save changes?
Yes No Cancel.
Even the user press the "Yes" , I want to check my own validation and commit when my validation get perfect.
View 1 Replies
View Related
Jul 19, 2011
I have a table emp_up, daily this table is uploaded by a SQL *LOADER(with REPLACE option) script run by a UNIX JOB.There is no particular timestamp column in this table. Is it possible to know when/AT what time the table is uploaded.
View 2 Replies
View Related
Feb 8, 2012
When I transfer the data from Oracle to MS SQL I have one column in a table which is of Arabic Language.The data is fine in Oracle but when I transfer it to MS SQL Server I see that the text in MS SQL server appears as junk.
View 1 Replies
View Related
May 1, 2013
I select the data from sql server column type nvarchar2 and load into varchar2 but data once loaded looks very different and can't be read.
let say name column in sqlser values is 'Rajesh' then in oracle it looks like series of square shape.
View 1 Replies
View Related
Oct 18, 2013
How can i get the partition name which was recently loaded. When my load start it truncate the partition and load the data.once the data is loaded there is another load which will read from earlier loaded partition table. i want to know on the fly which partition was loaded recently.
View 10 Replies
View Related
Jul 24, 2013
Apex 4.2.0.00.27Firefox 22.0, IE 8 Just started using the Enkitec Navbar, and we have noticed that when a page is rendered a vertical list always appears momentarily before being replaced with the Navbar list. It happens on all applications we have installed it on, and every time a page is refreshed.
View 13 Replies
View Related
Jun 21, 2012
Version 10.2.0.4
CREATE TABLE T1 (I INT PRIMARY KEY);
CREATE TABLE T2 (I INT PRIMARY KEY, J INT);
ALTER TABLE T2 ADD CONSTRAINT T2_FK FOREIGN KEY (J) REFERENCES T1(I);Session 1
INSERT INTO T1 VALUES (1);Session 2
INSERT INTO T2 VALUES (1,1);Session 2 hangs. Why ?
View 9 Replies
View Related
Mar 8, 2013
I got Scenario that, i need to insert the number of records loaded in target table into the log table.
But the resultset is handled in the in the cursor. how to get the number of records the cursor handles.
/* Formatted on 08/03/2013 15:00:44 (QP5 v5.149.1003.31008) */
CREATE OR REPLACE PROCEDURE DASHBOARD75.SP_STG_MLY_GL_HKP_V1_00
AS
CURSOR GL_HKP
IS
SELECT CAL.MTH_NM,
CAL.YEAR,
GLM.BU_CD,
[code].......
View 7 Replies
View Related
Dec 6, 2012
My requirement is as below,
I have one main form and there is one button when i click on it, another form should be opened which should display multi records with check box for each record.
I have implemented so far. When the new form is opened by default all the records should be checked. if user does not want some of them then it can be unchecked(This can done manually)..
I have put below code in when-new-block instance trigger
set_item_property('LOCKBOX_DETAILS.CB_SUBMIT', ENABLED, PROPERTY_TRUE);
Unable to load the block with all the records checkboxes checked.
View 4 Replies
View Related
Jan 14, 2009
when i run my form im immediately im geting geting this error message
oracle.forms.webutil.file.FileFunctions bean not found.CLIENT_TEXT_IO.fopen will not work
when i searched in meta link i found a solution but not know ing how to implement it..
Symptoms When running a customized Webutil Form an error similar with the following is displayed:
oracle.forms.webutil.file.FileFunctions bean not found. CLIENT_TEXT_IO.fopen will not work.
The exact function that "will not work" may change in the error message depending on the WebUtil code used. There are no errors displayed in the Java Console. The original WebUtil Demo Form runs successfully. Cause The WebUtil code that is failing is placed in triggers that are firing before Forms instantiates the WebUtil PJCs.
This is not allowed when using WebUtil and it is explained in the WebUtil User Guide release 1.0.6, section 5.3: "Once the WebUtil library has been attached to your form you can start to add calls to the various PL/SQL APIs defined by the utility. However, there is an important restriction in the use of WebUtil functions: WebUtil can only start to communicate with the client once the Form has instantiated the WebUtil PJCs. This means that you cannot call WebUtil functions before the Forms user interface is rendered.
This would include triggers such as PRE-FORM, WHEN-NEW-FORM-INSTANCE and WHEN-NEW-BLOCK-INSTANCE for the first block in the Form." SolutionDo not use Webutil code in triggers like PRE-FORM, WHEN-NEW-FORM-INSTANCE and WHEN-NEW-BLOCK-INSTANCE because these triggers are firing before Forms instantiates the WebUtil PJCs Instead, you can test the WebUtil functionality with a WHEN-BUTTON-PRESSED trigger and you can use it in your application in other allowed locations.
View 5 Replies
View Related
Sep 7, 2012
I am loading content of an XML file into a table using SQL loader.Below is my Control file script -
LOAD DATA
INFILE *
INTO TABLE xx_cc_response_xml_stg TRUNCATE
xmltype(XML_DATA)
FIELDS
( COLUMN_ID constant 1,
file_name filler char(4000),
XML_DATA LOBFILE(file_name) TERMINATED BY EOF)
BEGINDATA
B2B_MasterDataUpdate_20120906152137.xml
------------------------------------------------------------------------------------
The file B2B_MasterDataUpdate_20120906152137.xml is correct and XML is well formed.When i try to query for XML_DATA (datatype XMLType) column in the table, i cannot see any content in the record, and it appears as (XMLTYPE)When I parse this XML using the below,
select value(d)
from xxnbn_cc_response_xml_stg a,
table(xmlsequence(extract(a.xml_data,'/InventorySearch'))) d;
------------------------------------------------------------------------------------
I get this error:
------------------------------------------------------------------------------------
ORA-00600: internal error code, arguments: [qmcxdsSelf4], [], [], [], [], [], [], [], [], [], [], []
00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
*Cause: This is the generic internal error number for Oracle program
exceptions. This indicates that a process has encountered an
exceptional condition.
*Action: Report as a bug - the first argument is the internal error number
------------------------------------------------------------------------------------
View 1 Replies
View Related
Nov 23, 2012
Is it possible to create local temp variable based table within sql procedures, i am planning on writing few select queies,and want to store teh result of each select to a temp variable based table.
Within sql serevr, i can create temp tables within and then later after i use teh data at teh end drop the table.
Is it possible, since i don't want to create any physical tables.
View 1 Replies
View Related
Apr 29, 2013
i have 2 tables in two different sources.
I have loaded data from source to destination.
some rows are missed while loading.
i want to know the missing rows
View 11 Replies
View Related
Jun 26, 2013
here' my code.
delimiter //
SELECT CONNECTION_ID()//
LOCK TABLES source.jos_daikin_control_card_fcu_model WRITE//
[Code].....
ERROR 1192 (HY000): Can't execute the given command because you have active lock
ed tables or an active transaction
Is there a way to prevent other session from accessing the tables called in the procedure?
View 3 Replies
View Related
Nov 7, 2011
how to write this query using procedure and how it can display.
SELECT iusr_id,
so_curr_assign_to,
comp_id,
[Code]....
View 11 Replies
View Related
Feb 22, 2012
I want to create a stored procedure where tables of two different databases are to be used.
View 4 Replies
View Related
Sep 3, 2012
I came across an implementation where data from DB2 tables are moved to Oracle tables, for BI solutioning, using some oracle procedures called from MS SQL DTS packages which are scheduled jobs.Just being curious, can this be done using OWB or ODI rather than the above detour. I suppose there are some changes being done in those procedures before the data is being loaded into Oracle tables, can't this be done using OWB/ODI? Can it be scheduled too as jobs using OWB/ODI?
View 1 Replies
View Related
Jun 23, 2011
I'm facing a problem with the starting of java programs on my Win XP system. The startup most often takes from 5 to 60min. Only in rare cases java programs start-up normally. I've these problems with Eclipse, Nitro and ProM which are all Java-based tools.
I have used STraceNT to find the cause of my problems but I couldn't figure it out. I've attached the STraceNT log file for the execution of ProM. The program runs until the last line in the log while starting without showing up anything. After 20min suddenly the programs shows up and works as it normally does. The last line in the log where the software hangs for this long time is a call to WaitForeSingleObject. Before that it seams to allocate memory. I could see similar patterns in the executions of the other java programs, but I still can't see where the problem lies. I also tried removing the JRE and install different versions.
View -1 Replies
View Related
Apr 9, 2011
I'm writing a Procedure which Updates or Inserts data in Multiple tables. Selected fields of 10 tables need to be updated or Inserted. For this I created a table which comprises of fields related to all 10 tables. Then I write Procedure. Under this I create a Cursor which uploads the data from the newly created table which contains different fields of 10 tables. Then I write Update and Insert statements one by one for all 10 tables.
Sample Procedure below.
-------------------------------------------
Create or replace procedure p_proc as
spidm spriden.spriden_pidm%type;
cursor mycur is select * from mytable;
begin
for rec in mycur
[code]......
----------
Note: I created table on my server because data is coming from different server. They will upload the data in the table from there I pick and update the tables. Is updating or Inserting data in different tables one by one is correct?
View 15 Replies
View Related
Nov 30, 2012
create a procedure so that I could get minus query of 2 table as a result.
I have two table 1- src_table_list ,2- tgt_table_list both tables have 2 columns : serial_no,table_name and 100 records each. and details mentioned in column "table_name" are actually tables name which present in my testing database.
so I need one procedure which will pick one table_name from src_table_list and one table_name from tgt_table_name each time recursively and provide minus query as a result. as below.
select c1,c2,c3,c4 from table1 --(fetched from src_table_list)
minus
select b1,b2,b3,b4 from table2 --(fetched from tgt_table_list)
create the procedure..as I have to prepare minus query for more than 200 tables and then I need to test them for integration testing..
View 11 Replies
View Related
Aug 29, 2013
May any one confirm that the below issue is not only to RAC but also on normal database enterprize edition 11.2.0.3 ? Bug 12865902 - NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") in RAC (Doc ID 12865902.8)
currently i am using for update nowait concurrently for 50 processes on similar table with similar query and getting performance issue.
SELECT txn_ID,status_FLAG
INTO txn_id,status_flag
FROM cp_txn_detail WHERE txn_ID = pi_txn_ID FOR UPDATE NOWAIT;
View 2 Replies
View Related
Sep 29, 2011
I recompile a package in a session,and found the session is hang, I know there are have others session run the package,how can i find what session run by the package?
View 2 Replies
View Related
Aug 5, 2011
when i modify a column of table tb_hxl_user,just as flowing:
Alter Table TB_HXL_USER Modify CREATE_DATE Not Null
now i select the table TB_HXL_USER,just as flowing:
select * from TB_HXL_USER;
it is hang,and i found the wait event is library cache lock in v$session_waits,why?how can i avoid this.
View 8 Replies
View Related
