ORA-1092 / Opitsk Aborting Process

Jul 11, 2011

Getting read to open SR on Metalink..

11.2.0.2 db startup getting this error.

ORA-1092 : opitsk aborting process

4 other databases using same Oracle Home started just fine.. Running on AIX 5.3, Someone failed cluster over by "accident" ... Anyway.. All file systems exists, other db's started fine.Can't even get a sysdba connection..

oramerch@a3dvdb954:/oramerch/app/oracle/diag/rdbms/tsadev/tsadev/trace$ echo $ORACLE_SID
tsadev
oramerch@a3dvdb954:/oramerch/app/oracle/diag/rdbms/tsadev/tsadev/trace$ echo $ORACLE_HOME
/oramerch/app/oracle/product/11.2.0.2/db_1/CPUApr2011
oramerch@a3dvdb954:/oramerch/app/oracle/diag/rdbms/tsadev/tsadev/trace$ sqlplus /nolog
[code]...

View 1 Replies


ADVERTISEMENT

SQL & PL/SQL :: How To Get Which ORACLE Process Get More CPU

Apr 23, 2012

I want to know that the below 28249 PID running in which oracle process ., Because it consumes consuming 100% CPU load.

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29249 oracle 25 0 1217m 48m 48m R 100.0 1.3 18364:47 oracle

View 1 Replies View Related

Process Using With Data

Mar 13, 2010

Need to use same query to decode and then use data based on the lower between clause to show

