08-23-2012
Quote:
Originally Posted by
thmnetwork
Isn't that just throwing money at the problem rather than fixing it?
If the problem is "not enough memory", the solution is "more memory". It's certainly not the answer to every problem, but Oracle isn't small; if they say 4 gigs isn't enough I believe them.
How much does Oracle cost, versus a few more gigs of memory, anyway?
10 More Discussions You Might Find Interesting
1. Solaris
What command should I be using on Solaris 9 to get an accurate representation of the available physical RAM? (4 Replies)
Discussion started by: dangral
4 Replies
2. Solaris
folks, hows everyone?
just upgraded my laptop running on solaris 10 by adding some extra RAM. I did notice some improvement (increase in speed) but could not be certain the new RAM has been accepted and all is well (was concerned a bit as i almost broke it while installing :-)) and didnt get any... (4 Replies)
Discussion started by: alikun
4 Replies
3. UNIX for Dummies Questions & Answers
Hi
can anyone please help me, how to know RAM specification in unix? (4 Replies)
Discussion started by: palash2k
4 Replies
4. Red Hat
Hi,
On server 64bit Hw Arch , Linux 5.0(32bit) is installed it is showing only 3gb of ram though physical is 16gb
can u give me idea why? (4 Replies)
Discussion started by: manoj.solaris
4 Replies
5. Linux
Hi All,
I installed CentOs on my PC (it has 1 GB of RAM). I see that only 200MB of RAM is being utilized on average but its very slow. Please let me know how do I improve the performance. Is there a way to set the RAM utilization/usage on CentOS.
Thank you (2 Replies)
Discussion started by: jayfriend
2 Replies
6. Linux
Hi
one of our applications that runs on our Linux server leaks memory resulting in Ram that was used by the program not being released back to the operating system once a file has been processed. the result is over a very short period virtual all the memory has been used. an example currently
... (8 Replies)
Discussion started by: treds
8 Replies
7. Solaris
our sparc server has only 1Gb RAM. Since RAM is not very expensive anymore, it seems like a good idea to upgrade it.
will it make server (and database on it) faster?
I hope it would less 'abuse' hard drive.. (6 Replies)
Discussion started by: orange47
6 Replies
8. Red Hat
Dear All,
I have linux Servers where all are having at present 12 Gig RAM.
At present my need is to increase the RAM for atleast another 12 G . ie 12G +12 G ===24 Gig RAM.
But how does i can find out whether my server will support for 24 GiG RAM or is there any way of finding out how... (4 Replies)
Discussion started by: jegaraman
4 Replies
9. Solaris
is there a way to thoroughly test RAM in Solaris10 (SPARC)?
or is boot test good enough? (5 Replies)
Discussion started by: orange47
5 Replies
10. UNIX for Dummies Questions & Answers
hi,
i m working on my ubuntu 12.10 i wanted to update my desktop's RAM. so
kindly let me know how i get below details (thru commands in terminal)
1) what is the processor am using currently
2) what is the RAM am using currently
3) max how much i can upgrade my RAM (4 Replies)
Discussion started by: anandpasunoori
4 Replies
LEARN ABOUT PHP
oci_error
OCI_ERROR(3) OCI_ERROR(3)
oci_error - Returns the last error found
SYNOPSIS
array oci_error ([resource $resource])
DESCRIPTION
Returns the last error found.
The function should be called immediately after an error occurs. Errors are cleared by a successful statement.
PARAMETERS
o $resource
- For most errors, $resource is the resource handle that was passed to the failing function call. For connection errors with
oci_connect(3), oci_new_connect(3) or oci_pconnect(3) do not pass $resource.
RETURN VALUES
If no error is found, oci_error(3) returns FALSE. Otherwise, oci_error(3) returns the error information as an associative array.
oci_error(3) Array Description
+----------+--------------------------------------+---+
|Array key | | |
| | | |
| | Type | |
| | | |
| | Description | |
| | | |
+----------+--------------------------------------+---+
| | | |
| code | | |
| | | |
| | | |
| | integer | |
| | | |
| | The Oracle error number. | |
| | | |
| | | |
| message | | |
| | | |
| | | |
| | string | |
| | | |
| | The Oracle error text. | |
| | | |
| | | |
| offset | | |
| | | |
| | | |
| | integer | |
| | | |
| | The byte position of an error in | |
| | the SQL statement. If there was no | |
| | statement, this is 0 | |
| | | |
| | | |
| sqltext | | |
| | | |
| | | |
| | string | |
| | | |
| | The SQL statement text. If there | |
| | was no statement, this is an empty | |
| | string. | |
| | | |
+----------+--------------------------------------+---+
EXAMPLES
Example #1
Displaying the Oracle error message after a connection error
<?php
$conn = oci_connect("hr", "welcome", "localhost/XE");
if (!$conn) {
$e = oci_error(); // For oci_connect errors do not pass a handle
trigger_error(htmlentities($e['message']), E_USER_ERROR);
}
?>
Example #2
Displaying the Oracle error message after a parsing error
<?php
$stid = oci_parse($conn, "select ' from dual"); // note mismatched quote
if (!$stid) {
$e = oci_error($conn); // For oci_parse errors pass the connection handle
trigger_error(htmlentities($e['message']), E_USER_ERROR);
}
?>
Example #3
Displaying the Oracle error message, the problematic statement, and the position of the problem of an execution error
<?php
$stid = oci_parse($conn, "select does_not_exist from dual");
$r = oci_execute($stid);
if (!$r) {
$e = oci_error($stid); // For oci_execute errors pass the statement handle
print htmlentities($e['message']);
print "
<pre>
";
print htmlentities($e['sqltext']);
printf("
%".($e['offset']+1)."s", "^");
print "
</pre>
";
}
?>
PHP Documentation Group OCI_ERROR(3)