Soft Parse In Instance Efficiency Is 11.21%
Jun 20, 2013
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.19 In-memory Sort %: 100.00
Library Hit %: 83.82 Soft Parse %: 11.21
Execute to Parse %: 92.47 Latch Hit %: 99.77
Parse CPU to Parse Elapsd %: 82.07 % Non-Parse CPU: 71.64
I see my soft parse in instance efficiency is 11.21%. Is this something to worry about?
View 2 Replies
ADVERTISEMENT
Jan 18, 2012
Our developer team has given two process instance number[the process is running from Peoplesoft] that are running beyond the time limit.I need to know the SQL ID from the process instance number. Is there is any way to know the SQL ID?
View 5 Replies
View Related
Oct 9, 2012
In an Application Procedure, I'd like to reference some items that are local to the current page. Obviously, hard-coding like the following won't work unless it happens to be on Page 25.
:f105_blah := :p25_blah;
So how can I write this line of PL/SQL code so that the "25" is automatically set to the number of the current page?
View 13 Replies
View Related
Apr 29, 2011
I have a table that has rows like below in one column. I want to parse the rows in different columns.
Column12
abc|yed| qas ert | hub cap | jak
agh|
bef|rfd
som|gfr|lup
I need to parse the above in different columns by splitting at the pipe.
so it will show something like this
col1 col2 col3 col4 col5
abc yed qas ert hub cap jak
agh
bef rfd
som gfr lup
is it possible to do it in PL/sql.
View 3 Replies
View Related
Jan 11, 2012
I have a column which holds the data in the below format.
Source Data :
>SNO_SDSDQ-8192-BN>SNO_54-99-24120-8192
>SNO_SDSDQ-8192-BN>SNO_54-99-24120-8192>SNO_54-90-16489-008G
>SNO_SDPMDB-008G-11>SNO_54-90-18008-008G>SNO_54-62-08791-008G>SNO_20-81-00327
>SNO_SDPMDB-008G-12>SNO_54-90-17830-008G>SNO_54-62-08598-008G>SNO_20-81-00327
[code]..
Problem Statement :
Split the above data into individual components and create columns / aliases dynamically.If the column is present then place the data under the created column.
Example 1) :
>SNO_SDSDQ-8192-BN>SNO_54-99-24120-8192
Result
Column Name : SKUCol_54-99
Data :SNO_SDSDQ-8192-BNSNO_54-99-24120-8192
Example 2)
>SNO_SDSDAA-002G-101-J>SNO_54-90-16002-002G>SNO_54-62-05781-002G>SNO_20-81-00135-5
Column Name : SKU54-90Col_54_62Col_20_81
Data :SNO_SDSDAA-002G-101-JSNO_54-90-16002-002GSNO_54-62-05781-002GSNO_20-81-00135-5
Column Name can be derieved from the components like SNO_54-62-05781-002G
i.e. SNO_54-62-05781-002G ==> SNO_-05781-002G
"54-62" will give the Col_Name
The First Column will always have data starting with
SNO_SD%
This column is constant and will be named as SKU.
I need this data to be placed in the same record / row but under different columns as per the data set.Basically, Can the data be split into multiple parts based on delimeters and the columns are created based on the unique data in the parts that form the data in the column.
View 1 Replies
View Related
Jul 22, 2013
I'd like to parse an XML file and get some data extracted as columns. Input file country.xml:
<?xml version="1.0" encoding="UTF-8"?>
<MAS Action="Insert">
<Country ObjectId="100000000000000009" VersionId="8"><Id>1</Id><NlTexts><Name Language="de">Land1</Name><Name Language="en">Country1</Name></NlTexts></Country>
[Code]....
View 2 Replies
View Related
Sep 26, 2013
I have table with Blob column. In the blog column I have XML data (see below). I wanted to parse xml and get the value of note '<GetTest>'. How do I achieve that? Sample Table:
create table SAMPLE_XML_TABLE
(
ID NUMBER not null,
XMLSTRING BLOB,
);
<?xml version="1.0" standalone="no"?>
<FromResponse xmlns="http://www.somewebsite.com/FromResponse">
<Code>0000</Code>
[code].........
View 7 Replies
View Related
Apr 1, 2013
I have a field that contains many part numbers. There can be 2 or more part numbers in the field separated by a space. How can this be dynamically read so you can compare the contents in the where clause to what you are search for? Example Part Numbers in the field: 1X 2X 3X 4Y 5Y 7Y
I would like to read the field and make rows out of the data.
1X
2X
3X
4Y
5Y
7Y
View 3 Replies
View Related
Apr 11, 2011
I got the table where are logged every single events from web site. Sometimes (depends on events)is written xml code into the xml_params column of table H ow to make an automatically procedure (sql query, function, or something like that) which every value of xml code should be written separate into the column the table. The point is I dont know what parameters will be included in the xml code in future.
For instance xml looks like:
<parameters xmlns="http://datalan.sk/webreporting/params/v1_0">
<parameter name="loginReason">
<value>invalidUserNameOrPassword</value>
[code]....
View 17 Replies
View Related
Mar 22, 2010
how to parse paramlist type variable to get names of the fields and their values in the paramlist?
View 1 Replies
View Related
Mar 29, 2013
I'm working on trying to write a shell script to parse a parameter file, but at the same time I want to be able to overwrite the parameter file settings with other command line settings. For instance if my par file had export/import settings for the username, password, schema, etc;
I wanted to run the same export/import with those settings for a different schema. I want to be able to put the schema=<different_than_par_file> after the parfile=<parfile.par and have the parfile be read and applied for everything except the different schema.
Right now I'm storing the cmd line and parsing it again looking for other parameters besides the parfile.
View 4 Replies
View Related
Jul 1, 2010
Is it possible to use oracle dataguard from single instance to RAC instance ? Does Oracle dataguard support this ?
View 1 Replies
View Related
Mar 16, 2011
My context on our servers is the following one:
- one ASM instance
- X DB instances
- each DB instance uses 2 or more dedicated diskgroups from the ASM instance
- there is one diskgroup named FREEDISK that contains spare disks
On each DB instance you can see:
- the list and global parameters of all diskgroups using v$asm_diskgroup view
- the list and parameters of all disks the instance is using with v$asm_disk view
So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?
View 6 Replies
View Related
Aug 27, 2012
I'm trying to test moving a single instance 11202 database to single instance w/ grid infra.
Here is what I've done:
1. Install a database (11202), single instance and create a database
2. Install Grid Software only (user: grid)
3. start the cluster
4. "srvctl add database -d orclsidb -o $ORACLE_HOME" to register the database with grid.
4.1> I was able to start/stop the database with srvctl command here onwards
5. configure disks using asmlib and start the asm
6. "srvctl add asm" to register asm with grid.
7. PROBLEM ... when I try to "backup as copy database format '+ASM_DATA_DG';" from oracle user it errors out as below:
RMAN> backup as copy database format '+ASM_DATA_DG';
Starting backup at 24-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/fs0/oracle/oradata/orclsidb/sjc883p_indx_large_01.dbf
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/24/2012 08:53:29
ORA-19504: failed to create file "+ASM_DATA_DG"
ORA-12547: TNS:lost contact
ORA-15001: diskgroup "ASM_DATA_DG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contactConsidering "TNS: lost contact" I tried to see if grid listener is aware of ASM instance:
[Code]....
All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usracdb03.rwcats.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 22-AUG-2012 06:08:53
Uptime 2 days 2 hr. 50 min. 48 sec
Trace Level off
[Code]....
View 10 Replies
View Related
Feb 7, 2011
creating an ASM instance. I've never done this before and searched all known documentation. I just can't seem to figure this out. This is an 11g database on a WinXp machine for testing purpose before attempting to do this on a live production environment
D:\app\user\product\11.1.0\db_1\BIN>localconfig add
Step 1: creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'Dummy\user', privgrp '
Operation successful.
Step 2: creating new CSS service
Failed to create the new CSS service, err(5)
failed to create CSS services
View 6 Replies
View Related
Nov 1, 2010
I have two table in different instance .
IMEI in instance A
RCA_SMART_CARD in instance B
Below is the desc table :
SQL> desc RCA_SMART_CARD;
Name Null? Type
----------------------------------------- -------- ----------------------------
N_CARD_ID NOT NULL NUMBER(10)
C_CARD_SERIAL_NUMBER NOT NULL VARCHAR2(20)
C_SIM_MSISDN VARCHAR2(20)
C_SIM_IMSI VARCHAR2(20)
C_LINKED_CARD VARCHAR2(20)
N_PRO_IDENTIFIER NOT NULL NUMBER(4)
C_CARD_TYPE VARCHAR2(1)
N_SIM_STATE NUMBER(1)
N_EEPROM_SPACE_LEFT NUMBER(9)
N_VOLATILE_SPACE_LEFT NUMBER(9)
N_NONVOLATILE_SPACE_LEFT NUMBER(9)
N_CARD_OPTI NOT NULL NUMBER(15)
N_PRODUCT_ID NUMBER(10)
D_CREATION_DATE DATE
D_MODIFICATION_DATE DATE
D_STATUS_MODIFICATION_DATE DATE
SQL> desc IMEI;
Name Null? Type
----------------------------------------- -------- ----------------------------
MSISDN NOT NULL VARCHAR2(20)
IMEI NOT NULL VARCHAR2(16)
DATE_MOD NUMBER(13)
IMSI VARCHAR2(18)
ICCID VARCHAR2(20)
T_PROF RAW(20)
EXTRA_DATA VARCHAR2(100)
If I want to join two table together . I want to search the number of record in IMEI that have N_SIM_STATE =1 in RCA_SMART_CARD . The MSISDN in IMEI is equal to C_SIM_MSISDN in RCA_SMART_CARD .
View 1 Replies
View Related
May 17, 2011
I have a large Sybase db that is using Documentum as the front end tool to create apps. Total DB size is around 12 GB.
I would like to migrate into Oracle 10 RAC. Should I add to our current RAC instance with a new Schema or ask our DBA for a new instance?
View 3 Replies
View Related
Jul 28, 2010
Is it one alert log per instance or one per database? My guess would be per instance, but I have some documentation that indicates per database.
View 4 Replies
View Related
Nov 25, 2010
In Oracle11g (R1 and R2) we can create the user in +ASM instance just like normal oracle database. But If the user already exist I get an error
CREATE USER test IDENTIFIED BY test
*
ERROR at line 1:
ORA-01920: user name 'TEST' conflicts with another user or role name
So, I would like to know if there is any data dictionary view which can tell me if the user already exist or not.
View 5 Replies
View Related
Mar 1, 2012
In the past, we setup a standby database on our production server. My OS is HPUX, Oracle 10g and my database is in archive mod. We are no longer using the standby database method. My problem now is that one of my tablespace (/oradata/tn/rd2_temp 20gb) became 100% full on my production system. In trying to provide more space, I removed one of the standby redo logs. Instead of using ALTER database, I just did a rm from the OS. As I said earlier my STANDBY DB is inoperatable.
When I tried to drop the tablespace(/oradata/tn/rd2_temp it is 20gb), I am getting an oracle error (ora-19528 redo logs being cleared may need access to files). Im also getting and INSTANCE LOCK on ARC4. The rd2_temp tablespace is now offline. If I get rid of rd2_temp, I will be able to gain more space back to /oradata/tn.
My database is still up and working okay.
View 3 Replies
View Related
Nov 1, 2010
I have Oracle 11g R2 (11.2.0.1) with Oracle EM running on Solaris 10 with ZFS.When I start OEM it comes up and tells me that the listener is running but that the DB instance is down and agents are down.I know that the instance is up because I can start it manually.
Each time I start emctl, lsnrctl and DB manually everything starts running but OEM returns a failure for the DB. long as the display shows the DB not running OEM won't allow me to work in it.Instead of getting the login page I get the Database Control Page stating that "Enterprise Manager is not able to connect to the Database instance."I have tried the various emca -config dbcontrol db -repos drop and recreate but no luck.
Is there a way to uninstall/reinstall without dropping the DB?Are there control/configuration files I may hack to tell OEM the correct information?
View 3 Replies
View Related
Aug 3, 2010
I've come across an fatal error which terminates my database instance. It's basically cropped up twice over a weekend, and the instance needs to be restarted as a result.There doesn't appear to be any entry in the alert log that ties with the time of the failure, so I only have the trace file entries to go on...
CODE*** 2010-07-30 22:15:31.238
kgsksysstop: from KGSKWT_INTSTATECHNG6 retry FALSE mode
kgsksysstop: Failed
kgsksysstop: from KGSKWT_INTSTATECHNG6 retry FALSE mode
kgsksysstop: Failed
kgsksysstop: from KGSKWT_INTSTATECHNG6 retry FALSE mode
kgsksysstop: Failed
kgskrecoveryrecalc: Failed kgsksysstop for 6
kgsksysstop: from KGSKWT_INTSTATECHNG6 retry FALSE mode
kgsksysstop: Succeeded
[code]....
I had a look on my old metalink account to see if there was anything relating to that ORA-56710 error code, but the one article I foun d seemed to be related to RAC instances (which I'm sure that this instance isn't).
I'm using Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production.
View 2 Replies
View Related
Nov 1, 2010
I have two table in different instance .
IMEI in instance A
RCA_SMART_CARD in instance B
Below is the desc table :
SQL> desc RCA_SMART_CARD;
Name Null? Type
----------------------------------------- -------- ----------------------------
N_CARD_ID NOT NULL NUMBER(10)
C_CARD_SERIAL_NUMBER NOT NULL VARCHAR2(20)
C_SIM_MSISDN VARCHAR2(20)
C_SIM_IMSI VARCHAR2(20)
C_LINKED_CARD VARCHAR2(20)
N_PRO_IDENTIFIER NOT NULL NUMBER(4)
C_CARD_TYPE VARCHAR2(1)
N_SIM_STATE NUMBER(1)
N_EEPROM_SPACE_LEFT NUMBER(9)
N_VOLATILE_SPACE_LEFT NUMBER(9)
N_NONVOLATILE_SPACE_LEFT NUMBER(9)
N_CARD_OPTI NOT NULL NUMBER(15)
N_PRODUCT_ID NUMBER(10)
D_CREATION_DATE DATE
D_MODIFICATION_DATE DATE
D_STATUS_MODIFICATION_DATE DATE
SQL> desc IMEI;
Name Null? Type
----------------------------------------- -------- ----------------------------
MSISDN NOT NULL VARCHAR2(20)
IMEI NOT NULL VARCHAR2(16)
DATE_MOD NUMBER(13)
IMSI VARCHAR2(18)
ICCID VARCHAR2(20)
T_PROF RAW(20)
EXTRA_DATA VARCHAR2(100)
If I want to join two table together. I want to search the number of record in IMEI that have N_SIM_STATE =1 in RCA_SMART_CARD . The MSISDN in IMEI is equal to C_SIM_MSISDN in RCA_SMART_CARD .
How can I do and what is the sql statment ??
View 5 Replies
View Related
May 3, 2011
I am installing 4 Node Oracle RAC 11.2.0.2 on RHEL 5.5 (x86_64) {for the first time} I am having some issues with ASM monitoring from em console. the +ASM instance appears to be "down" on the em console. However i can connect to separate ASM instances on respective nodes and thus know that they are not down. I am trying to find out the reason why em console is not able to communicate with my ASM instance.
DATAPOINT1
---------------
Under Metric Collection Error link, I can see the following error message for all the nodes.
Target: xxxxx
Type: Host
Metric: Storage Data
Collection Timestamp: MON D,YYYY H:MM:SS PM
Error Type: Collection Problem
Messsage: executable nmhs should have root suid enabled
[code]....
Now the problem is that I cannot find any binary named "nmhs" anywhere in the grid installation, but this file exists in oracle database bin directory:
-rws--x--- 1 root oracle 67778 May 2 18:04 nmhs
I am also not sure whether this is the error which tells me about the problem why em console is not able to communicate with ASM.
DATAPOINT2
---------------
I tried to run emctl to check if the agent for the ASM instance is running:
I set the following for running from grid home:
ORACLE_HOME=/apps/RAC/grid
ORACLE_SID=+ASM1
[code]....
I have seen in all the forums, that there is a directory named "agent11g". I cant find this anywhere in my installation. Its not there in the grid infrastructure directory or the oracle database directory. what are its contents?, do i need this for my RAC setup?, how to I create this now?
View 1 Replies
View Related
Aug 13, 2012
Is it possible, Oracle let me connect to an running +ASM instance from a different host? I.E, +ASM running on X host and i want to connect from Y host. (yes Y host has the asm entry in the tnsnames.ora).
View 1 Replies
View Related
Jan 31, 2013
Though I have it all configures:
On node1:
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.28.155.79)(PORT=1521))))
[code]....
View 9 Replies
View Related
Jul 3, 2010
I am planning a single instance database using Oracle 11gR2 Enterprise. The instance will run on OEL 5.5 which is on VMWare ESX 3. All disk space will be provisioned as VMDKs. The physical disk comes from a NetApp 7 controlled SAN with multiple disk arrays (one fast disk array and one slower disk array) using NetApp's RAID-DP (RAID-6).
Is there any benefit to using ASM in this single instance configuration ? It seems the data is already being striped, balanced, deduped, and (somewhat) protected by ESX, NetApp, and RAID-DP. NetApp SnapShot provides additional back-up options.
I am thinking without ASM, I could have one 1 TB LUN, say /u01, for the binaries, data files, and management files on the fast disk array and one 1 TB LUN, say /r01, for the flashback recovery area and all other recovery related files on the slower disk array. With autosize capabilities, any of the files can expand as needed up to the 1 TB capacity. 1 TB per disk array is the resource allocation for this instance.
With ASM, on the fast disk array I would have one 32 GB LUN for binaries and other files which must be outside of Oracle's CFS under ASM and then four 248 GB LUNs to create the ASM disk group DATA. On the slower disk array I would have four 256 GB LUNs to create the ASM disk group FRA.
View 1 Replies
View Related
Jul 4, 2012
we have lost a Tempfile due to SAN problem ( the temp tables has 7 tempfiles ) Problem is that some application servers have still that tempfile available since they are connected since a longteime and therefore some users receive an error while trying to use it .
I just wanted to drop it from the system dictionary but i can't i always receive and error ( datafile cannot be dropped at this time)
and i can't see what session is using it, that query wouldn't be useful since i have 7 datafiles and it's based on Tablespace name only .
How can i drop that tempfile without bouncing the instance ?
I'm running Oracle 10.2.0.4 on windows 2003
View 6 Replies
View Related
Aug 17, 2011
Initial situation: Oracle 10g database single instance on Windows 2008 (datafile within NTFS partition)
Final situation: same database upgraded to Oracle 11g r2 on a two nodes RAC on Windows 2008 (datafile within ASM)
In your opinion, is this the best way to achieve the job ?
1) on the two nodes install grid 11gr2, asm, rdbms 11g r2 (SE)
2) export full from 10g
3) create a new empty 11g r2 database in the RAC 11g r2 infrastructure with the same tablespace layout of 10g database
4) import full from 10g to 11g r2
View 1 Replies
View Related
Jun 18, 2010
Urgently need a code for displaying progressbar on spalsh screen on new form instance without button click
View 1 Replies
View Related