WITH DATA AS (select tb.address_id,DECODE(tb.month,
'1', '01',
'2', '02',
'3', '03',
'4', '04',
'5', '05',
'6', '06',

[Code]...

Output should come from the inner query only where between condition works..

so we should see only those addressids for 10-2009 to 11-2009.

View 1 Replies View Related

What Is Slave Process

Jan 19, 2013

What is slave process? why we use slave process? when it is used?

View 5 Replies View Related

List All Process Description?

Feb 9, 2012

are there a table/view that lists all process with description like the DICT does for the data dictionary views?

I wanna know for example the description of J001 or Q001 process for example.

View 3 Replies View Related

Process Queries Parallel?

Feb 2, 2005

On a tab page should be displayed the result of four indifferent queries, each based on a stored procedure.At the moment, the queries are processed serially, by the statements:

GO_BLOCK('one');
CLEAR_BLOCK(No_Validate);
EXECUTE_QUERY;
GO_BLOCK('two');
CLEAR_BLOCK(No_Validate);
EXECUTE_QUERY;

Is there a way to processes the queries parallel ?

View 1 Replies View Related

SQL & PL/SQL :: Stop Loop On One Process?

Jul 3, 2010

i want check some data from one process instead of last record

i.e

process data
uuu 1
2
3
4
ppp 1
2
3
4

[code].....

View 2 Replies View Related

Finding Correct DB Process?

Feb 7, 2013

1. I have 6 data bases, one process is running slowly, how do you find which data base that process belongs to?

2. I have 6 data bases, only one data base we have ASM instance, how do you find which data base has ASM?

View 1 Replies View Related

Forms :: Process ID Of Browser?

Apr 28, 2011

I captured the process id of the browser. I wanted to know whether the process id of the browser is dead or not after we close the browser. How can I check the condition for the process id in oracle forms?

View 1 Replies View Related

PL/SQL :: Failed To Process SQL Command

Apr 29, 2013

There is a stored procedure to which i am trying to schedule, but getting error as below:" Failed to process SQL command

-ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 271
ORA-06512: at line 2 "

I am not getting where issue is, as i am new to ORCL SQL Dev.

View 5 Replies View Related

Tuning SQLs In A Batch Process

Mar 18, 2013

I'm having an issue with stale optimizer statistics for some SQLs that are run in a batch process. The problem is that the process runs many times during the day - sometimes 20 to 30 times. And each time, the tables are updated, i.e. rows are inserted or deleted, etc.

So eventually the optimizer statistics for those tables become stale and the performance of the SQLs start to slow down (a lot). How best to gather the optimizer stats on the tables so they don't become stale when the batch process runs each time? The problem is that I also can't add/modify the code in the batch process because it is delivered by the vendor as is.

View 1 Replies View Related

TNS-01153 / Failed To Process String

Aug 3, 2010

Long running data extract executed from SQL SERVER into Oracle.Process runs long time then chokes. What breaks after the process is running ?

03-AUG-2010 05:00:10 * (CONNECT_DATA=(SERVICE_NAME=MyDB)(CID=(PROGRAM=C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtshost.exe)(HOST=SQLSERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.x.xxx)(PORT=4498)) * establish * MyDB * 0
03-AUG-2010 05:00:11 * (CONNECT_DATA=(SERVICE_NAME=MyDB)(CID=(PROGRAM=C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtshost.exe)(HOST=SQLSERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.x.xxx)(PORT=4500)) * establish * MyDB * 0
03-AUG-2010 05:00:12 * (CONNECT_DATA=(SERVICE_NAME=MyDB)(CID=(PROGRAM=C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtshost.exe)(HOST=SQLSERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.x.xxx)(PORT=4502)) * establish * MyDB * 0
03-AUG-2010 05:00:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)
(SERVICE=LISTENER)(VERSION=153092864)) * status * 0

[code]....

View 1 Replies View Related

Replication :: Apply Process Is Not Working?

Oct 5, 2011

I have created Replication process for a single table using the below mentioned script.

connect sys/afccv@afccv as sysdba
show parameter open_cursor
create user STRMADMIN identified by STRMADMIN;
ALTER USER STRMADMIN DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS;
GRANT CONNECT, RESOURCE, AQ_ADMINISTRATOR_ROLE,DBA to STRMADMIN;
execute DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE('STRMADMIN');
connect sys/vxmldb@vxmldb as sysdba

[code]....

According to Alert log file Replication process started( Refer Alert log content below

Wed Oct 05 12:45:53 2011
Streams CAPTURE CP01 for STRMADMIN_CAPTURE started with pid=256, OS id=8692
Starting persistent Logminer Session with sid = 41 for Streams Capture STRMADMIN_CAPTURE
Wed Oct 05 12:46:20 2011
LOGMINER: Parameters summary for session# = 41

[code]....

Now When I am checking the apply status then it is showing Dequeue message

SQL> l
1* select apply_name,state,DEQUEUE_TIME from V$STREAMS_APPLY_READER
SQL> /
APPLY_NAME STATE DEQUEUE_TIME
------------------------------ ----------------- --------------------
STRMADMIN_APPLY DEQUEUE MESSAGES

when I am checking the number of rows on both tables (source and destination) , at destination it is not applying any thing.

View 5 Replies View Related

Windows :: Stuck At Configuration Process?

Jul 20, 2012

The problem is, while installing the Oracle Form and Report 11G R2, my installation got stuck on step 15, i.e configuration progress. Waited for 3hrs and still no progress.

Installing on Win 7 64-Bit, with 4gb ram.
Installed Weblogic Server 10.3.5 64bit(using JDK).

View 6 Replies View Related

SQL & PL/SQL :: How Oracle Background Process Works

Jul 12, 2011

how oracle background process works and in what sequence when we file an insert or update command?

View 4 Replies View Related

SQL & PL/SQL :: Creating Procedure Which Will Process All The Cursors?

Apr 19, 2012

My requirement is like as follows,

declare
v1str varchar2(100):='select empno,ename from emp';
v2str varchar2(100):='select empno,ename,sal from emp';
type t_array is varray(2) of varchar2(100);

[Code]....

So my problem is while executing the different sql statements by passing it to the procedure,how can the procedure would behave dynamically.It must be able to process all the sql statements.

View 21 Replies View Related

Enterprise Manager :: How To See Process Running In OEM

Jan 20, 2010

when I run the form and do some action intheform (call procedure , etc..) how can to see what is the process in running in OEM? Do it have any way to monitor it?

View 1 Replies View Related

SQL & PL/SQL :: Automate The Process Of Updating Sequence?

Jan 18, 2012

I have migrated database from postgresql to oracle...All sequences are migrated with their default values...(Start with 1) I already have 213 entries in a table and I want to begin using this for 214th entry ( replace with "start with 214")

How can I automate the process of updating "Start with" value of sequence with the max no of entry on my table every time I migrate data....

I have created a trigger that will automatically insert the next number from the sequence into the id column.

create trigger test_trigger
before insert on test
for each row
begin
select test_seq.nextval into :new.id from dual;
end;
/

View 2 Replies View Related

SQL & PL/SQL :: How To Handle Exception And Continue Process

Aug 24, 2012

I am trying to execute the below package. While executing i face a problem where when NO DATA FOUND the excpetion is handled and coming out of the loop.but i want to to continue the loop after handling the exception.

Is there anyway i can modify the code

CREATE OR replace PACKAGE BODY pkg_purge_archive_check
AS
PROCEDURE Purge_archive_tables_check (purgerows IN NUMBER)
IS
v_num_1 NUMBER(10);
v_num_2 NUMBER(10);
v_multiplier NUMBER(10);

[code].....

View 15 Replies View Related

SQL & PL/SQL :: Designing A Query - Who To Loop Through Process

Jul 22, 2011

i have query which scores a customer details on some factors and gives it a rank/I have a table called agents which holds the agents details.

This is how i get the rank:
select *
from (
select customer_name ,agent_number

[code]....

The agents table has agent_number and agent_Name....By the above query i check various score against all available agents and assign customers to agents who have highest score or rank is 1

But my problem is who to loop through the process.. i mean after the intial customers are assinged with agents it should run again for remaining customers and for agents who are free(and rank for them is 1) should be checked for assignment Once all agents are assigned but still more customers are available then agents even thoug they are already assigned they can be assigned now since no agent is free..

View 14 Replies View Related

Replication :: ORA-04030 - Out Of Process Memory

Apr 4, 2008

i created a materialized view, and whenever i try to refresh data, using the following package(dbms_mview.refresh), im getting the ORA-04030 error

ORA-12008: error in materialized view refresh path
ORA-04030: out of process memory when trying to allocate 1052696 bytes (callheap,kllcqas:kllsltba)

As far as i know, there no shortage of ram in this machine, im not sure what is causing this error, Then i tried to do a bulk insert using a "INSERT /*+ APPEND */ " in a package, when i execute it, im getting the same error again.

exec M_GET_FACILITIES_DETAILS.GET_AUTOFINANCE_HP_DETAILS('29-Feb-2008');

ORA-04030: out of process memory when trying to allocate 1052696 bytes (callheap,kllcqas:kllsltba)

The number of records im trying to insert is around 600,000, but if i try to repeat the same process with 50000 records, it works fine. i Actually is there any oracle parameter i need to change, cause im afraid if i do that, later in production, it might effect some other modules.

View 1 Replies View Related

SQL & PL/SQL :: Retrieve Text Of Running Process

Jul 30, 2010

How I can retrieve the sql text of a running process. Given the session id.

View 7 Replies View Related

Find The Process ID Which Is Hogging CPU / Memory?

Nov 17, 2012

Trying to find the Process ID which is hogging CPU/Memory

$ ps -e -o pcpu,pid,user,tty,args |grep -i oracle|sort -n -k 1 -r|head

here , this works well ..

TOP 10 PROCESSES CONSUMING MOST CPU

$ watch ps -e -o pcpu,pid,user,args |sort -k 1 -n -r | head -10

this is not working ... always i am getting following output

QUOTE x processes w/o controlling ttys t by tty
*********** output format ********** *********** long options ***********
-o,o user-defined -f full --Group --User --pid --cols --ppid
-j,j job control s signal --group --user --sid --rows --info
-O,O preloaded -o v virtual memory --cumulative --format --deselect
-l,l long u user-oriented --sort --tty --forest --version
-F extra full X registers --heading --no-heading --context
********* misc options *********
-V,V show version L list format codes f ASCII art forest
-m,m,-L,-T,H threads S children in sum -y change -l format
-M,Z security data c true command name -c scheduling class
-w,w wide output n numeric WCHAN,UID -H process hierarchy

View 4 Replies View Related

SQL & PL/SQL :: What Is Backend Process Of Oracle Database

Dec 9, 2010

i want to know the backend process of Oracle DB.because when ever we are taking about DB , so many things are coming into pictures like Physical,logical structures,instance,schema,servers,storage and all. Actually i know what is oracle and why we are using that .

View 4 Replies View Related

Production Database Server Process

Apr 27, 2013

Oracle 11g default server process is dedicated select distinct server from v$session; dedicated

Which server process is used in the oracle 11g Production? if the database is connect to an online application?

View 19 Replies View Related

PL/SQL :: XML Aggregate Function And Out Of Process Memory

Aug 8, 2012

I am getting most of the time 'out of process memory' when i run the 'ord' procedure.here i am providing the tables and the procedure.

i have 2 table orders which holds distinct values, and departments table has ordvalue column holds long string of values for a particular record from orders table. for example if the values in orders table as follows:

ord_code ord_level ordid ordstatus ord_num user utimestamp
SR11          1 2 A          101 V     SYSDATE
SR11          1 2 A          102 V     SYSDATE
SR11          1 2 A          103 V     SYSDATE
SR11          1 2 A          104 V     SYSDATE
SR11          1 2 A          105 V     SYSDATE
SR11          1 2 A          106 V     SYSDATE
SR11          1 1 B          101 R     SYSDATE
SR11          1 1 B          102 R     SYSDATE
SR11          1 1 B          103 R     SYSDATE
SR11          1 1 B          104 R     SYSDATE
SR11          1 1 B          105 R     SYSDATE
SR11          1 1 B          106 R     SYSDATE

ETC...
AT TABLE departments data will be like this

ord_code ord_level ordid ordstatus ord_num user utimestamp
SR11          1 2 A          101,102,103,104,105,106 V sysdate
SR11          1 2 B          101,102,103,104,105,106 R sysdate

from the get_ord procedure the data aggreates using the xmlelement and gets as a long string value into departments table of ord_num column.

CREATE TABLE test.orders
(
ord_CODE VARCHAR2(4 BYTE) NOT NULL,
ord_LEVEL VARCHAR2(1 BYTE) NOT NULL,
ordID NUMBER(5) NOT NULL,
ordstatus VARCHAR2(1 BYTE) NOT NULL,
ord_num NUMBER(3) not null,
user VARCHAR2(8 BYTE),
UTIMESTAMP DATE
[code]...

View 0 Replies View Related

PL/SQL :: DB Parameter To Process More Number Of Records

Oct 18, 2012

We have a package that processes(Insert and Update) set of records and runs in loop.

Package is working fine when we set number of records to 300 for each loop and commit. when we increase the number of records to 1000, package is getting stuck(Not ending and not coming out of loop).

Is there any DB parameter to be changed in my environment to process more number of records at at time?

View 6 Replies View Related

SQL & PL/SQL :: Check Availability Of Datafile For ETL Process?

Mar 26, 2010

develop a Oracle stored function or procedure to confirm a availability of datafile on a specific local directory to be read by Oracle External table. The fine looks like filenameddmmyyyy.csv.

I have create a Oracle directory named data_dir that is mapped with physical directory c: mep

Once it is confirmed that datafile is available the ETL process is started.

View 5 Replies View Related

Need To Process French Language Data

Apr 6, 2010

I've recently been asked to replace certain English text fields with their French translation. I thought I could do this with the replace function: line_desc_reformed := replace(l.Line_Description,'Labor Item for Regular Hours','Main d uvres pour les heures rgulire');

The special characters do not get translated. So I tried the CONVERT function: line_desc_reformed := CONVERT(line_desc_reformed, 'WE8MSWIN1252', 'WE8DEC').

All gets translated except for the tick mark after the d. It gets replaced by an upside down? I have tried several different language sets and can not get that to convert.

also when using the dbms_xmldom to convert this to xml, the also gets replaced by an upside down ?. I don't belive you can change the charset when using this package.

View 6 Replies View Related

Which Background Process Is Responsible For Getting Result Of SQL Query

Jul 21, 2011

Which background process is responsible for getting result of sql query issued to an oracle engine?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved