SQL & PL/SQL :: How Oracle Background Process Works
Jul 12, 2011how oracle background process works and in what sequence when we file an insert or update command?
View 4 Replies
ADVERTISEMENT
Which Background Process Is Responsible For Getting Result Of SQL Query
Jul 21, 2011Which background process is responsible for getting result of sql query issued to an oracle engine?
View 1 Replies View RelatedSwitch To Oracle DBA From Non Computer Science Background
Aug 16, 2010I am on H1 visa and working as chemical engineer...but I am bored of this job... I wanted to switch to IT and particularly oracle dba..
How much is the risk for me as I am coming from non computer science background..there are various IT consulting companies who can provide training and do h1 transfer......currently (year 2010) the market for oracle is booming a lot...so I was thinking what can go wrong if I do this switch.
SQL & PL/SQL :: Does Force View Option Works In Oracle 11g
Aug 13, 2010when i am trying to excute below query.. it says ORA-00942: table or view does not exist.
create or replace force view v2 as select * from employee;
Server Administration :: Whether Oracle 9i Works In Windows 2012
May 14, 2013know whether Oracle 9i works in Windows 2012? As we are planning to upgrade.
View 1 Replies View RelatedWindows / .NET :: Oracle ODBC As User Works But Fails As SYS
Feb 1, 2013Windows 7
Oracle XE 11gR2
From Windows, I can successfully create and connect with a system data source using an user Oracle account.But when doing then same configuration process I can not create or connect using the 'SYS' account.
i get the error 'ORA-2009: connection as SYS should be as SYSDBA or SYSOPER'.
What is the solution to creating an ODBC DSN for the user 'SYS'?
SQL & PL/SQL :: How To Get Which ORACLE Process Get More CPU
Apr 23, 2012I 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
Server Administration :: Oracle 10G Client Works With 11G Server?
Jul 17, 2013Does a 10g oracle client works with an Oracle 11g server?
View 1 Replies View RelatedSQL & PL/SQL :: What Is Backend Process Of Oracle Database
Dec 9, 2010i 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 RelatedPeriodic Data For Microbatch Process From Oracle
Sep 7, 2012Background:
A client of us has given us a new requirement to write batch extracts from an operational database. While that per se is not the issue it is the peculiar circumstances that have made it a bit of head ache.
i. The database is an operational system (for telco billing)
ii. THe data from key tables of events etc. has to be replicated to downstream systems like the data warehouse, reporting areas etc. every 15 mins.
iii. Needless to say there are about 50 million records to unload from the table.
iv. The tables are partitioned and tuned for operational purposes.
v. The dba are a bit touchy (surprise!) about persons accessing their db directly for unloads
vi. There is no stand by or replication from this database
So, given the above what would you experts recommend as an option. We had recommended a golden gate based solution however that has is thought of long term solution as it will involve purchases and some POC. Would be grateful if persons can enumerate options, tools, 3rd party options or oracle design solutions .
Out Of Process Memory Error When Upgrading From Oracle 9.2.0.8 To 11.2.0.2
Apr 7, 2012I got the following error when upgrading from Oracle 9.2.0.8 to Oracle 11.2.0.2 version using catupgrd.sql script.
=================================================================
CREATE OR REPLACE PACKAGE BODY kupm$mcp wrapped
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ERROR:
ORA-03114: not connected to ORACLE
SP2-1519: Unable to write to the error log table sys.registry$error
ORA-04030: out of process memory when trying to allocate 8392728 bytes (pga
heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8392728 bytes (pga
heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8168 bytes
(callheap,kcbtmal allocation)
Process ID: 81984
Session ID: 1 Serial number: 5
==========================================================
My machine environment is:
UNIX AIX 5.3 level 12
Oracle 11.2.0.2
RAM size 2GB
ulimit settings:
> ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) unlimited
coredump(blocks) 2
nofiles(descriptors) unlimited
Currently i tried to increase SGA & PGA to possible extent, but still getting this error? Is there any change required in ulimit, RAM etc?
Oracle Stream Error At Create Capture Process?
Jul 14, 2010I'm configuring Oracle Streams 11g. When I'm trying create capture process I receive this error:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 372
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 312
User stream administrator "stradmin" has dba role in both source and target databases.
Performance Tuning :: Oracle Process Exceed SGA_MAX_TARGET
Jul 17, 2012I have an Oracle Database 11gR2 installed on Windows 2008 server. But there is a kind of hang sometimes arise during work hours. while i am opening control panel i saw oracle process is around 15G even we configured SGA_MAX_TARGET=6g.
View 2 Replies View RelatedBackup & Recovery :: Process Of Setting Up DR Environment For SAP And Oracle Database
Feb 7, 2012We are in the process of setting up a DR environment for our SAP and Oracle databases . The netapp and our architects came up with solution as follows .
1.Standby databases are built for all production databases.
2.The SAP file systems are replicated to the secondary site
3.The Oracle logfiles and controlfiles are replicated by netapp snap mirror every 10 mins interval
4.The database is recovered through recover standby database every 15 mins at standby site
5.Please note there is no data guard involved .
6.To test the failover , the mirror is broken .The standby controlfile is replaced with Production controlfile and Redo logs files.
7.The standby database issued a startup comnmand and it worked .
Would like to know whether the step 6 is a correct approach ? I tried to convince the architects that this will result in a very disastrous situation for us but none is listened to .
Server Administration :: Getting Total Number Of Processes And Currently Used Process In Oracle?
May 4, 2012is there any view in oracle for getting the total number of processes and currently used process in oracle? i am using oracle 11.2.0.1.0.
View 3 Replies View RelatedOracle 11g R2 - (SHAD) Process Causing ORA-00020 Maximum Number Of Processes
May 23, 2013Oracle 11g R2 on WIndows 20o8 R2 Standard edition
I have a test server that keeps running into ORA-00020: maximum number of processes error each night. Our current setting is '600' processes to be allowed. There are no users to this database except myself. No front end app connects to it either.
I found that ORACLE.EXE (SHAD) process coming from SYSMAN user is the one eating up all the processes and eventually causing that error.
From v$session, the program is OMS.
From v$process, the hostname is the server itself.
I narrowed it down to restarting the ConsoleService, if i do that, then the number of processes drops down. So now im not sure why something within the ConsoleService is logging in, taking a process and not releasing it...What i can check?
Export/Import/SQL Loader :: DMP File In Oracle XE - Failed To Process Parameters
Jul 18, 2012I am getting the following error while trying to import dmp file in oracle xe:
D:>imp system/manager file=pune_ucf.dmp tables=(ARR_TOT, DE
P_TOT) grants=no indexes=no rows=yes ignore=yes log=loc.log buffer=100000000;
LRM-00104: '100000000;' is not a legal integer for 'buffer'
IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully.
Forms :: Set Image In Background In 6i
Dec 15, 2011I want to set image in back ground.but there no option in properties.how to set back ground.
View 3 Replies View RelatedSQL & PL/SQL :: How Does Loop Works
Jun 27, 2011[CODE]
DECLARE
D1 DATE:='&D1';
D2 DATE;
BEGIN
WHILE D1<=D2 LOOP
DBMS_OUTPUT.PUT_LINE(TO_CHAR(D1,'DAY DD-MON-YYYY'));
D1:=D1+1;
END LOOP;
END;
Here I want to display all the seven days. One more question is here I'm d1<=d2 but d2 is null. So how does <= works here a null. A null is always null. What will be there in d2 how does the loop works with this comparision.
SQL & PL/SQL :: Query Works In 10g But Not In 11g?
Apr 29, 2012I have the query below that works absolutely fine in Oracle 10g but is not running in Oracle 11g. Couple of things I notices about this query.
1. If I remove the alias 'FACILITY_W_CODE' in the ORDER BY clause, query works fine in 11g. If I replace 'FACILITY_W_CODE' with the actual fields - 'F.SERVICE_AREA || F.DISTRICT_OFFICE || F.DO_GROUP || F.DO_SSC' even then it works fine.
2. If I remove the GROUP BY clause in the inside query but keep the alias 'FACILITY_W_CODE' in the outside ORDER BY clause, the query works fine.
I am not sure where the issue is, GROUP BY or the ALIAS. Also, the alias issue seems to be only where the alias is used for multiple fields.
SELECT F.SERVICE_AREA || F.DISTRICT_OFFICE || F.DO_GROUP || F.DO_SSC FACILITY_W_CODE, PF.FAC_TYPE FACILITY_TYPE, PF.FAC_IDENT LOCATION_IDENTIFIER, P.DISTRICT_CODE USER_W_CODE, P.EMAIL_ADDRESS, PF.CERTIFICATION_AUTHORITY, PF.CALLBACK_TECHNICIAN, PF.CALLBACK_ENVIRONMENTAL
FROM PEOPLE P
JOIN (
SELECT I_PF.ID, I_PF.FAC_TYPE, I_PF.FAC_IDENT,
[code]....
PL/SQL :: How Where Condition Works
Jun 1, 2013How oracle retrieves data from a table.like let say a table product as
create table product(id number,name varchar2(10))
table product dont have any index on it
now if this table conatain 500 rows and we have two query
1. select * from product where id=26
2. select * from product
does both query take same time or first query will execute in less time since it has where condition
Forms :: Applying Different Background Colour?
Apr 21, 2011I have got a form in tabular format. each record contains some specific colour or it may not contain.
i want to chage the backgroud colour of that record based on what so ever user wants. for example, user want first record should be of RED back groud, second green, third blue etc.
colours are available in RGB format.
when i try to set_item_property(backgroundcolor) on post-query or on when new item instance, it makes all record of same colour.
note:- if a put another text/display item and make it number of record displayed property = 1 , then it works, because only one record colour is seen at a time.
I can not use multiple visual attributes because number of colours are up to user feedback.
how can it be applied in tabular format?
Forms :: How To Change Background Image
Jan 28, 2010I was confuse about oracle applet parameter form that's in formsweb.cfg at line
# Forms applet parameter
background=C:imagea.jpg
but when i run oracle form it's still not appear image that i want to appear with a.jpg . how to change background of oracle form.
Forms :: Text Box Background Color?
Nov 24, 2011How can i change my text box into a transparent background?Any color code for it? I'm using Form 6i
View 5 Replies View RelatedPL/SQL :: Call Procedure2 From Procedure1 (in Background)
Feb 19, 2013my need is to call procedure2 from procedure1 "in background". What I mean... Let's say, procedure2 works about 10 seconds. So, procedure1 should call procedure2 and go on working without waiting for procedure2 to end its work.
How do I perform it? Is it possible at all? My thought was to use pragma autonomous transaction, am I right?
Code Works In Firefox But Not IE7?
Jan 29, 2008I am fighting with some code to work in IE7. It is currently working in Firefox.
A little bit more on the context of the situation is that I am entering the code as a personalization on an Oracle Self Service Page. I am entering in as a raw text personalization.
[Code]
<html>
<head>
<style>
</style>
</head>
<body lang=EN-US style='tab-interval:.5in'>
[code].....
SQL & PL/SQL :: ORA-00979 In 11G But Works Fine In 10G?
Aug 1, 2011I tested the SQL in 11G and get the ORA-00979 (not group by error) , the same SQL is working in 10G.
553322.1 - ORA-00979 IN 11.1.0.6 BUT NOT IN 9I OR 10G
814423.1 - ORA-00979 AFTER UPGRADE TO 11G
Do we have simple soluation for it if I don't have Oracle support account?
SQL & PL/SQL :: DML Statements - How Does Merge Works
Jul 23, 2013My teacher taught the lesson of DML statemnts, he told us how does merge works , but he did not give us any query for that,provide query for Merge and if possible then explain it too , I am using Oracle 10g Sql Plus.
View 3 Replies View RelatedServer Utilities :: Run Exp Utility In Background Mode
Oct 29, 2013I have executed the exp utility to take schema backup as below.
DB_NAME=name
DAY=`date +%a_%d-%m-%Y`
gzip < exp_test_pipe > exp_test_${DAY}.dmp.gz &
exp username@test.cis.cat.com file=exp_test_pipe log=exp_test_dumps.log parfile=export_options.par
more export_options.par
compress=n
statistics=none
CONSISTENT=n
indexes=Y
owner=test
direct=Y
my password is starts with $
example: $12300$ahhh and hence its not allowing me to execute when given like below..
exp username/$12300$ahhh@test.cis.cat.com file=exp_test_pipe log=exp_test_dumps.log parfile=export_options.par
Forms :: Change Background To Logo Message
Jun 30, 2010I want to change the Background "Oracle Forms AS services" to one of our logo. I searched in formsweb.cfg and tried many parameters. I got succeeded in changing Title, forms background but not able to change the oracle logo message in the white background of html web page.
View 2 Replies View Related