OraFAQ Forum: Server Administration » Share tablespace between OLTP and OLAP

Home » RDBMS Server » Server Administration » Share tablespace between OLTP and OLAP (Oracle 11gR2/12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Share tablespace between OLTP and OLAP [message #641199]

Tue, 11 August 2015 16:05

ravikanth_b
Messages: 42
Registered: November 2007
Location: Bay Area, CA

Member

Hello experts,

Do you see any down side of putting OLAP and OLTP objects in one single tablespace? performance, maintainability or otherwise?

Thanks!

Report message to a moderator

Re: Share tablespace between OLTP and OLAP [message #641204 is a reply to message #641199]

Tue, 11 August 2015 18:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://community.oracle.com/thread/3779593

Report message to a moderator

Re: Share tablespace between OLTP and OLAP [message #641205 is a reply to message #641204]

Tue, 11 August 2015 19:29

ravikanth_b
Messages: 42
Registered: November 2007
Location: Bay Area, CA

Member

Thanks for the URL, that is me who posted the question on that forum.

Report message to a moderator

Re: Share tablespace between OLTP and OLAP [message #641206 is a reply to message #641199]

Tue, 11 August 2015 21:46

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Some people might say that you could set the tablespace uniform extent size, block size, or allocation unit size per tablespace in an attemot to tune it to the pattern of activity you expect. I wouldn't.

You might want to consider the granularity of tablespace point in time recovery.

I can't think of anything else.

Report message to a moderator

Re: Share tablespace between OLTP and OLAP [message #641211 is a reply to message #641206]

Tue, 11 August 2015 23:14

ravikanth_b
Messages: 42
Registered: November 2007
Location: Bay Area, CA

Member

Thanks John for your inputs.

Report message to a moderator

Previous Topic:	Ora-01031 error when reading Oracle SGA
Next Topic:	IDLE_TIME terminates the JDBC connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 12:15:34 CDT 2025