skip to main | skip to sidebar

Naveen - The Oracle DBA

Interesting Oracle tips from own experience and from the internet

Wednesday, August 13, 2008

Find the Tablespace usage/freespace information

Tablespace size

Newer Post Older Post Home

Blog Archive

► 2009 (10)
- ► Jul (1)
- ► Feb (5)
- ► Jan (4)

▼ 2008 (59)
- ► Dec (5)
- ► Oct (2)
- ► Sep (1)
- ▼ Aug (5)
- ► Jul (3)
- ► Apr (3)
- ► Mar (12)
- ► Feb (18)
- ► Jan (10)

Bookmarks

Dictionary Free Online Dictionary, Thesaurus and Encyclope...
Oracle DBA InfoPower Home Page
Oracle:Concepts Oracle Processes List - Background and Foreground Nested loops, Hash join and Sort Merge joins – ...
Oracle:Forums and Discussion Groups Oracle Applications DBA Security Compliance Pro... Oracle DBA Forums (Powered by Invision Power Bo...
Oracle:Hot Topics Ignoring, Locking, and Parsing Becoming the Master of Disaster Tuning Understanding Optimization Failover and Load balancing in Oracle Oracle FAQ Using Oracle data buffer cache Advice Redo Byte Address - knowing SCN for restore whe... Installing the April 2007 Critical Patch Update on Windows Oracle FAQ Flashback for OCPs SQL Developer Extending Oracle SQL Developer Joins and Query Plans
Oracle:Labs DBA SIUE Lab 4 Conversion - Database
Oracle:Labs:ASM ASM manual installation
Oracle:Labs:Convert Database across platforms CONVERT
Oracle:Labs:DataPump Import data via a network link in Oracle 10g DataPump export import scripts
Oracle:Labs:RAC Convert a Single Instance Database to Oracle RA...
Oracle:Labs:Rman backup and recovery OraFusion.com - Oracle Backup and Recovery usin... OraFusion.com - Oracle Backup and Recovery usin... The Eric S. Emrick Blog Backup Control Files - ... OraFusion.com - Oracle Backup and Recovery usin...
Oracle:Labs:Standby Database Dataguard How to create Datafiles in a Data Guard (10g) e... SQL Statements Relevant to Data Guard Role Transitions Failover Switchover Data Guard Scenarios Data Guard, Physical Standby Creation, step by ... Introduction to Oracle Data Guard Creating a physical standby database - dataguard SQL Statements Oracle Rant » High Availability and Flexibility with Data Guard Dataguard Configuration Best Practices Adventures With Oracle ORA-12519 and ORA-01012 ... Failovers with Oracle Dataguard using DGMGRL Cloning Database on Same Machine on Windows wit... Views Relevant to Oracle Data Guard
Oracle:Linux Unix bash commands - MAN Pages Shell Command Language OpenVMS Commands with unix equivalents Linux Commands 2 Linux Shell Scripting for DBAs Oracle server locate file UNIX find ls command ... Brute force attack Unix Commands on Different OS's Veritas Cluster Server VCS for DB2 Database for... Linux commands 1 vi Editor Commands Solaris Volume Manager installation and adminis... awk UNIX Shell Programming Introduction to UNIX OS Perl Logic - Linux Programming
Oracle:Oracle Documentation Flashback Database A Primer Oracle FAQ Oracle 10g R2 - Concepts Oracle 10g R2 - Performance Tuning Oracle 10g R2 - Online Doc Home High Availability Architectures Oracle 10g R2 - Reference
Oracle:Questionnair Technical Interview Questions - Part1 Oracle FAQ Oracle Backup and Recovery Oracle Interview Questions and Answers ALL Int... Technical Interview Questions - Part 1 - 0 Technical Interview Questions - Index Oracle Database Question Bank Free Java Tutorials Certifying DBA Performance Tuning - Inside OCP OraFAQ Oracle DBA Technical Interview Questions - Part 2 DBA Interview question by dbapool.com OCP related doubts ...
Oracle:Standards Port Numbers DB Creation Various server releases Features
Oracle:Tips and Articles Oracle Tips index Oracle Online Help Tips Materialized views (snapshots) ORACLE - DBA Scripts PSOUG Oracle Morgan's Library SQL PL-SQL Materialized Views Tips Dynamic SGA features of Oracle9i Oracle Tips - Rampant Techpress A Closer Look at ADDM - Kim Floss Rampant author articles Oracle Tips - Remote DBA Optimizing Oracle RAM for SGA & PGA sizing On AWR
Oracle:Tips and Articles:Listen Software - How To-s DBAsupport.com Oracle 9i Central Oracle Techn... interview questions Oracle dba - Google Search Naveen - The Oracle DBA Search results for unix... Oracle Series OCP related doubts ... questionnaire oracle dba - Google Search
Oracle:Tips and Articles:Tuning Oracle tuning steps SQL statements Oracle SQL hints Oracle myth busters index rebuild disk io wait ... Bad SQL design Analyzing a Statspack Report Instance Tuning Wait events with v$system views dbms_stats Oracle SQL performance Verifying if an index is used Oracle SQL Tuning Secret Tips ADDM The Oracle Database Advisors, Part 2 Rober... Control file reads & writes Reclaiming free space fragments - Fragmentation STATSPACK - Automatic Workload Repository (AWR) v$lock wait events Instance Tuning Using Performance Views 10g Oracle SQL undocumented tuning hints What’s Up With dbms_stats AWR The Oracle Database Advisors, Part 1 Robert... Oracle SQL Tuning Pocket Reference Excerpt The ...
Oracle:Tips and Articles:Tuning:Informatica Kirtan Desai » Blog Archive » Informatica Perfo... Informatica
Oracle:Tips and Articles:Tuning:Migration Upgrade Oracle 10g migration tuning tips FreeLists - oracle-l - RE Oracle 10g upgrade - ...
Oracle:Toolkit Advanced Oracle Performance Tuning Scripts TraceAnalyzer tkprof - Trace file reader Toolkit - Natalka's Oracle DBA Script and Code - Oracle FAQ Trace Analyzer Oracle Commands - Quick Reference Scripts www.peasland.net
Oracle:Toolkit:Data Pump Oracle Data Pump - Part I Oracle FAQ Oracle Data Pump - Part III Oracle FAQ Compressing and splitting a huge export file in... Oracle Data Pump - Part II Oracle FAQ
Oracle:Toolkit:Migration Creating a Physical Standby Database Upgrading to the New Oracle Database 10g Release Convert Datafiles using RMAN - Tablespace Conve...
Oracle:Toolkit:Scripts Shell Scripts
Personal:Driving Palo Alto Daily News How to Prepare for Your Driving Test
Personal:Job Net-Temps Job Sites
Unlabeled O'Reilly Media | Oracle SQL Tuning Pocket Refer... This book is a quick-reference guide for tuning Oracle SQL. ..... DBMS_STATS has a GATHER STALE option that will only analyze tables that have had more than ... Blogger: Naveen - The Oracle DBA - Edit Post "D...

Labels

About Me

Naveen Prabhu

View my complete profile