| Read only schema [message #384457] |
Tue, 03 February 2009 23:14  |
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  |
 |
Michel Cadot
Messages: 68666
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
