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
Hi,    I want to know list of purchase orders which have open advances.   plz suggest me the report or transaction name where i will get this details of vendor/ purchase order and balance advance amount.Hi, Check this report in Accounts Payable Infor [More]
I want to create a Context sensitive Webhelp - one help topic for one page/function for web application. I'm using Robohelp 9 with Team Foundation Server 2012. I also have MSSCCI provider installed. I will be using unique ID (Map ID) or unique window [More]
$ Hiya Guys so tell me please how can i install allthose features that i had back then in Windows XP, you see the problem now is that i cant install SB features from my install CD, and auto - update and website doesnt offer me all those features, sma [More]
Hi, Can someone tell can I play and if I can, how to play sfx sound in applet?? Thanks.hello boba , add this mail to ur msn if u please , wana comunicate [email protected] certfied java programmer from sun , egyption , and i need some helpRead other [More]
Can you tell me what activities are generally involved at the time of closing plant and also these data should be transfered to new plant. I know some of the functions need to do.... fixed assets - ( intra-co move / interco move / write off). close O [More]
Hi All, Can anyone help out with how to do analysis based on the SIC code that the application has embedded in the background of the industry picklist? Thanks, JoshHey Josh, Sorry.. you cannot report on this. One of my clients actually includes it as [More]
when ever i try importing an asset it loads to 100% then drops back down to around 75% and loops in this fashion for ever, can i fix this problem or is it that I'm not waiting long enoughJust wait a little longer... ;o) Encore's progress bars and com [More]
Hi! Security Experts, We have an issue where vendor information was changed by multiple user-ids, and the corresponding actual users are saying they have not changed. The user-ids used to change the info don't have access to MK02/XK02 at S_TCODE leve [More]
To protect our customers we want to perform a virus scan on the documents before they get to them. The best way to do this would be during check-in. Has anybody done this? How could this be accomplished? Thanks for any help!There's a ~temp directory [More]
I had the following problem: I had to do queries with JDBC but if the user insert sql reserved word or commas, the system trows an error becose de sql sentence is incorrect. Somebody know any filter for this question. Thank you.And be sure you read u [More]