Oracle latch: undo global data, Performance Problem

We have performance problem when begin some batch process . when this process begin in DB another sessions have wait with event latch: undo global data, in some sites is recommendation increase size of undo segment, but in our scenario we have lot of free space in UNDO tablespace. How can we find re ...

Oracle Differnace b/w SID and Global data base name

please tell me what is differance b/w SID and global data base name. ...

Oracle Convert Global Data to EPS/ Project Level Data

I am currently using P6 V7, but am looking at upgrading to V8. I have multiple clients and I do not want activity codes, resources, etc. from one to "contaminate" the xers of another. I know that I can set the schedules to separate OBS "responsible managers" to prevent the information from being vie ...

Dynamic link library Global data

What is the meaning of DLL's Global data?.If i have a class with member functions,will any member functionsand data members qualify for the global data category?.How will i make it thread safe? ...

Dynamic link library global data

What is the meaning of DLL's Global data?.If i have a class with member functions,will any member functionsand data members qualify for the global data category?.How will i make it thread safe? ...

Global Data Limit

Well, I am writing a program in which i need these global variables. However when I compile, ile I get a message To Much Global Data in This File.I have no other option, i.e. use pointers and all, cause there are certain restrictions to as per my teacher said.So is there any method to solve this. Al ...

There isn't enough disk space or memory to undo the data

I'm trying to append a table (about a 2,00,000 records) to the main table (about 10,00,000 records) . After running an append query in Access the machine is blocked for a few minutes, then I receive a following message:"There isn't enough disk space or memory to undo the data changes this actio ...

How to declare Static Global data in RTRT ?

