Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • How to analyze statspack or AWR report. Oracle
  • create trigger syntax Oracle
  • To Find Orphan OS processes. Linux/Unix
  • How to find password change date for user Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • Jai Shree Ram Oracle
  • Finding locked objects Oracle
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
  • Order by with ROWNUM Oracle
  • Linux CPU info. Linux/Unix
  • sqlnet.ora paramters Oracle
  • upload.html PHP/MYSQL/Wordpress
  • Which environment is used by currently running process ( Very good) Linux/Unix
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle

Flowers Resize datafiles

Posted on 02-Mar-2006 By Admin No Comments on Flowers Resize datafiles

In flowers we resize datafile using following command:

alter database resize datafile ‘/path1/filename.dbf’ resize 500M;

this will change that datafles ‘SIZE’ column and allocate that much space for that datafile. If you are having standby database pls make sure that enough space is available for that file expansion.

Oracle, rman-dataguard

Post navigation

Previous Post: age_alert.ksh aging out alert.log
Next Post: Create type and Grant on it.

Related Posts

  • Virtual Indexes in Oracle Oracle
  • Another Tuning Article for subheap of shared pool Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • Building Our Own Namespaces with “Create Context” Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Vivek Tuning for Row Locks. Oracle
  • Find Multiple levels of object dependencies : depen.sql Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • Benefits and Usage of RMAN with Standby Databases Oracle
  • Deleting first line and lastline of a file using sed Linux/Unix
  • oracle 11g RAC on vmware Oracle
  • How to choose Driver table in SQL statement Oracle
  • Database logon trigger issue Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme