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
How can I get a list of all my annotations to send to someone else, listed by PAGE #, not order??The comments list is sorted by page by default. If it's not for some reason, click the "Sort comments" button and select that option. It looks like [More]
I'm going to America in a few weeks and was going to buy a iPad 3/HD but I want to be sure there will be no problems using it in the UK now or in the future. Can anyone help? Thanksno problems but there are iTunes issues. In UK you can't use the full [More]
Hi Friends, I am doing Managed System Configuration for HANA DB system. I have created Logical Component for the same, but I am unable to put it in Solution(in SMSY). Can some one suggest. Thanks & Regards, Solman StarterHi, What is the error you are [More]
I m trying to add music to my ipod but when i connect my ipod to itunes it dont show up? is it my computer or is it my ipod touch???Device not detected in iTunesRead other 2 answers [More]
Hi, I'm looking at a G5 2.7 dual tomorrow and need to know what is a safe temperature range, I will check it with istat pro, if there is there a better way of checking can someone let me know?Look deep underneath for dust and liquid coolant leaking. [More]
IPAD 2 FROZE UP WITH NOT ENOUGH MEMORY ON ICLOUD.  CAN'T SHUT IPAD OFF AS IT IS FROZETry a reset: Hold the Sleep and Home button down for about 10 second until you see the Apple logo.Read other 3 answers [More]
Hello and thanks in advance I can restart my HTTP_Server or OC4J_BI_Forms(process-type ) opmnctl restartproc process-type= But how can i restart my Forms and Report Services from command line. my reports server is: rep_tethis_ora_midtier thanksHi RV, [More]
My husband's computer crashed. He's not very technically oriented and cannot remember his user name or password access for Itunes.  I tried his email and it doesn't work. Nor does any other possible combination. So what's my next step. Do I set up a [More]
The stuff I am working on requires repeated use of the same movement for the same animation, but I wanted to keep it all one motion since I think it would be kinda silly to make a motion for each time it does that specific movement. Unless thats a st [More]
Hi, I am Working on EP 7.0 .today am Getting this Error. Portal Runtime Error An exception occurred while processing a request for : iView : N/A Component Name : N/A The exception was logged. Inform your system administrator.. See the details for the [More]