Title: Getting sysdate across a DB link
I'm trying to get the value of SYSDATE on a remote server. I have a
database link to the server, but I'm not sure how to force SYSDATE to
be evaluated on the remote machine.
Following query gives same results, both dates are same.
select sysdate
, Thomas F
[mailto:[EMAIL PROTECTED]Sent: Monday, January
26, 2004 1:36 PMTo: '[EMAIL PROTECTED]'Cc:
'[EMAIL PROTECTED]'Subject: RE: Getting sysdate
across a DB link
Ashish,
Why
do you think that the dates would be different on the two machines - is one
across
HELP
Title: SQL Code release
Is there a tool available to release same set of DDLs, DMLs, PL/SQL code
in different database environments like QA, Unit Testing, Production Support etc.
I guess this can done by writing shell or batch scripts. But I am looking for
a GUI tools to do this.
Thanks
are strictly personal. QOTD:
Any clod can have facts, having an opinion is an art !
-Original Message-From: Ashish Sahasrabudhe
[mailto:[EMAIL PROTECTED]Sent: Wednesday, January
21, 2004 11:10 AMTo: Multiple recipients of list
ORACLE-LSubject: SQL Code release
Title: dc_sequences
In statspack report on RAC 9.2.0.2 database, under section Dictionary Cache Stats for DB
there are 64.3% miss for dc_sequences. What causes this?
Thanks
TEST_SB
ORA-01033: ORACLE initialization or shutdown in progress
Thanks
Ashish
:[EMAIL PROTECTED]Sent: Wednesday, December 10, 2003 11:05
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
SQL Area ReloadsSure, it's free now.
But has that always been the case?on 12/10/03 3:14 PM,
Ashish Sahasrabudhe at [EMAIL PROTECTED] wrote:
The statspack report is showing
208,498 0.1 584,219 0.0 1 0
TRIGGER 2,746 0.0 2,746 0.0 0 0
==
The 250 MB of shared pool is free. Why would it cause reloads if there is so much
free space available?
Any help is appreciated.
Ashish
You need to increase value for SGA_MAX_SIZE parameter.
Ashish
OCP DBA
-Original Message-
Baumgartel
Sent: Friday, April 04, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
So I have DB (9.2.0.1) running on Win2K, with db_cache_size of 32M.
Windows Task Manager shows 600+ MB
Title: PL/SQL- cursors and commits
As the
book says, it fails with following error(9.2.0.1 on
Win2k).
declare*ERROR at line
1:ORA-01002: fetch out of sequenceORA-06512: at line 12
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Wiegand,
this can be used?
Any ideas?
-Ashish
OCP
DBA
12 matches
Mail list logo