03-18-2012
to calculate space used you will need to use an Oracle SQL query to do that or you can probably determine it by running du -sg on the files.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How to find the free size currently FileSystem has, on the disk mounted?
I know 'df' lists all the mounted disks, but I am interested to know details
for the filesystem, in which currently I am working. (7 Replies)
Discussion started by: videsh77
7 Replies
2. UNIX for Advanced & Expert Users
Good morning folks!
I'm new here.. trying to find an answer on how to resize filesystem. Need to add some space to c0t0d0s5, /var... Is it possible at all?
JV (9 Replies)
Discussion started by: jvinn
9 Replies
3. AIX
Dear ALL
Today I faced one problem in the file system, during invoking the command #df -k , I saw /usr reached to 95% Used, could any one give advice ?
thanks & regarded (7 Replies)
Discussion started by: magasem
7 Replies
4. Programming
I have the next code, and the output is incosistent, what is the problem:
free blocks: 1201595
block size: 4096
total size(free blocks * block size): 626765824
1201595 * 4096 not is 626765824, what's the problem???
#include <sys/statvfs.h>
#include <stdio.h>
int main(){
... (1 Reply)
Discussion started by: lucaxvu
1 Replies
5. Shell Programming and Scripting
Hi All,
I want to find the percentage occupied by the directory in the file system.
Say, i have the file system
/home/arun/work
under this file system i have the directories
/home/arun/work/yesterday
/home/arun/work/today
/home/arun/work/tomorrow
The size of the file system is... (5 Replies)
Discussion started by: Arunprasad
5 Replies
6. Solaris
Hi
Can anyone explain me how to increase the filesystem size. We can do it when the system is running? It needs an reboot? (8 Replies)
Discussion started by: rogerben
8 Replies
7. AIX
Hi all,
we are usig aix 4.3 and i need to increase the size of "/u01" file sytem which is mounted on logical volume "lv00", but "/u01" file system size is 9 GB and logical volume "lvoo" size 9 GB.how do i increase the size of /u01.do i increase the size of logical volume "lv00" and then... (2 Replies)
Discussion started by: younusdba
2 Replies
8. Solaris
Hi,
We currently have an Oracle database running and it is creating lots of processes in the /proc directory that are 1000M in size. The size of the /proc directory is now reading 26T. How can this be if the root file system is only 13GB?
I have seen this before we an Oracle temp file... (6 Replies)
Discussion started by: sparcman
6 Replies
9. Shell Programming and Scripting
When I do df -h, I see that one of my partitions is out of space.
Then when I do du -h, I get thousands of files. How do I only look at files over a specific size. I want directories over 500m to be returned only. (2 Replies)
Discussion started by: guessingo
2 Replies
10. Solaris
Hi,
I have recently taken up to support these SunOS 5.9 sun4u sparc SUNW,Sun-Fire-V240 boxes and got a request to increase the size of /backup01 as its getting filled up quickly and can't play much on it as these are production servers. As I have no idea about how to do this, can anyone let me... (0 Replies)
Discussion started by: phanidhar6039
0 Replies
LEARN ABOUT PHP
odbc_prepare
ODBC_PREPARE(3) 1 ODBC_PREPARE(3)
odbc_prepare - Prepares a statement for execution
SYNOPSIS
resource odbc_prepare (resource $connection_id, string $query_string)
DESCRIPTION
Prepares a statement for execution. The result identifier can be used later to execute the statement with odbc_execute(3).
Some databases (such as IBM DB2, MS SQL Server, and Oracle) support stored procedures that accept parameters of type IN, INOUT, and OUT as
defined by the ODBC specification. However, the Unified ODBC driver currently only supports parameters of type IN to stored procedures.
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $query_string
- The query string statement being prepared.
RETURN VALUES
Returns an ODBC result identifier if the SQL command was prepared successfully. Returns FALSE on error.
EXAMPLES
Example #1
odbc_execute(3) and odbc_prepare(3) example
In the following code, $success will only be TRUE if all three parameters to myproc are IN parameters:
<?php
$a = 1;
$b = 2;
$c = 3;
$stmt = odbc_prepare($conn, 'CALL myproc(?,?,?)');
$success = odbc_execute($stmt, array($a, $b, $c));
?>
If you need to call a stored procedure using INOUT or OUT parameters, the recommended workaround is to use a native extension for your
database (for example, mssql for MS SQL Server, or oci8 for Oracle).
SEE ALSO
odbc_execute(3).
PHP Documentation Group ODBC_PREPARE(3)