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 ...

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 ...

Oracle Differnace b/w SID and Global data base name

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

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 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 ...

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 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 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 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 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 ...

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 ...

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 ...

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 ...

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 ...

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. ...

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 ...

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 ...

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 ...

Ubuntu Maximum number of threads accesing global data at the same time

I have this simple linked list with E elements and the following structure struct elem { int value; int worker; struct elem* next; };I have to create W threads and each one of them has to modify my the values in my list accordingto the value of worker. Anyhow, my problem is that maximum 3 threads ca ...

Oracle Statspack report analysis help...

HiPlease help me to findout what is wrong with our database with help of statspack report. STATSPACK report forDB Name DB Id Instance Inst Num Release OPS Host ----------- -------- --- MKTPRD 1405695857 mktprd 1 8.1.7.4.1 NO SPSSPRDCLU1Snap Id Snap Time Sessions ------------------ Begin Snap: 8734 1 ...

Oracle How to interprete Statspack report

I'm new in using statspack and i've tried to run it and gather the report but i can't interprete the result, i mean what can i do, the decisions after reading the report how to inteprete, what part of the result are the essential.Here is an extract of my statspack report. If someone can help me or a ...

Oracle Buffer busy waits

Version : Oracle 9iI am getting buffer busy waits on some tables. Will increase in inittrans & pctfree of those tables reduce buffer busy waits?Tablespace is having segment space mgmt auto & extent management local.cursor_sharing is similar.Users are not experiencing any problem.Is there any ...

Oracle STATSPACK. What to look for ?

my users have been complaining that the application is very slow. What do i need to look for in this report.STATSPACK report forDB Name DB Id Instance Inst Num Release Cluster Host ----------- -------- ------- XXXX 629101424 XXXX 1 9.2.0.6.0 NO scheduprod-solSnap Id Snap Time Sessions Curs/Sess Comm ...

Oracle performance issue

End users phasing very slow response time from the oracle server.i have attached statspack report below:pls give a suggestion to increase the performance.oracle server : AIX 5.3 Cache Sizes (end)~~~~~~~~~~~~~~~~~Buffer Cache: 12,288M Std Block Size: 16KShared Pool Size: 2,016M Log Buffer: 256,000KLo ...

Oracle Excessive CPU Usage

Hello, I have a Unix server running HP-UX and 3 Oracle instances. One particulay instance is consuming a great deal of CPU resource. Below is the top session stats and also a Statspack report. I have increased the DB_CACHE and it has not helped much. Any suggestions? System: oradb01p Tue Jun 3 13:56 ...

Oracle performance problem (posting AWR Report)

We are facing big performance problem in the database.Here I am posting the AWR Report. can you please suggest which areas needs to be improved... WORKLOAD REPOSITORY report forDB Name DB Id Instance Inst Num Release RAC Host ----------- -------- --- PROD 3800788184 PROD 1 10.2.0.1.0 NO PRODSnap Id ...

Oracle Cache Buffer Chain

We are observing very high CBC latch. I will try to explain what I did so far, and would like to see your commentsDatabase Version: 9.2.0.7 1) from statspackTop 5 Timed Events~~~~~~~~~~~~~~~~~~ % TotalEvent Waits Time (s) Ela Time ------------ --------CPU time 15,676 43.88latch free 20,372 10,586 29 ...

Oracle Performance Problems

I´m new with tuning and i have a little problem, i read a lot of blogs and articles about awr and stackspack. Here is part of my awr report.Server – DELL 2850 – Windows 2003 SP2 x86 – 4GB RAM (/3GB) 2CPU.Snap Id Snap Time Sessions Curs/Sess——— ——————- ——– ———Begi ...

Oracle Statspack interpreting help - buffer busy waits

I've got statspack report from 9.2.0.8 DB, cpu_count = 12 , there is 'buffer busy waits' in top 5 . Is there a problem ?DB Name DB Id Instance Inst Num Release Cluster Host ------------ ----------- ------------ -------- ----------- ------- ------------ XXXX 138180125 XXXX 1 9.2.0.8.0 NO X1   Sn ...

jQuery AJAX call Local data

In case of an AJAX webservice call, returned data is accessible local only...What is the proper way to return data from a local (scope) to global data ? ...

DLL data sharing in same process

I'm trying to understand how global data in a DLL is shared in the same process, so I created a test project that looks like this :Main.exe -> main executable calls getValueA() and getValueB()A.dll -> has method getValueA() which increments global variable from C.dllB.dll -> has method getV ...

Do we archive Undo tablespace also?

guys my question is that do we archive undo tablespace entries also? when database is in archiveing mode.i mean do redo log files contain undo segment data also? ...

Problems using a global object

I'm developing an app for the Myspace OpenSocial API. I'm storing all global data in an object named g that is declared at the beginning of the script, along with it's variables and their values. Another function is called, which assigns a new value to a variable within the global g object. When I l ...

Global variable becomes undefined, but scalars work fine

I have some code that stores some data in global variables, and pops up a new window. The new window has a button that executes another function which needs to access the global data stored earlier.Somehow, the values I stored in this array become undefined to the the function trying to read them. W ...