Sitemap

Amicuk Programming Answers

Index > cursor influence in pga >

cursor influence in pga

Advertisement

PGA and Cursor.

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Can you please tell me how cursor affect on PGA. For Eg. Cursor c1 is select * from <tab>; above cursor fetches 1lacs records. So how it will affect on PGA? Please suggest. Thanks in advaned.When all else fails, Read The Fine Manual http://downl[More]

PL/SQL leaves cursors open?

Category:DefaultRelease time:2015-10-11Views:130

I have been researching into what might look like a resource drain in an Oracle 7.3.4 database we have on a SCO OpenServevr 5.0.5 server. There are a couple of applications written in PRO*C (compiled on Solaris with Oracle 8.1.5) always running that[More]

Best practice tunning parameters for tunning ADF apps?

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I am tuning our 11g ADF app for around 3 billions (can be up to 10 billions records) and the concurrent connections up to 100. The app is running on a 16 core Intel chip and 8GB of RAM. The Weblogic used Rockit JDK. Any one have this experien[More]

Metric of influence of count cursors to size of PGA and UGA

Category:DefaultRelease time:-0001-11-30Views:130

Hello! If I right understand, growthing of count of child cursors indirectly influences the size of PGA and UGA, if it's true, how to receive absolute metric (*GA , not Shared Pool) ? Thanks, Paul Edited by: Paul on 06.02.2012 21:28Hi Paul, To be spe[More]

Prevent Container.setCursor from influencing cursor for all components

Category:DefaultRelease time:-0001-11-30Views:130

Hi As you might know, "setting the cursor of a Container causes that cursor to be displayed within all of the container's subcomponents, except for those that have a non-null cursor" (Component.setCursor javadoc) Anyone has an idea how to preven[More]

Advantages of Collection over Cursor

Category:DefaultRelease time:-0001-11-30Views:130

Hello All, Cursor acts like a pointer to the query result. Collections stores the query result. But, What are the advantages of collection over cursor? I Googled it but didn't find the exact info. ThxPrabodh wrote: Hi, Each has its own use. They do n[More]

Performance: Operations in Cursor vs. Operations in PL/SQL block

Category:DefaultRelease time:2015-10-11Views:130

Why does I have a better performance when I program operations in complex cursors instead of programming the same statement in a pl/sql block in a stored procedure? Operation in a Cursor: CURSOR c IS   DECODE(name,'Peter','dog','cat') animal   ...The[More]

Opening and fetching cursor.. what accually happens?

Category:DefaultRelease time:2015-10-11Views:130

So, if we have an explicit cursor... we open it with open c_cursor_name... and fetches it into some variable... my question is - what really happens when we open cursor? does oracle make only instance of cursor object in memory? or... does it reads s[More]

Cursor memory use in a background job

Category:DefaultRelease time:2015-10-11Views:130

I am researching a solution for a client, and need help as I'm admittedly an Oracle greenhorn. They run 10g Enterprise Edition. {color:navy}*The problem*{color}: create a low-priority background process that uses DB inactivity windows to read through[More]

How to get highest number of open cursors within the current calendar day

Category:DefaultRelease time:2015-10-11Views:130

Hi all , i need to know how to get the highest number of open cursors within the current calendar day. Thanks ,823030 wrote: the issue is my customer is getting the error ORA-01000: maximum open cursors exceeded and we need an sql statment that gets[More]

Data Cartridge Implementation - PGA Memory Problem

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have modified the Data Cartridge implementation explained in the article at http://www.oracle-developer.net/display.php?id=422. More precisely I have modified it to create not only the type returned, but also the select statement. The problem I[More]

Lenovo Yoga 13 - Tochpad Problems / Cursor Jumps

Category:DefaultRelease time:2015-10-11Views:130

Hey everybody, Problem: If I rest one fingertip on my touchpad and do NOT move it, the cursor will jump in vertical direction up and down. My System: I have a Lenovo Yoga 13, i5, 8GB Ram, 128 GB SSD OS: Windows 8.1 x64 fresh install (not original Len[More]

Issue in using Cursor+Dynamic SQL+ Bulk collect +FORALL

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a dynamic query which I need to use as a cursor to fetch records that inturn need to be inserted into a staging table. The issue I am facing is I am not sure how to declare the variable to fetch the records into. Since I am using a dynamic[More]

How to get the plsql table data into output cursor

Category:DefaultRelease time:2015-10-11Views:130

Hi, Could anybody please help me. Below is an example of the scenario.. CREATE OR REPLACE PACKAGE chck IS PROCEDURE getdata(dept_no IN VARCHAR2,oc_result_cursor OUT sys_REFCURSOR); TYPE get_rec is record (ename varchar2(20), eno number(12)); TYPE t_r[More]

XY graph - Cursor List

Category:DefaultRelease time:2015-10-11Views:130

Hi, i have a problem with the display of the cursor text. I am using the property node cursor-list to draw the lines including also the text of the cursor. Attached is a screenshot how I build this property. Unfortunately the text is invisible and I[More]

Cursor in stored procedure fails

Category:DefaultRelease time:2015-10-11Views:130

Hi, In our application we have a stored procedure which is called with in parameters to generate data into some table. This procedure is being called from another procedure. This procedure has been used to generate data into the table without any pro[More]

Power fit function is not fitting correctly to sub-array controlled by graph cursors?

Category:DefaultRelease time:2015-10-11Views:130

I am using two cursors on an XY graph to select a subset of the graphed data to fit a power function to. I noticed that the first selection cursor (left-most on the graph) seems to have more control of the amplitude and power of the power fit while t[More]

Size of PL\SQL Cursor block

Category:DefaultRelease time:2015-10-11Views:130

I want to know the internal working of the PL\SQL Cursor. Lets start with a scenario.      1) I have 3 table with 20 million records each.      2) I am making a join out of them on a certain condition which gives me 60 million records, now I am putti[More]

Scrollable Cursor in Stored Procedure

Category:DefaultRelease time:2015-10-11Views:130

I am trying to implement a scrollable cursor that exists in a stored procedure. Here is my situation: o Oracle 9i (9.2.0.1.0) for both client and server. o OCI Interface in purely C++ environment o I am able to compile/link program with 9i client lib[More]

REF Cursor as Job Parameter

Category:DefaultRelease time:-0001-11-30Views:130

Hi, is it possible to use a REF cursor as a parameter for a job? I need jobs created with DBMS_SCHEDULER.create_job to process data which has always the same format but comes from different sources. The job must be generic and thus should not know wh[More]

Hot
My Original keyboard (MB110LL/A) was damaged. I recieved a new keyboard (MB110LL/B) from the Apple Store online. Now none of the special Apple keys, volume up, volume down, eject, etc. work anymore. I have Boot Camp 3.3 installed on Windows XP. Boot [More]
Hi all , I am doing simple file to file scenario in which i have following as my target structure. <?xml version="1.0" encoding="UTF-8"?> <ns0:MT_IN007_IN xmlns:ns0="Http://xyz.pi.com/OTC/IN007_ABC_PQR">    <OU [More]
My website renders correctly in all browsers except safari but I cannot understand why. Through out the site random parts fail to load but when you refresh either the page then loads correctly or other elements load incorrectly. This is really random [More]
can i hookup touch to tv and play games on itcan i hookup touch to tv Yes, with the correct cable. and play games on it No. Video out is only for videosRead other 2 answers [More]
Is there any way that I can connect an iPad to a Bose sound portable system? Is there any accessory that Incan use? Where can I find it?Easiest way, assuming the Bose model has external inputs, is a Y adapted RCA to headphone jack cable. Its how I co [More]
hi can anyone tell me how order by works in oracle? here the company take has got few million records. select * from company ; i get the result in few seconds . select * from company order by company_id ; this takes long time to get the result .. is [More]
iPad no longer reads PDFs from iWeb site like it did in mid April offering to read PDF in iBooks.How to Transfer Everything from an Old iPad to New iPad http://osxdaily.com/2012/03/16/transfer-old-ipad-to-new-ipad/ iOS: Transferring information from [More]
When trying to install the Adobe Flash Player 11.8 with the MSI I get a 1722 error, then I try installing it with the .exe and it will install but errors out during registering the ActiveX controls. I removed the Reg keys noted in the Adobe forum, bu [More]
Hi All, What is the maximum number of Call Types, Skill Groups and Campaigns created in ICM 8.0.1 and 8.0.3? In which the above requested information will be available??Oh I see. So I guess what you are saying is that is Director's way of compressing [More]
Hello Guys, I made a XML application which runs just fine on a SPA 525 but not on the SPA 502 (have not tested on other 50X phones). The issue is that the URL I return in a MenuItem for the tag <url> gets cut by the phone when it request it. The Flo [More]