| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi all,
is it possible to retrieve from a Stored Procedure the remote
host name or address who owns the Session ?
Thanks
Laura
Laura
|
05-30-2007 11:40 AM
Laura  | 8 | 18 |
| | | On May 29, 5:25 pm, "Dereck L. Dietz" <diet... (AT) ameritech (DOT) net> wrote:
Varies. You can search the bug database or release content lists...
joel garry
|
05-30-2007 11:18 AM
DA Morgan | 3 | 27 |
 | | On 25 May 2007 08:28:18 -0700, zigzagdna (AT) yahoo (DOT) com wrote:
As has been said many time your code won't run milliseconds closer.
You have...
Doug Davis
|
05-30-2007 11:03 AM
DA Morgan | 139 | 522 |
| | | My general goal is to duplicate a 10.2.0.3 DATABASE on server a to
server b
I am using a catalog on another server / I have executed a backup...
chris b
|
05-30-2007 08:35 AM
gazzag | 2 | 25 |
| | | Is v$sqlarea a view that stored all sql that are being cached in
shared pool? If not, where can I find such information? Thanks.
Susan
|
05-29-2007 09:52 PM
Charles Hooper | 1 | 22 |
| | | dear all,
Oracle db 10g r2 enterpise
RHEL version 3.
i have an error when dbora attempt to execute. That error is describe
in system log in...
chijar
|
05-29-2007 07:38 PM
Maxim Demenko | 6 | 32 |
| | | I have read the documentaton and I am still stuck. Here is what I
have done so far.
1. Rman target / nocatalog
2. Startup nomount
3. Set dbid to...
cptkirkh
|
05-29-2007 07:24 PM
joel garry | 7 | 37 |
| | | 10gR2
I'm kind of self-doubting now, I'd like to run this by you gurus;
I see this in pl/sql : (written by...
maomao
|
05-29-2007 03:49 PM
fitzjarrell@cox.net | 2 | 40 |
| | | Dereck L. Dietz wrote:
Probably makes little difference given the recyclebin. But you should
run a test and verify.
--
Daniel A. Morgan
University...
DA Morgan
|
05-29-2007 01:39 PM
RogBaker@gmail.com | 6 | 35 |
| | | I have two tables TACCOUNT & TCUSTOMER joined by one to many. I have
Account_sk in both tables which is used to join. When I create the
account_sk...
aravind.kanda@gmail.com
|
05-29-2007 11:15 AM
aravind.kanda@gmail.com | 2 | 31 |
| | | Anybody knows this?
Thanks a lot.....
orz~
Steven
|
05-28-2007 02:17 PM
DA Morgan | 10 | 53 |
| | | Hi all,
It is any function in Oracle 9i equal o with a similar
funtionability than (i=i+1).
I want to do a "Insert Into a select" but one fileds is...
valigula
|
05-28-2007 06:27 AM
valigula | 5 | 31 |
| | | Hello,
if you work with a oracle DB 9.2.0.8 and Windows 2003, be careful with
the rman backup.
We run in a bad bug after upgrade from 9.2.04 to...
gpipperr@netcos.de
|
05-28-2007 06:12 AM
Cristian Cudizio | 5 | 32 |
| | | oracle_oracle#1-8_0_2400x40000000_system#000.rt
oracle_oracle#1-8_0_2400x40000000_system#001.rt
oracle_oracle#1-8_0_2400x40000000_system#002.rt
.........
rainbowtables@emailmiser.com
|
05-27-2007 02:02 AM
rainbowtables@emailmiser.com | 0 | 36 |
| | | In my quest to comply with EAL4 evaluationsI came across the following
in the Oracle Documentation and got confused, I hope that someone
might...
bernard (bernard_at_bosvark.com)
|
05-26-2007 03:35 PM
Frank van Bortel | 5 | 24 |
| | | Hi all,
how can I check the users that have privileges on a certain Directory
(object) ?
thanks,
pedro
Pedro Lopes
|
05-25-2007 08:24 PM
DA Morgan | 4 | 25 |
| | | All,
I have a 3 node 10.2.0.3.0 cluster with 4 databases running across all
nodes. On reboot of the nodes, some instances are not starting. ...
oracle_man
|
05-25-2007 07:09 PM
hpuxrac | 1 | 29 |
| | | Hi,
I am looking into migrating a database from DB2 on z/OS to Oracle on
Windows.
I am quite new to databases and would appeciate any information...
goooooglegroups@yahoo.com
|
05-25-2007 05:50 PM
joel garry | 19 | 91 |
| | | Has anyone done any benchmarks to compare performance of ASM using RAW
partitions vs. NFS (especially NFS on Netapp)?
A Netapp 3070 is coming my way...
orcljsb@gmail.com
|
05-25-2007 05:25 PM
Mladen Gogala | 7 | 29 |
| | | Hi All,
i am using oracle 10g R2 (vista release) on windows vista home basic
machine when i try to start isqlplus i get this...
shobhit@gmail.com
|
05-25-2007 01:13 PM
Matt Dibble | 5 | 31 |
| | | Hallo,
I've encountered two times on two machines a similar problem.
With Oracle 9.2.0.6 on windows 2003 there were no active sessions
(from...
Cristian Cudizio
|
05-25-2007 10:42 AM
Cristian Cudizio | 5 | 25 |
| | | Hi All,
This is another question about system statistics. We are in the
process of upgrading from 9.2.0.6 to 10g release 2. We do not
currently use...
Ralph.in.NZ@googlemail.com
|
05-25-2007 09:43 AM
hpuxrac | 1 | 21 |
| | | I need to calculate two differents totals from a table . One is
filtering by the year to know how many from this year and the other is
a total...
valigula
|
05-25-2007 03:52 AM
valigula | 2 | 51 |
| | | I am new to oracles product licensing but I am trying to find out if
Oracle Internet Directory is a separately licensed product from DBMS
Enterprise...
Lyall
|
05-25-2007 12:26 AM
sybrandb@hccnet.nl | 2 | 25 |
| | | Hi,
I have several questions in Oracle server performance, any experts out
there could answer my questions. Thanks very much.
1) When I experience...
anarayth.zata@gmail.com
|
05-24-2007 05:12 PM
joel garry | 1 | 37 |
| | | I have had a couple problems with undo in the past I want to make sure
I'm on the right track. I'm using 9i with AUM and my retention is set
to 900....
David.E.M....@gmail.com
|
05-24-2007 04:27 PM
joel garry | 4 | 73 |
| | | I know that we need administrative rights to a window box during
installation and configuration.
After cutover to production, is it possible for the...
Anthony
|
05-24-2007 03:20 PM
EscVector | 10 | 66 |
| | | Hello,
I wonder if anyone could explain why I get the following behaviour.
This is the same query run on two databases where as far as we know
the...
Number.One.Mike@gmail.com
|
05-24-2007 01:41 PM
fitzjarrell@cox.net | 1 | 31 |
| | | Hello everyone,
I have installed oracle 10g enterprise in Solaris 10.
While installing it asks only one password(at the beginning). I have
given...
Pandi K
|
05-24-2007 12:57 PM
DA Morgan | 1 | 23 |
| | | Please see req below. This is a very urgent need; client wants to fill
the position as soon as possible.
Location: Baltimore, MD. Candidate must be...
ramantech
|
05-24-2007 12:55 PM
DA Morgan | 1 | 31 |
| | | Hi,
I have several questions in Oracle server performance, any experts out
there could answer my questions. Thanks very much.
1) When I experience...
anarayth.zata@gmail.com
|
05-24-2007 12:52 PM
DA Morgan | 2 | 32 |
| | | I am trying to work towards duplicating a database ( production )
& loading into a standby / both oracle 10.2.0.3 enterprise
The documentation...
chris b
|
05-24-2007 11:34 AM
Valentin Minzatu | 1 | 34 |
| | | Hello all,
I am using Statspack to investigate a performance problem in my
database (Oracle 9.2). In a moment that the database doesn't...
Ana Ribeiro
|
05-24-2007 10:37 AM
Valentin Minzatu | 2 | 26 |
| | | I have taken and passed 3 oracle 8i exams a few years ago and several
months ago passed 2 9i exams. The 9i exams did not break down the
section by...
utefan001
|
05-24-2007 09:41 AM
Brian Peasland | 1 | 28 |
| | | Is it possible to filter duplicates codes by filtering with diferent
dates???
I have a table from where i load into my tables, that table has...
valigula
|
05-24-2007 04:32 AM
valigula | 22 | 68 |
| | | Hi,
Currently we are in the process of establishing a diagnostic sheet in
order to help us track down a problem. One of our clients is running...
prunoki
|
05-24-2007 04:14 AM
NetComrade | 5 | 52 |
| | | Hi All,
I'm not real familiar with either of the two technologies I am posting
about, but, we are setting up 2 new servers to run 5...
amerar@iwc.net
|
05-24-2007 04:07 AM
NetComrade | 14 | 66 |
| | | Call to arms:
I: What is the better choice on x86_64,RHEL4u4(2.6x kernel), EMC
CX300 SAN, EMC powerpath 4.5x, Oracle 10.2.0.3.0, RAC, ASM?
1) ...
oracle_man
|
05-24-2007 04:02 AM
NetComrade | 3 | 39 |
| | | I have a table (simplified):
NAM E VOY DATE
The NAME column can have the same entry up to 10 times based on the
VOY. So it could look...
Robert Hicks
|
05-23-2007 03:32 PM
valigula | 12 | 54 |
| | | Hello.
If I wish to have a comprehensive test set for Oracle DB contain all
possible SQL code, covering as much Oracle features as possible,...
drop669@gmail.com
|
05-23-2007 03:12 PM
drop669@gmail.com | 4 | 35 |
| | | Hello,
I 've read that oracle 10 g XE is not "64 Bit Support" as shown there
http://www.oracle.com/database/product_editions.html
but can I...
billy boy
|
05-23-2007 02:43 PM
Frank van Bortel | 1 | 32 |
| | | 9.2.0.5 Ent Ed on AIX5L
I'm in the process of upgrading to 10.2.0.3. In preparation I'm
installing the client software on a few windows machines and...
Ben
|
05-23-2007 01:44 PM
Ben | 3 | 24 |
| | | Hi,
we are running a load job with a parallel degree of 8 on a machine
with 4 processors each with two cores. Running statspack I've found
out, that...
io
|
05-23-2007 12:39 PM
Brian Peasland | 4 | 51 |
| | | I create sample function in sql:
CREATE OR REPLACE function proba return number as
--èæ¾ð¹ÈƮЩ sample text
begin
return 9;
end;
And open it in em:
perivoj@net.hr
|
05-23-2007 10:38 AM
perivoj@net.hr | 2 | 54 |
| | | I have worked a lot with dBase (version III upto version 7).
Is there a lot of difference between Oracle and dBase?
Programming in dBase and visual...
VragenStaatVrij
|
05-23-2007 02:53 AM
Frank van Bortel | 4 | 29 |
| | | Please, can you advise? I declared function in package:
FUNCTION CheckManufacturersDict RETURN BOOLEAN IS
result BOOLEAN DEFAULT...
Vojta
|
05-23-2007 01:31 AM
Vladimir M. Zakharychev | 4 | 58 |
| | | Hello,
I'm trying to write an extract to a spool (txt file) with SET HEADING
ON but the headers are still not coming through. Anyone know why...
Peps
|
05-23-2007 12:46 AM
Michel Cadot | 1 | 31 |
| | | Hi All,
My application connects to an Oracle Server 9i via OCI.
I have all my select statements on stored procedures, for this I use
REF CURSOR to...
remius@lycos.es
|
05-22-2007 11:33 PM
Mladen Gogala | 4 | 65 |
| | | PITech Solutions is actively seeking an Oracle DBA for its client in
Durham, NC. This is a permanent position requiring someone with 6+
years Oracle...
Dickle
|
05-22-2007 06:26 PM
DA Morgan | 1 | 29 |
| | | Hi all,
I am running Oracle 8.1.6.3 on WinNT and trying to recreate test d/b
from prod.
First, I ran alter database backup control file to...
Eugene
|
05-22-2007 05:10 PM
fitzjarrell@cox.net | 2 | 34 |
