Home » SQL & PL/SQL » SQL & PL/SQL » dbms_random.seed performance issue
dbms_random.seed performance issue [message #228638] Tue, 03 April 2007 09:36 Go to next message
ganeshsv
Messages: 51
Registered: January 2006
Member
Hi I need to call dbms_random.seed in a loop for 1000 times. It takes longer time. Is there any alternative.

Thanks in advance
sg
Re: dbms_random.seed performance issue [message #228641 is a reply to message #228638] Tue, 03 April 2007 09:39 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why would you call the seed 1000 times?
Re: dbms_random.seed performance issue [message #228645 is a reply to message #228641] Tue, 03 April 2007 09:47 Go to previous messageGo to next message
ganeshsv
Messages: 51
Registered: January 2006
Member
I need to get random number within a range of number. And this random number should be same for my various Databases.

Thanks in Advance
sg
Re: dbms_random.seed performance issue [message #228648 is a reply to message #228645] Tue, 03 April 2007 09:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You want a random number that is not random! Razz

Regards
Michel
Re: dbms_random.seed performance issue [message #228650 is a reply to message #228648] Tue, 03 April 2007 09:56 Go to previous messageGo to next message
ganeshsv
Messages: 51
Registered: January 2006
Member
Yes I read somewhere its not random. But I need such requirement. Can you please help me.
Re: dbms_random.seed performance issue [message #228652 is a reply to message #228650] Tue, 03 April 2007 09:59 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
So you have 1000 databases?

Normally, you would call seed only once and then random for the numbers.
Previous Topic: How to read and create XML using XMLDB built in
Next Topic: hoststring in sql*plus
Goto Forum:
  


Current Time: Sun Dec 04 16:35:08 CST 2016

Total time taken to generate the page: 0.07718 seconds