Read only schema [message #384457] |
Tue, 03 February 2009 23:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Hi Experts,
I have few quesions:-
1,I have one read only schema used for reporting
purpose.If I split the one read only schema
to 30 read only schemas.Can it impact the performance.
2,Is there any limit on number of schemas in oracle.
3,Is there any way I can see all the sql statements generated
and time of sql generations by these different schemas in 24 hrs time.
Regards,
Varun Punj
[Updated on: Tue, 03 February 2009 23:17] Report message to a moderator
|
|
|
Re: Read only schema [message #384462 is a reply to message #384457] |
Tue, 03 February 2009 23:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1. No, but you may have to resize your SGA
2. No, but space to record them in dictionary
3. No, only (SQL or Net) tracing can guarantee you get ALL statements
Regards
Michel
[Updated on: Tue, 03 February 2009 23:47] Report message to a moderator
|
|
|
|