The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Oracle on UNIX box Oracle on UNIX box
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Guide: Build Your Own Oracle Extended RAC Cluster on Oracle VM and Oracle Enterprise iBot Oracle Updates (RSS) 0 10-29-2008 03:10 PM
From ASP.NET to Oracle on unix hoshakhs AIX 2 03-16-2007 04:15 AM
oracle to unix djbilly UNIX for Advanced & Expert Users 1 02-09-2007 03:21 AM
unix for oracle ravi raj kumar UNIX for Dummies Questions & Answers 6 01-03-2007 05:19 AM
Restore of oracle 8i from hp unix 11.0 to HP unix 11i amitb HP-UX 1 05-26-2005 09:44 AM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Bulgarian Greek Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 11-19-2008
iamgeethuj iamgeethuj is offline
Registered User
  
 

Join Date: Apr 2008
Posts: 38
Unhappy Oracle on UNIX box
Hi all,
How to find the usage of Oracle database which is on unix box? Specifically I need to where does this Oracle db stores its data. Please help me

Thanks in advance!!!
Geetha
  #2 (permalink)  
Old 11-19-2008
fpmurphy's Avatar
fpmurphy fpmurphy is offline Forum Staff  
Moderator
  
 

Join Date: Dec 2003
Location: Florida
Posts: 1,924
The installation log may help you. It is generally located at $ORACLE_BASE/oraInventory/logs
  #3 (permalink)  
Old 11-19-2008
Lakris Lakris is offline
Registered User
  
 

Join Date: Oct 2007
Posts: 246
Hi,
You could start by reading up on the fine documentation available on the Oracle site where You download it or accompanied with Your install media?

Otherwise I know that Oracle can have some ideas about their own partition, is that what You are thinking about?

/Lakris
  #4 (permalink)  
Old 11-19-2008
jim mcnamara jim mcnamara is offline Forum Staff  
...@...
  
 

Join Date: Feb 2004
Location: NM
Posts: 5,754
Get a list of filenames
Code:
sqlplus -s username@dbname/password << EOF
set pages 0
set feed off

spool t.lis
select FILE_NAME 
   from DBA_DATA_FILES;
exit
EOF
  #5 (permalink)  
Old 11-20-2008
iamgeethuj iamgeethuj is offline
Registered User
  
 

Join Date: Apr 2008
Posts: 38
Thanks JIM
Closed Thread

Bookmarks

« Calling alias | Any way to grep a string in directories and return the result with diskusage aswell? »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Hybrid Mode Hybrid Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 06:14 PM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0