|
Replies:
10
-
Pages:
1
-
Last Post:
Sep 16, 2008 4:00 AM
Last Post By: Aman....
|
|
|
Posts:
2,049
Registered:
01/09/07
|
|
|
|
shrinking of shared pool
Posted:
Sep 16, 2008 3:08 AM
|
|
|
|
hi friends, when going through documentation i read like "internal tuning algorithm doesn't shrink shared pool when using ASMM". i want to know whether is it all the times or for specific cases. if it for all the time, then it may lead to performance problem as more sql, pl/sql etc info will reside.
please explain me. thanks in advance
|
|
|
Posts:
9,551
Registered:
05/20/01
|
|
|
|
Re: shrinking of shared pool
Posted:
Sep 16, 2008 3:26 AM
in response to: Pavan - a DBA
|
|
|
|
Pavan,
Can you point over the document please?
Aman....
|
|
|
Posts:
107
Registered:
08/12/08
|
|
|
|
Re: shrinking of shared pool
Posted:
Sep 16, 2008 3:31 AM
in response to: Pavan - a DBA
|
 |
Helpful |
|
|
|
For other readers the mentioned document is [here|http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref388].
See Tanel Poder's explanation [here|http://www.freelists.org/archives/oracle-l/12-2007/msg00042.html]. I have also seen that 10.2 shrinks the shared pool.
|
|
|
Posts:
2,049
Registered:
01/09/07
|
|
|
Posts:
9,551
Registered:
05/20/01
|
|
|
|
Re: shrinking of shared pool
Posted:
Sep 16, 2008 3:36 AM
in response to: YasinBaskan
|
|
|
|
Yasin,
Well that's a real mess and its amazing if its happening. But Tanel still didn't give the reason for it. Looks like alot is changing from 10g, buffer data in shared pool.WTH!
Aman....
|
|
|
Posts:
2,049
Registered:
01/09/07
|
|
|
|
Re: shrinking of shared pool
Posted:
Sep 16, 2008 3:42 AM
in response to: Aman....
|
|
|
|
hi friends, can you please explain this also. is is regarding spfile. "It is, by design, a server-side initialization parameter file." even pfile is server-side file, then what really makes the difference? is it only because of dynamic changes that can be made to the database?
sorry for not posting this in seperate thread
Edited by: Naga Pavan Kumar on 16 Sep, 2008 4:13 PM
|
|
|
Posts:
107
Registered:
08/12/08
|
|
|
|
Re: shrinking of shared pool
Posted:
Sep 16, 2008 3:44 AM
in response to: Aman....
|
|
|
|
Aman, if you read the orafaq link he provided it is explained why and how Oracle does it. I myself have seen the same behavior, shared pool sometimes holds granules for the buffer cache.
|
|
|
Posts:
9,551
Registered:
05/20/01
|
|
|
|
Re: shrinking of shared pool
Posted:
Sep 16, 2008 3:48 AM
in response to: Pavan - a DBA
|
|
|
|
Spfile is a server side file. Its a true server side file. Pfile could be on client sides as well. But SPfile can be only on server side and its a dynamic file which makes it ar better than pfile in working.
HTH
Aman....
|
|
|
Posts:
9,551
Registered:
05/20/01
|
|
|
|
Re: shrinking of shared pool
Posted:
Sep 16, 2008 3:52 AM
in response to: YasinBaskan
|
|
|
|
Yasin,
Yes I just read that one,I missed it in the first place.Well I am not sure that how much else is in store for surprises?Thanks for it.
Cheers
Aman....
|
|
|
Posts:
2,049
Registered:
01/09/07
|
|
|
|
Re: shrinking of shared pool
Posted:
Sep 16, 2008 3:54 AM
in response to: Aman....
|
|
|
|
hi Aman,
assume my env is windows and database name is dev and database is down now.
on client side i am having pfile.
client side:
1) set local=dev
2) sqlplus "/ as sysdba"
3) startup pfile='location where it resides on client side'
can we do something like this?
sorry for not experienting myself and asking you because i am not having that client-server env in my organization.
|
|
|
Posts:
9,551
Registered:
05/20/01
|
|
|
|
Re: shrinking of shared pool
Posted:
Sep 16, 2008 4:00 AM
in response to: Pavan - a DBA
|
|
|
Hi,
Yes in the case of distributed databases,using pfile we can statup dbs with client side pfile as well.See here,
The Location of the Initialization Parameter File in Distributed Environments
The client you use to access the database must be able to read a database's initialization parameter file to start a database's instance. Therefore, always store a database's parameter file on the computer executing the client.
In non-distributed processing installations, the same computer executes Oracle and the client. This computer already has the parameter file stored on one of its disk drives. In distributed processing installations, however, local client workstations can administer a database stored on a remote machine. In this type of configuration, the local client machines must each store a copy of the parameter file for the corresponding databases.
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/start.htm#6439
HTH
Aman.... |
|
|
|
Legend
|
|
Guru : 2500
- 1000000
pts
|
|
Expert : 1000
- 2499
pts
|
|
Pro : 500
- 999
pts
|
|
Journeyman : 200
- 499
pts
|
|
Newbie : 0
- 199
pts
|
|
Oracle ACE Director
|
|
Oracle ACE Member
|
|
Oracle Employee ACE
|
|
|
Helpful Answer
(5 pts)
|
|
Correct Answer
(10 pts)
|
|
