{"id":1359,"date":"2026-08-21T08:08:56","date_gmt":"2026-08-21T14:08:56","guid":{"rendered":"https:\/\/folken-it.com\/?p=1359"},"modified":"2026-08-21T08:31:35","modified_gmt":"2026-08-21T14:31:35","slug":"como-agregar-un-datafile-a-un-tablespace-en-oracle-database","status":"publish","type":"post","link":"https:\/\/folken-it.com\/?p=1359","title":{"rendered":"C\u00f3mo agregar un Datafile a un Tablespace en Oracle Database"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Cuando un <strong>tablespace de Oracle comienza a quedarse sin espacio<\/strong>, una de las alternativas disponibles para incrementar su capacidad es agregar un nuevo <strong>datafile<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aunque el comando <code>ALTER TABLESPACE ... ADD DATAFILE<\/code> es sencillo, en producci\u00f3n no deber\u00edamos ejecutarlo autom\u00e1ticamente al recibir una alerta de espacio. Primero debemos determinar <strong>por qu\u00e9 est\u00e1 creciendo el tablespace, cu\u00e1nto espacio queda disponible y cu\u00e1l es la mejor estrategia de expansi\u00f3n<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En esta gu\u00eda veremos los comandos m\u00e1s utilizados.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Importante:<\/strong> Los ejemplos son educativos. Antes de agregar, redimensionar o modificar datafiles en producci\u00f3n, verifica la capacidad del filesystem o ASM, los est\u00e1ndares de tu organizaci\u00f3n, backups y procedimientos de Change Management.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">1. Tablespace vs. Datafile<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Recordemos la relaci\u00f3n:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Oracle Database\n       \u2502\n       \u251c\u2500\u2500 Tablespace APP_DATA\n       \u2502        \u2502\n       \u2502        \u251c\u2500\u2500 app_data01.dbf\n       \u2502        \u251c\u2500\u2500 app_data02.dbf\n       \u2502        \u2514\u2500\u2500 app_data03.dbf\n       \u2502\n       \u2514\u2500\u2500 Tablespace APP_INDEX\n                \u2502\n                \u2514\u2500\u2500 app_index01.dbf<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">El <strong>tablespace es una estructura l\u00f3gica<\/strong>, mientras que los <strong>datafiles representan almacenamiento f\u00edsico<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Un tablespace puede utilizar uno o varios datafiles.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">2. Consultar los Tablespaces<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Antes de modificar cualquier cosa:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT    tablespace_name,    status,    contents,    extent_management,    segment_space_managementFROM dba_tablespacesORDERBY tablespace_name;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Para consultar uno espec\u00edfico:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    tablespace_name,    status,    contentsFROM dba_tablespacesWHERE tablespace_name ='APP_DATA';<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Queremos confirmar que estamos trabajando con el tablespace correcto.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">3. Consultar los Datafiles actuales<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Uno de los comandos m\u00e1s importantes:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    file_id,    tablespace_name,    file_name,    ROUND(bytes\/1024\/1024\/1024,2) AS size_gb,    autoextensible,    ROUND(maxbytes\/1024\/1024\/1024,2) AS max_gbFROM dba_data_filesWHERE tablespace_name ='APP_DATA'ORDERBY file_id;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Podr\u00edamos encontrar:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">FILE_ID  TABLESPACE  FILE_NAME                         SIZE_GB  AUTO  MAX_GB-------  ----------  --------------------------------  -------  ----  ------7        APP_DATA    \/u01\/oradata\/PROD\/app_data01.dbf   20.00   YES    30.008        APP_DATA    \/u01\/oradata\/PROD\/app_data02.dbf   20.00   YES    30.00<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Esto nos permite conocer:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>n\u00famero de datafiles;<\/li>\n\n\n\n<li>tama\u00f1o actual;<\/li>\n\n\n\n<li>ubicaci\u00f3n;<\/li>\n\n\n\n<li><code>AUTOEXTEND<\/code>;<\/li>\n\n\n\n<li>capacidad m\u00e1xima.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">4. Consultar el espacio libre<\/h1>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    tablespace_name,    ROUND(SUM(bytes)\/1024\/1024\/1024,2) AS free_gbFROM dba_free_spaceWHERE tablespace_name ='APP_DATA'GROUPBY tablespace_name;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Pero no deber\u00edamos limitarnos \u00fanicamente al porcentaje utilizado.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tambi\u00e9n debemos revisar la <strong>capacidad m\u00e1xima considerando AUTOEXTEND<\/strong>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">5. Identificar qu\u00e9 est\u00e1 consumiendo el espacio<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Antes de agregar almacenamiento:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    owner,    segment_name,    segment_type,    ROUND(bytes\/1024\/1024\/1024,2) AS size_gbFROM dba_segmentsWHERE tablespace_name ='APP_DATA'ORDERBY bytes DESCFETCHFIRST20ROWSONLY;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Esto puede revelar que el crecimiento proviene de:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">TABLEINDEXLOBSEGMENTLOBINDEXTABLE PARTITIONINDEX PARTITION<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">La pregunta importante es:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>\u00bfPor qu\u00e9 est\u00e1 creciendo el tablespace?<\/strong><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Podr\u00eda tratarse de crecimiento normal, cargas masivas, procesos batch, \u00edndices, LOBs, problemas de retenci\u00f3n o un comportamiento anormal de la aplicaci\u00f3n.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">6. Verificar espacio f\u00edsico disponible<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Si utilizamos filesystem, debemos comprobar primero la capacidad disponible desde Linux:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df -h<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Para una ubicaci\u00f3n espec\u00edfica:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df -h \/u01<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Tambi\u00e9n:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df -h \/u01\/oradata\/PROD<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">No tiene sentido resolver un problema de tablespace provocando otro problema en el filesystem.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Conceptualmente:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Tablespace    \u2193Datafile    \u2193Filesystem \/ ASM    \u2193Storage f\u00edsico<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">7. Agregar un nuevo Datafile<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Supongamos:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Tablespace: APP_DATANuevo archivo: app_data03.dbfTama\u00f1o: 10 GB<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">El comando b\u00e1sico ser\u00eda:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE APP_DATAADD DATAFILE '\/u01\/oradata\/PROD\/app_data03.dbf'SIZE10G;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Despu\u00e9s verificamos:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    file_id,    file_name,    ROUND(bytes\/1024\/1024\/1024,2) AS size_gbFROM dba_data_filesWHERE tablespace_name ='APP_DATA'ORDERBY file_id;<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">8. Agregar Datafile con AUTOEXTEND<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Una configuraci\u00f3n m\u00e1s completa:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE APP_DATAADD DATAFILE '\/u01\/oradata\/PROD\/app_data03.dbf'SIZE10GAUTOEXTEND ONNEXT1GMAXSIZE 50G;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Significa:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SIZE 10G   \u2502   \u2514\u2500\u2500 Tama\u00f1o inicialAUTOEXTEND ON   \u2502   \u2514\u2500\u2500 Crecimiento autom\u00e1ticoNEXT 1G   \u2502   \u2514\u2500\u2500 Incrementos de 1 GBMAXSIZE 50G   \u2502   \u2514\u2500\u2500 Tama\u00f1o m\u00e1ximo<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Esta configuraci\u00f3n permite que Oracle ampl\u00ede autom\u00e1ticamente el datafile hasta el l\u00edmite establecido.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">9. Agregar un Datafile sin l\u00edmite expl\u00edcito<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Tambi\u00e9n existe:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE APP_DATAADD DATAFILE '\/u01\/oradata\/PROD\/app_data03.dbf'SIZE10GAUTOEXTEND ONNEXT1GMAXSIZE UNLIMITED;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Sin embargo, <code>UNLIMITED<\/code> <strong>no significa que exista almacenamiento infinito<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">El crecimiento contin\u00faa dependiendo de l\u00edmites de Oracle, filesystem, ASM y almacenamiento f\u00edsico.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En producci\u00f3n suele ser preferible establecer l\u00edmites deliberados y monitorearlos.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">10. Agregar un Datafile utilizando ASM<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Si Oracle utiliza ASM:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE APP_DATAADD DATAFILE '+DATA'SIZE10GAUTOEXTEND ONNEXT1GMAXSIZE 50G;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Cuando se utilizan Oracle Managed Files, Oracle puede generar autom\u00e1ticamente el nombre correspondiente.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">La arquitectura podr\u00eda verse as\u00ed:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">APP_DATA    \u2502    \u251c\u2500\u2500 +DATA\/PROD\/DATAFILE\/...    \u251c\u2500\u2500 +DATA\/PROD\/DATAFILE\/...    \u2514\u2500\u2500 +DATA\/PROD\/DATAFILE\/...              \u2502              \u2193         ASM Disk Group<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">11. Verificar capacidad de ASM<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Si utilizamos ASM podemos consultar, con los privilegios y contexto adecuados:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    name,    total_mb,    free_mb,    usable_file_mbFROM v$asm_diskgroup;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Es importante no limitarse a comprobar que <code>+DATA<\/code> existe.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Debemos verificar que tenga <strong>capacidad utilizable suficiente<\/strong>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">12. Agregar varios Datafiles<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Tambi\u00e9n podemos agregar varios archivos:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE APP_DATAADD DATAFILE'\/u01\/oradata\/PROD\/app_data03.dbf'SIZE10G,'\/u02\/oradata\/PROD\/app_data04.dbf'SIZE10G;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">La conveniencia de distribuirlos entre diferentes ubicaciones depende de la arquitectura de almacenamiento.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">13. \u00bfAgregar Datafile o hacer RESIZE?<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Agregar otro datafile no siempre es la mejor opci\u00f3n.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primero revisamos:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    file_name,    ROUND(bytes\/1024\/1024\/1024,2) AS size_gb,    autoextensible,    ROUND(maxbytes\/1024\/1024\/1024,2) AS max_gbFROM dba_data_filesWHERE tablespace_name ='APP_DATA';<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Si un archivo puede crecer, podr\u00edamos hacer:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER DATABASE DATAFILE'\/u01\/oradata\/PROD\/app_data01.dbf'RESIZE 30G;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Por tanto:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Tablespace casi lleno        \u2502        \u251c\u2500\u2500 \u00bfDatafile puede crecer?        \u2502        \u2193        \u2502      RESIZE        \u2502        \u251c\u2500\u2500 \u00bfAUTOEXTEND puede ampliarse?        \u2502        \u2193        \u2502   Modificar MAXSIZE        \u2502        \u2514\u2500\u2500 \u00bfNecesitamos capacidad adicional?                 \u2193            ADD DATAFILE<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">14. Habilitar AUTOEXTEND en un Datafile existente<\/h1>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER DATABASE DATAFILE'\/u01\/oradata\/PROD\/app_data01.dbf'AUTOEXTEND ONNEXT1GMAXSIZE 50G;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Comprobamos:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    file_name,    autoextensible,    ROUND(bytes\/1024\/1024\/1024,2) AS size_gb,    ROUND(maxbytes\/1024\/1024\/1024,2) AS max_gbFROM dba_data_filesWHERE tablespace_name ='APP_DATA';<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">15. Deshabilitar AUTOEXTEND<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Tambi\u00e9n podemos desactivarlo:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER DATABASE DATAFILE'\/u01\/oradata\/PROD\/app_data01.dbf'AUTOEXTEND OFF;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Esto puede formar parte de determinadas pol\u00edticas de capacity management.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">16. TEMP utiliza TEMPFILE<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Esta es una diferencia importante.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Para un tablespace permanente usamos:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE APP_DATAADD DATAFILE ...<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Para un temporary tablespace:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE TEMPADD TEMPFILE '\/u01\/oradata\/PROD\/temp02.dbf'SIZE10GAUTOEXTEND ONNEXT1GMAXSIZE 50G;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Recuerda:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Permanent Tablespace        \u2193DATAFILETemporary Tablespace        \u2193TEMPFILE<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Los tempfiles se consultan mediante:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    tablespace_name,    file_name,    ROUND(bytes\/1024\/1024\/1024,2) AS size_gb,    autoextensibleFROM dba_temp_files;<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">17. Verificar inmediatamente despu\u00e9s del cambio<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Despu\u00e9s de agregar un datafile:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    file_id,    tablespace_name,    file_name,    ROUND(bytes\/1024\/1024\/1024,2) AS size_gb,    autoextensible,    ROUND(maxbytes\/1024\/1024\/1024,2) AS max_gbFROM dba_data_filesWHERE tablespace_name ='APP_DATA'ORDERBY file_id;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Tambi\u00e9n comprobamos nuevamente el espacio disponible.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Y desde el sistema operativo:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">df -h \/u01<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">No debemos considerar terminado el cambio simplemente porque Oracle respondi\u00f3:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Tablespace altered.<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Debemos <strong>validar el resultado<\/strong>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">18. Algunos errores que podemos encontrar<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Cuando Oracle no puede extender un segmento podemos encontrar errores como:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ORA-01653:unable to extend table ...<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Para \u00edndices:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ORA-01654:unable to extend index ...<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Estos errores indican un problema para asignar nuevos extents, pero no significan autom\u00e1ticamente:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">&#8220;Agrega un datafile.&#8221;<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Debemos investigar la causa.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">19. Comandos esenciales para memorizar<\/h1>\n\n\n\n<h3 class=\"wp-block-heading\">Ver datafiles<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT    file_id,    tablespace_name,    file_name,    bytes,    autoextensible,    maxbytesFROM dba_data_files;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Agregar Datafile<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE APP_DATAADD DATAFILE '\/u01\/oradata\/PROD\/app_data03.dbf'SIZE10G;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Agregar con AUTOEXTEND<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE APP_DATAADD DATAFILE '\/u01\/oradata\/PROD\/app_data03.dbf'SIZE10GAUTOEXTEND ONNEXT1GMAXSIZE 50G;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ASM<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE APP_DATAADD DATAFILE '+DATA'SIZE10GAUTOEXTEND ONNEXT1GMAXSIZE 50G;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Resize<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER DATABASE DATAFILE'\/u01\/oradata\/PROD\/app_data01.dbf'RESIZE 30G;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Modificar AUTOEXTEND<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER DATABASE DATAFILE'\/u01\/oradata\/PROD\/app_data01.dbf'AUTOEXTEND ONNEXT1GMAXSIZE 50G;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">TEMP<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE TEMPADD TEMPFILE '\/u01\/oradata\/PROD\/temp02.dbf'SIZE10GAUTOEXTEND ONNEXT1GMAXSIZE 50G;<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">20. Flujo recomendado ante una alerta<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Supongamos que recibimos:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>&#8220;APP_DATA tablespace is 95% full.&#8221;<\/strong><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Una buena metodolog\u00eda ser\u00eda:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Alerta: Tablespace 95%           <br>\u21931. Verificar utilizaci\u00f3n real           <br>\u21932. Revisar Datafiles           <br>\u21933. Revisar AUTOEXTEND \/ MAXSIZE           <br>\u21934. Identificar segmentos que crecen           <br>\u21935. Revisar tendencia hist\u00f3rica           <br>\u21936. Verificar filesystem \/ ASM           <br>\u21937. Determinar acci\u00f3n       <br>       \u2199       \u2193        \u2198    <br>    RESIZE  AUTOEXTEND  ADD DATAFILE       <br>       \u2198       \u2193        \u2199           <br>            Ejecutar              <br>               \u2193           <br>            Verificar              <br>               \u2193          <br>           Monitoring              <br>               \u2193      <br>      Capacity Planning \/ RCA<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Buenas pr\u00e1cticas<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Antes de agregar un nuevo datafile, conviene preguntarnos:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\u2713 \u00bfCu\u00e1l es la utilizaci\u00f3n real del tablespace?<br>\u2713 \u00bfQu\u00e9 objetos est\u00e1n consumiendo espacio?<br>\u2713 \u00bfEl crecimiento es normal o anormal?\u2713 \u00bfLos datafiles actuales tienen AUTOEXTEND?\u2713 \u00bfCu\u00e1l es su MAXSIZE?<br>\u2713 \u00bfPuedo ampliar un datafile existente?<br>\u2713 \u00bfExiste espacio suficiente en filesystem o ASM?<br>\u2713 \u00bfCu\u00e1l es la tendencia de crecimiento?<br>\u2713 \u00bfEl nuevo datafile cumple los est\u00e1ndares de nombres?<br>\u2713 \u00bfTenemos monitoring despu\u00e9s del cambio?<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">El comando:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE APP_DATA ADD DATAFILE ...<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">puede resolver r\u00e1pidamente un problema de capacidad.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pero un administrador Oracle deber\u00eda evitar convertirlo en una soluci\u00f3n autom\u00e1tica.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Si un tablespace aumenta 100 GB cada semana, <strong>agregar 100 GB adicionales solamente pospone el problema<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">La verdadera administraci\u00f3n comienza cuando preguntamos:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>\u00bfPor qu\u00e9 est\u00e1 creciendo?<\/strong><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Comprender la diferencia entre <strong>capacidad disponible, utilizaci\u00f3n, AUTOEXTEND, MAXSIZE, crecimiento de segmentos y almacenamiento f\u00edsico<\/strong> nos permite resolver el problema actual y, al mismo tiempo, prevenir el siguiente.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u00bfQu\u00e9 revisas primero cuando recibes una alerta indicando que un tablespace de Oracle est\u00e1 al 95%?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cuando un tablespace de Oracle comienza a quedarse sin espacio, una de las alternativas disponibles para incrementar su capacidad es agregar un [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1360,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[56,55],"tags":[],"class_list":["post-1359","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-oracle"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/folken-it.com\/wp-content\/uploads\/2026\/08\/datafile.png?fit=1024%2C1536&ssl=1","_links":{"self":[{"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/posts\/1359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/folken-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1359"}],"version-history":[{"count":1,"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/posts\/1359\/revisions"}],"predecessor-version":[{"id":1361,"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/posts\/1359\/revisions\/1361"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/folken-it.com\/index.php?rest_route=\/wp\/v2\/media\/1360"}],"wp:attachment":[{"href":"https:\/\/folken-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folken-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folken-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}