OraFAQ Forum: Server Administration » Tablespaces and differing drives (merged)

Home » RDBMS Server » Server Administration » Tablespaces and differing drives (merged)

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

Tablespaces and differing drives (merged) [message #278131]

Fri, 02 November 2007 00:38

dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad

Junior Member

Hi..,
How can I rebuild the tables using another tablespace.
The purpose is my Database is not having the separate tablespaces for Dynamic & Static tables.
These tables are having the bulk data.
So please help me..

Thanks in Advance.

Report message to a moderator

Re: Tables Rebuild using New Tablespace [message #278132 is a reply to message #278131]

Fri, 02 November 2007 00:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>The purpose is my Database is not having the separate tablespaces for Dynamic & Static tables.
What is the difference between Dynamic & Static tables in Oracle & why do these "differences" matter to the user, the application, or anyone?

Report message to a moderator

Re: Tables Rebuild using New Tablespace [message #278133 is a reply to message #278132]

Fri, 02 November 2007 00:54

dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad

Junior Member

I want to move all Lookup tables(Static Tables) into separate tablespace.
These tables won't be more IO(not more insertions regularly) on frequently.

Report message to a moderator

Re: Tables Rebuild using New Tablespace [message #278134 is a reply to message #278131]

Fri, 02 November 2007 01:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I want to move all Lookup tables(Static Tables) into separate tablespace.
WHY?
>These tables won't be more IO(not more insertions regularly) on frequently.
SO?
You suffer from Obsessive Compulsive Tuning Disorder.
Please provide reproducible benchmark that substantiates such movement produces measurable benefits.

Report message to a moderator

Re: Tables Rebuild using New Tablespace [message #278151 is a reply to message #278131]

Fri, 02 November 2007 01:59

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

How can I rebuild the tables using another tablespace.

Alter table ... move ...

Quote:

The purpose is my Database is not having the separate tablespaces for Dynamic & Static tables.

Why? And doesn't this better if you mix them then writes will be better spread?
Actually tablespaces does not matter for performances. Underlying disks are more important.

Regards
Michel

Report message to a moderator

Tablespaces on Different Drives [message #278328 is a reply to message #278131]

Sat, 03 November 2007 01:01

dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad

Junior Member

Hi..,
I have created separate Tablespaces for my
Static(lookup tables) & Dynamic Table(data growing
tables),
but my database is not implemented either S/W or H/W
RAID,

in this case if we implement more than one DBWR(i.e
db_writer_processes=2 in my pfile/spfile)
and keeping those datafiles in different drives(if my
Hard Disk is partitioned)
will it gives the more performance comparatively
normal mode.
OR
if I kept in my Server more than one Hard Disk
at least in this case will I achieve more
performance..?

Thanks in Advance

Report message to a moderator

Re: Tablespaces on Different Drives [message #278334 is a reply to message #278328]

Sat, 03 November 2007 01:25

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is highly dependent on your system, file system, and so on.
If your system/file system support them, dbwr uses asynchroneous IO so most of the time there is no need of multiple dbwr.

As I said, this is highly dependent on your configuration and workload, so there is no definitive answer and you have to try to get the optimal configuration.

Regards
Michel

Report message to a moderator

Re: Tablespaces on Different Drives [message #278335 is a reply to message #278328]

Sat, 03 November 2007 01:41

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

First thing.... database doesn't implement s/w or h/w RAID.

Secondly.. as Michel pointed out.. the performance is highly dependent on your configuration and workload.

--Girish

Report message to a moderator

Previous Topic:	users with different timezone
Next Topic:	ORA-00600

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 18:59:05 CST 2025