Home » RDBMS Server » Server Administration » Tablespaces and differing drives (merged)
Tablespaces and differing drives (merged) [message #278131] Fri, 02 November 2007 00:38 Go to next message
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.
Re: Tables Rebuild using New Tablespace [message #278132 is a reply to message #278131] Fri, 02 November 2007 00:44 Go to previous messageGo to next message
BlackSwan
Messages: 25049
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?
Re: Tables Rebuild using New Tablespace [message #278133 is a reply to message #278132] Fri, 02 November 2007 00:54 Go to previous messageGo to next message
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.
Re: Tables Rebuild using New Tablespace [message #278134 is a reply to message #278131] Fri, 02 November 2007 01:02 Go to previous messageGo to next message
BlackSwan
Messages: 25049
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.

Re: Tables Rebuild using New Tablespace [message #278151 is a reply to message #278131] Fri, 02 November 2007 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
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
Tablespaces on Different Drives [message #278328 is a reply to message #278131] Sat, 03 November 2007 01:01 Go to previous messageGo to next message
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

Re: Tablespaces on Different Drives [message #278334 is a reply to message #278328] Sat, 03 November 2007 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Tablespaces on Different Drives [message #278335 is a reply to message #278328] Sat, 03 November 2007 01:41 Go to previous message
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
Previous Topic: users with different timezone
Next Topic: ORA-00600
Goto Forum:
  


Current Time: Fri Dec 09 11:42:05 CST 2016

Total time taken to generate the page: 0.18431 seconds