Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Code correction - PL/SQL

Albert ChaoJul 28 2021 — edited Jul 28 2021

Can someone please correct the code below. The code is to find perfect numbers between 1 to 100

set serveroutput on;
DECLARE
sum NUMBER;
p NUMBER;
BEGIN
dbms_output.put_line('Perfect numbers between 1 and 100 are :');
p := 1;
FOR i IN i..100

LOOP
while(p<=(i/2))
end loop;

if(mod(i,p)=0) then
sum := sum +p;
p := p+1;
end if;
end loop;
if(sum = i)
dbms_output.put_line ( i|| ' ' ) ;
SUM := 0 ;
END ;

Comments

Billy Verreynne

A session is the logical entity that services a specific db client connection.
A process is the physical entity that executes a session.
With dedicated server, each session has its own physical process for execution. 1:1 relationship. A 100 sessions mean a 100 processes.
With shared server, sessions share a pool of processes, where any idle process can be tasked to execute any shared server session. A 100 processes in the pool can service a 1000 shared sessions. However, if all 100 processes are busy, then 900 sessions need to wait for an idle process in order to to be serviced.

sol-danesh

And What is the method of setting these two parameters in Oracle architectures?

sol-danesh

Thank you dear Billy Verreynne.
As a result, it can be said that dedicated architecture is better for projects with a large number of users?

Billy Verreynne

Basic parameters for shared server are DISPATCHERS and SHARED_SERVERS.
Shared Server is ideal for supporting a large number of OLTP type users, servicing 1000s of user requests that are of short duration to service. Note that UGA memory is stored in the SGA.
Dedicated Server is ideal for supporting OLAP type users, servicing 100s of user requests that are of long duration to service. Note that UGA memory is stored in the PGA.
The Oracle database can use both architectures at the same time.

1 - 4

Post Details

Added on Jul 28 2021
6 comments
606 views