Multiple Temporary Tablespaces

Multiple Temporary Tablespaces

CAMBIAR DEFAULT TABLESPACE SE DEBE CREAR OTRO PRIMERO

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp1;

Database altered.


SQL> SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';


ALTER DATABASE DEFAULT TABLESPACE users;The current settings for the default tablespaces can be viewed using the following query.

COLUMN property_name FORMAT A30
COLUMN property_value FORMAT A30
COLUMN description FORMAT A50
SET LINESIZE 200

SELECT *
FROM database_properties
WHERE property_name like '%TABLESPACE';

PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------------ ------------------------------ --------------------------------------
DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespaceRename Tablespace
Renaming permanent and temporary tablespaces is now allowed in Oracle 10g (except for SYSTEM and SYSAUX) using the following command.

Multiple Temporary Tablespaces

Tablespace groups allow users to use more than one tablespace to store temporary segments. The tablespace group is created implicitly when the first tablespace is assigned to it:

-- Create group by adding existing tablespace.
ALTER TABLESPACE temp TABLESPACE GROUP temp_ts_group;

-- Add a new tablespace to the group.
CREATE TEMPORARY TABLESPACE temp2
TEMPFILE '/u01/app/oracle/oradata/DB10G/temp201.dbf' SIZE 20M
TABLESPACE GROUP temp_ts_group;The tablespaces assigned to a group can be viewed using:

SELECT * FROM dba_tablespace_groups;

GROUP_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TEMP_TS_GROUP TEMP
TEMP_TS_GROUP TEMP2

2 rows selected.Once the group is created it can be assigned just like a tablespace to a user or as the default temporary tablespace:

-- Assign group as the temporary tablespace for a user.
ALTER USER scott TEMPORARY TABLESPACE temp_ts_group;

-- Assign group as the default temporary tablespace.
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp_ts_group;A tablespace can be removed from a group using:

ALTER TABLESPACE temp2 TABLESPACE GROUP '';

SELECT * FROM dba_tablespace_groups;

GROUP_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TEMP_TS_GROUP TEMP

1 row selected.There is no theoretical maximum limit to the number of tablespaces in a tablespace group, but it must contain at least one. The group is implicitly dropped when the last member is removed. The last member of a group cannot be removed if the group is still assigned as the default temporary tablespace. In this example the following must be done to remove the last member from the group.
-- Switch from the group to a specific tablespace.
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;

-- Remove the tablespace from the group.
ALTER TABLESPACE temp TABLESPACE GROUP '';

-- Check the group has gone.
SELECT * FROM dba_tablespace_groups;

no rows selected

Solaris 10

Ver si la Maquina esta Corriendo en 32 Bits o 64 Bits

# isainfo –v


Trabajar con el área de swap

Una de las primeras cosas que vamos a ver, es la forma en la que podemos conocer el estado actual de nuestra área de swap, utilizaremos el comando swap con la opción -s. El comando nos devolverá un resumen del uso actual del área de swap.

(root@huelva)# swap -s
total: 552696k bytes allocated + 580744k reserved = 1133440k used, 2310312k available
(root@huelva)#

Ubuntu 10.04

http://linuxcaceres.blogspot.com/2010/04/cosas-que-hacer-despues-de-instalar.html

http://conecti.ca/2010/04/29/cosas-que-hacer-despues-de-instalar-ubuntu-10-04-lucid-lynx/

http://sliceoflinux.com/2010/05/02/que-hacer-despues-de-instalar-ubuntu-10-04-lts-paso-a-paso/

http://www.argentinawarez.com/programas-gratis/736989-foro-ubuntu-cosas-que-hacer-despues-de-instalar-ubuntu-10-04-a.html

Podemos Optimizar Ubuntu 10.04 tras su instalación, desde consola, así:

sudo apt-get install zenity
wget http://dl.dropbox.com/u/1113424/webupd8/script_ubuntu_10.04_lucid_lynx.sh
chmod +x script_ubuntu_10.04_lucid_lynx.sh
sudo ./script_ubuntu_10.04_lucid_lynx.sh

http://www.subinet.es/contenido-i/guias-y-tips/guias-tips-linux/10-cosas-que-hacer-despues-de-instalar-ubuntu-10-04-lucid/

Limpieza Ubuntu:

Esto es bueno hacerlo cada “X” tiempo para quitar lastre y mantener tu sistema operativo “limpio”, pero sobre todo tras una instalación limpia. Abrimos Terminal y escribimos:

sudo apt-get autoremove

[fuera los paquetes innecesarios]

sudo apt-get autoclean

[fuera las referencias innecesarias]

sudo apt-get clean

[cada vez que descargamos un paquete para ser instalado se guarda en /var/cache/apt/archives/. Con esto limpiamos estos paquetes sin afectar alsistema]