Home » RDBMS Server » Server Administration » Read only schema (10.2.0.2)
Read only schema [message #384457] Tue, 03 February 2009 23:14 Go to next message
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 messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
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

Re: Read only schema [message #384646 is a reply to message #384462] Wed, 04 February 2009 11:13 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thanks Michel..
Previous Topic: Database shifting
Next Topic: Error while creating Database in 10.2.0.4.0.OS is HP-UX 11.11 (merged 3)
Goto Forum:
  


Current Time: Thu Nov 14 04:55:38 CST 2024