02-13-2007
Display size
Hi Friends,
I'm a Oracle Dba first time working in Solaris, i have worked on linux (redhat). I want to see the size of the particular directory e.g oracle and also the size of the database files.
Thank you
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How can I display the size of a directory and contents witin a directory
df only gives me the mounts (3 Replies)
Discussion started by: t4st33@mac.com
3 Replies
2. Shell Programming and Scripting
Hi Genius,
I would like to display filesystem size that cross 75% as used using df -k.
I would thank in advance for your answer.
Thanks and Regards,
HAA (2 Replies)
Discussion started by: HAA
2 Replies
3. AIX
Hi,
How can i increase the size of my display on AIX 5.3.What i mean is e.g if i do and ps -ef i would get some like:
/data/app/oracle/product/10.2
/usr/bin/ksh /usr/local/bin/s
i want it to show the whole thing on the screen without cutting it,because there is still space on the screen... (0 Replies)
Discussion started by: sellafrica1
0 Replies
4. UNIX for Dummies Questions & Answers
Hi all,
Is there any built in function that can display the content of a directory showing the size of directories?
I want to see the content of a directory without recursion. I don't want to see the content of all subdirectories.
I want to see the contained files with their size and the... (6 Replies)
Discussion started by: chebarbudo
6 Replies
5. Shell Programming and Scripting
Hi,
I am new to Unix.
I want to display top 10 folders by size.
I tried with
du -ksl * | sort -nr | head -10
command .But I am getting the following error
-bash: /usr/bin/du: Argument list too long
Can some one help me.
Thanks. (5 Replies)
Discussion started by: Satyak
5 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I want to display all the directories with ascending order in size. For example,
$ du -k .
1111111 ./dir1
222222222 ./dir2
333333333 ./dir3
444444444 ./dir4
How do i get the above desired result with du -k . command?
Thanks (1 Reply)
Discussion started by: welldone
1 Replies
7. Shell Programming and Scripting
Suppose there are 3 files inside a directory, then i need to use display command which will display, the file name and its size. Is it possible?
The output should llook like this only
file1 1248
file2 3024
file3 3056 (6 Replies)
Discussion started by: sundaresanv
6 Replies
8. Shell Programming and Scripting
Hello, all!
Working in a Bourne shell. What command would list the filename and size of a file if the size of the file had to be bigger than $a and smaller than $b?
Output (if $a is 10 bytes and $b is 50 bytes):test1.txt 15
test2.txt 30
test3.txt 50
Thanks,
Ann :p (3 Replies)
Discussion started by: LowlyIntern
3 Replies
9. Debian
Hello,
I am running Debian 6.0 on a Sun Ultra 5 and the openbox window manager. The window is way larger than the screen and minimized icons go off the screen and I can't get them back. The mode is set to 1280x1024 in the Screen section of xorg.conf and Virtual is also set to 1280x1024 which is... (4 Replies)
Discussion started by: snorkack59
4 Replies
10. UNIX for Dummies Questions & Answers
help me (1 Reply)
Discussion started by: sonu pandey
1 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::oracle
DBIx::SearchBuilder::Handle::Oracle(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::Oracle(3pm)
NAME
DBIx::SearchBuilder::Handle::Oracle - An oracle specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
Connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
BuildDSN
Customized version of "BuildDSN" in DBIx::SearchBuilder::Handle method.
Takes additional argument SID. Database argument used unless SID provided. Two forms of DSN are generated depending on whether Host
defined or not:
dbi:Oracle:sid=<SID>;host=...[;port=...]
dbi:Oracle:<SID>
Read details in documentation for DBD::Oracle module.
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
InsertFromSelect
Customization of "InsertFromSelect" in DBIx::SearchBuilder::Handle.
Unlike other DBs Oracle needs:
o id generated from sequences for every new record.
o query wrapping in parens.
NOTE that on Oracle there is a limitation on the query. Every column in the result should have unique name or alias, for example the
following query would generate "ORA-00918: column ambiguously defined" error:
SELECT g.id, u.id FROM ...
Solve with aliases:
SELECT g.id AS group_id, u.id AS user_id FROM ...
KnowsBLOBs
Returns 1 if the current database supports inserts of BLOBs automatically. Returns undef if the current database must be informed of BLOBs
for inserts.
BLOBParams FIELD_NAME FIELD_TYPE
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
DistinctQuery STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
BinarySafeBLOBs
Return undef, as Oracle doesn't support binary-safe CLOBS
DatabaseVersion
Returns value of ORA_OCI constant, see "Constants" in DBI.
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT tzname FROM v$timezone_names;
Read Oracle's docs about timezone files:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
perl(1), DBIx::SearchBuilder
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::Oracle(3pm)