OraFAQ Forum: SQL & PL/SQL » Performance Issue in VARRAY

Home » SQL & PL/SQL » SQL & PL/SQL » Performance Issue in VARRAY (oracle 11G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Performance Issue in VARRAY [message #646448]

Wed, 30 December 2015 19:46

ramchandru1989
Messages: 4
Registered: April 2014
Location: CHENNAI

Junior Member

i have a function that return varray of objects.until now it returns less than64 records.Now the function has been getting 1000s of records in VARRAY returning, due to business growth.This cause an out of memory scenario and the code aborts?which below method is best?

>REplace function with pipelined function

>increasing memory allocation parameters for oracle server

>use compress option of the varray to reduce memory usage

>increase memory allocation for session running this code

>address SQL populating the VARRAY so that it does not return more rows ?

Report message to a moderator

Re: Performance Issue in VARRAY [message #646449 is a reply to message #646448]

Wed, 30 December 2015 20:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ramchandru1989 wrote on Wed, 30 December 2015 17:46

i have a function that return varray of objects.until now it returns less than64 records.Now the function has been getting 1000s of records in VARRAY returning, due to business growth.This cause an out of memory scenario and the code aborts?which below method is best?

>REplace function with pipelined function

>increasing memory allocation parameters for oracle server

>use compress option of the varray to reduce memory usage

>increase memory allocation for session running this code

>address SQL populating the VARRAY so that it does not return more rows ?

We know above.
We don't know actual code.
We don't know actual error.
We don't know why VARRAY exists now.
We don't know what problem the mystery code is supposed to solve.
We don't know which metric measures "best".

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Re: Performance Issue in VARRAY [message #646450 is a reply to message #646449]

Wed, 30 December 2015 20:45

ramchandru1989
Messages: 4
Registered: April 2014
Location: CHENNAI

Junior Member

Hi this question was asked in the oracle certification. couldn't find the answer anywhere. so posted it here.. .

[Updated on: Wed, 30 December 2015 20:46]

Report message to a moderator

Re: Performance Issue in VARRAY [message #646453 is a reply to message #646450]

Thu, 31 December 2015 01:20

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So if you can't find the answer, what did you try to think?
For each possible answer, what is your opinion and why?

Report message to a moderator

Re: Performance Issue in VARRAY [message #646463 is a reply to message #646450]

Thu, 31 December 2015 03:57

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

ramchandru1989 wrote on Thu, 31 December 2015 02:45

Hi this question was asked in the oracle certification. couldn't find the answer anywhere. so posted it here.. .

Quoting exam questions is very much breaking the confidentiality agreement you signed. If the OCP fraud detection group notices your post and tracks you down, you may find that your certifications are revoked.

Report message to a moderator

Previous Topic:	Please help - pivot option
Next Topic:	Can't create a Materialised view

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:39:18 CDT 2024