/*========================================================================= Types ===========================================================================typedef struct{ variable 1,varible 2,..variable N}X1Datatype;/*========================================================================= Global ...

SQL Retrieve and global Data Item Parts

Hello, After a sql retrieve from a DB/2 Table my SQL-Record look like the following: MANDANT_NR smallInt {column="MANDANT_NR"}; FILIAL_NR smallInt {column="FILIAL_NR"}; ZENTRAL_NR int {column="ZENTRAL_NR"}; But all these Items exists as a global data item. How can i tell the sql record to use thes g ...

Global Data

I have an aplication which create a lot of Modal Dialog box. The first one is the login dialog, and I would like to stock the login in a global data in order to let this data available to all the other dialog box. The other dialog boxe needs this data to make their stuff. So is there a global class ...

Loading Global data???

How do i load global data in C#???Also,how do i start a component added as reference to my project,without calling it...i.e assume that you have an exe and a dll...on executing the exe the dll also should start executing(some how i need to specify a method in the dll as the entry point of it),but th ...

Oracle Unusual performcance degredation after 32bit upgrade to 64bit on linux4

Upgraded from 32bit 10.2.0.2 oracle RDBMS to 64bit oracle 10.2.0.2 RDBMS and since then have had serious performance degredation. We has notice in "top" each oracle process chewing up 100%CPU per connection and notice. We had followed to the later the Metalink note 62290.1 in doing the upgrade.We ha ...

Oracle STATSPACK REPORT (suggestıon)

hiThe database is oracle 10gXE on windows xp.An application is runnıng on the database but it is very slow.I have generated statspack report.Any suggestions? STATSPACK report forDatabase DB Id Instance Inst Num Startup Time Release RAC~~~~~~~~ ------------ --------------- ---2520550172 xe 1 17-Mar- ...

Oracle Performance problem - event : cursor: pin S wait on X

Bellow is 17 min awr report , of oracle PeopleSoft DB on 10204 instance on HPUX machine.During this time the customers complained on poor performance.There were 4,104.23 execution per second and 3,784.95 parseswhich mean that almost any statment was parsed. since the Soft Parse %= 99.77 its seems th ...

Oracle TKPROF CPU time = ELAPSED time

I have an Oracle 10203 running E-Bussinse suite 11i on HPUX SuperDome with 10GB SGA and 20 CPUsI have a job that should be complete in 2HR.I found that it run 23 HR before finished.I run 5 minute event 10046 + tkprof on that session and found that TOTAL CPU time = TOTAL ELAPSED timeAs far as i under ...

Oracle High CPU, alot of waits, and what is table Kotad$

I'm working on an Oracle 10.2 on Solaris 9 system that is getting very high CPU. There are alot of waits on dual, WRI$_ADV_PARAMETERSand for an index on table KOTAD$. Anybody have any idea what that table is?Also there are a igh number of waits for" latch: undo global data" andl"atch: In memory undo ...

Oracle Where is the bottleneck?

all, my db is very slow, its buffer cache hit rario is 52%, how do I sort it? Following is the list or v$system_event.EVENT TIME_WAITED -----------pmon timer 376319517rdbms ipc message 3230729000Data file init write 40450class slave wait 151os thread startup 42521SGA: MMAN sleep for component shrink ...

Oracle my wait events - can anyone see a problem?

this is what i have, can anyone see a problem?thanks EVENT TOTAL_WAITS PCT_WAITS TIME_WAIT_SEC PCT_TIME_WAITED TOTAL_TIMEOUTS PCT_TIMEOUTS AVERAGE_WAIT_SEC ----------------------------------- ----------- ---------- ------------- --------------- -------------- ------------ ---------------- Streams AQ ...

Oracle DBW and undo segment data block question

(Oracle 9.2)hi guys,Am I right in believing that if DBWn writes a data block (lets call it x) from the buffer cache to disk, it does not have to write the undo data block that stores the undo for x to disk too. ...

Oracle Undo huge data

Oracle version: Oracle 10GOperating System: Windows xp - 2We have one java application which inserts huge data in temp table and then there is some business logic which select data from temp table and modifies (insert + updates) other table. And the application performs these steps several times in ...

Oracle Insert as select - why is it writing so much Undo tablespace data?

Environment: Oracle 10g R2, Sun solaris, ASMI have table A with 92 million rows. Table B, which is identical to table A, has 5 million rows. Table A only has three index columns ( no composite indexes ) and the average row length is 109 bytes. I issued the command: insert into A select * from B; in ...

Oracle GLOBAL DATA BASE NAME

When I created the database using DBCA, I gave the global database name as "nozomi" which is not in the name of oralce_dbname.domain.com.Will this result in malfunctioning of the database itself? If it needs to be changed how to change it?I have installed 10g in the stand along system, in that case ...

Is there so call "dedicated" UNDO tablespace in Oracle 9i and higher?

Since one of our applicaions needs to process large amounts of data, we have been using a dedicated rollback segment in order to avoid the "snapshot too old" problem.Recently our DB upgraded to Oracle 9i and DBA asked us to use "undo" tablespace.Based the Oracle 9i Doc., it only allows to select ONE ...

from where can i find/download it's tables and data? ("Oracle iDS Froms:...

i have Student Guide named => "Oracle iDS Froms: Build Internet Application I" from Oracle Corporation, part number D32772, May 2001. it uses "The Summit Sporting Goods Schema" as an example throughout the book.from where can i find/download it's tables and data?will be ...

from where can i find/download it's tables and data? ("Oracle iDS Froms:...

i have Student Guide named => "Oracle iDS Froms: Build Internet Application I" from Oracle Corporation, part number D32772, May 2001. it uses "The Summit Sporting Goods Schema" as an example throughout the book.from where can i find/download it's tables and data?will be ...

A question about Automatic Undo Management in Oracle 9i

I use "set transaction use rollback segment rbs_large" in my procedure before starting a large transaction. I just want to assign more rollback diskspace to this transaction, because rowcount of this transaction may exceed one million.It works well with Oracle 8i, but doesn't work with 9i. ...

Export Data Oracle to file.Dat

I need export data from oracle to file. dat an viceverza, and i dont know how do it, i need to separated any record with @.... any one know how do that??? ...

How can undo commited data.

I am newbie. i have problem here. Just now i have commit the "update" transaction in database. So the new data was written replacing the old data.How can i undo the transaction? I cannot used the rollback bcause i have commit it. How can i do so that i get back the old data? ...

Any ideas on the easiest ways to automate customer change requests for global data?

For the first time, I am developing in an environment in which there is a central repository for a number of different industry standard reference data tables and many different customers who need to select records from these industry standard reference data tables to fill in foreign key information ...

Confused about Capsules and Global data.

If there are lots of data (in the format of passive objects) which are to be reached (read or modified) by more than one capsules. which method is better to implement?1- Define the passives as global, and protect them all by semaphore like mechanisms.2- Put the passives into the modifying capsule, a ...

Confused about Capsules and Global data.

If there are lots of data (in the format of passive objects) which are to be reached (read or modified) by more than one capsules. which method is better to implement?1- Define the passives as global, and protect them all by semaphore like mechanisms.2- Put the passives into the modifying capsule, a ...

Needs media recovery on undo datafile, NOARCH, Oracle 9.2.0.4.0 RAC

Info:DB type: Team development ( or training) dbType: Oracle 9i RAC, NOARCH, No previous hot or cold backup (since training db)SID: RACN1, RACN2Undo: UNDOTBS1, UNDOTBS2 (now UNDOTBS2_new)OS: Solaris 8A datafile of the undo tablespace UNDOTBS2 (file# 18) was put offline with alter database command. T ...

input data ORACLE SPATIAL

Can anybody help me with the ORACLE's SPATIAL?I've been reading the documentation, and about the input data to 'run' it (points, lines, polygons, etc).My question is: What input data can I 'give' it? Must I give the input data with SDO_GEOMETRY structure?If It's true: There is any software/aplicatio ...

Clipboard, Global data and CString

I am trying to use the clipboard to transfer data between two application instances (as well as within the application.) I am using GlobalAlloc and GlobalLock to put the data into global memory. (Ofcourse I registered my clipboard format etc.) My application works fine as long as the object I am cop ...

Threads and global data

I have a dialog based application which reads serial data from a Com Port.I have one thread which sole purpose to read the data from Com 2. The data is coming it at 115200 baudWhen I use the debugger the thread has no problem stuffing these bytes into a character array of say 10000,but when I want t ...

How much volume of data oracle table functions can handle?

I am using table functions feature in oracle 10G.I would like to know how much data it can handle.In my scenario I am getting data in 20 to 30 GBs.Are table functions support those? And I am using external table to fetch data from the files as 20 GBs.Are oracle external tables handles those?Any help ...

Help:thread is corrupting global data

I am facing a strange problem. I have a multi-threaded C program that is communicating with the COM port. I have a dedicated thread to read from the port that remains in an infinite loop to read any incoming data. Whenever something is read my 'read thread' creates a new entry in a global linked lis ...

Different results for the same query and same data ! (oracle 9i)

This is a mystery for me. I've got on my database exactly the same data that my customer (exported schema). We both launch the same query (generated by the software that we sold him). This query has a criteria IN (SELECT MAX()...) to get only data from the last year.The query gives 477 rows on my co ...

how to find index is local or global in oracle dictionary

IS there a way to find out whether partition index is global or local from oracle dictionary. ...

Reading Data: Oracle 64 bit client from oracle 32 bit Database server - Reg

Can we read data from Oracle 64 bit client which is on windows XP 64 bit machine from oracle 32 bit Database server which is on windows server 2003 standard edition. Can anyone let me know any compatibility Issues. ...

copying data oracle to timesten

do we have any tools to copy data from oracle database to timesten database ?need to copy schema+ data from oracel database to timesten database Please heol me on this Reds,Raj ...

System.Data.Oracle.Client RTE n .net 4 vs2010- Code Crashes on Startup.

Apologies to those offended by my starting this thread under odp.net. Didn't see a better place.Anyway, I got roped into updating a vs2008 winform project for just a few more features.The project has quite a lot of db access stuff in it (strongly typed data tables and the like) using system.data.ora ...

Handling of Bulk data - Oracle 9i rel 2

Currently i am working with a huge voulme of date ( arround 3 million) .I have a following requierments:1. Need to fetch around 80000 data. For that i have used Bulk Collect feature with Limit 1000 option.I would like to know is the above approch is good or any other can be applied to get the better ...

Global Data Class

Can anybody please help me out with this situation ,I have a CData class which contains all the neccessary data required thru out the program..Now i want this class and its data to be used by multiple different classes totally independent of each other..Also any of these classes cud just use or even ...

global data in DLL

If more than one program uses the functions of a DLL simultaneously ,how the global variales are handled.If a program is using a DLL at the same time some other program is using the same DLL how the DLL will be shared ? is different copies mentained ? just give me in depth idea of how it will work i ...

Global data

HiI've recently started learning Windows Forms and I've encountered a problem. I have a form (lets call it a mainForm) In this mainForm some data is loaded and displayed to user in ListView control. I want this data to be available in other forms. I wrote a static class and added some static fields. ...

ArcInfo Export Format Data ---> Oracle Spatial

Was wondering if anyone has recent experience in loading data that was exported from ArcInfo into Oracle10g Spatial. The files are text readable. ...

Sharing global data between thread (in DLL)

How can I make my threads share the same data in a DLL ?ExampleI have a DLL that globally defines and allocates some data:char mydata[80];Upon processAttach it call init();void init(){strcpy(mydata, "Hello !");}Now heach of my thread may read (*ONLY* read !) this databy the call to foo();c ...

Updating development with exp.data (Oracle 9i)

I've got a development database that I want to update it's data with the exp.dmp file. What I want to understand is that since there is already data in. How do I avoid duplicate errors. And only add data that does not exist. ...

Problem when undo delete data in Ms Access.

The configuration is as follows: A) Database Server - MySQL 4.0.20d B) Client PC - Ms Access 97 as front-end - MyODBC 3.51.09 The tables in MySQL are as linked tables in Ms Access. The problem comes when I select a record and press [DEL] to delete the record. Naturally, you will see in the status ba ...