set feedback off set pagesize 70; set linesize 2000 set head on COLUMN Tablespace format a25 heading ‘Tablespace Name’ COLUMN autoextensible format a11 heading ‘AutoExtend’ COLUMN files_in_tablespace format 999 heading… Read more »
How to check if tablespaces datafiles are autoextend col FILE_NAME for a60 select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from dba_Data_files where TABLESPACE_NAME like ‘Tablespace_Name’; _________________________________________________________________________________________________________________________ col FILE_NAME for a60 select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from… Read more »
Database and server details Report from OEM: Database version and Server Details 1- How do I get the number of databases for each category version? SELECT property_value, COUNT(*) FROM mgmt$target_properties… Read more »
Convert Single Instance database to 2 Node RAC Convert Single Instance Database to 2 Node RAC oracle 10g / 11g. Install Clusterware on the nodes on which you want to… Read more »
Oracle database management scripts- Check how large size of the database col “Database Size” format a20 col “Free space” format a20 col “Used space” format a20 select round(sum(used.bytes) / 1024… Read more »
RAC SRVCTL and CRSCTL useful commands- Below are some of the commands which we have used regularly in our RAC system. There are many more RAC commands for 11gR2/12c Clusterware… Read more »
Convert Physical Standby Database to Snapshot standby Database The difference between a read-only standby and a snapshot standby is that the snapshot standby is fully update-able. It was possible in… Read more »
What is datapump in oracle Data Pump: Data pump is a utility provided by Oracle to export data and/or structure from a database into a binary file called as dump… Read more »
How to check tablespace size in oracle database set linesize 150 set pagesize 5000 col owner for a15 col segment_name for a30 col segment_type for a20 col TABLESPACE_NAME for a30… Read more »
Check user status in oracle database Here with the use of below scripts you can check the status of particular user whether is open/locked or expired , you can check… Read more »