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
the international date line? Shouldn't the dates be the
same?
How
about getting the time from both servers - they *might be* different by a few
seconds.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Ashish Sahasrabudhe
[mailto:[EMAIL PROTECTED]Sent
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
Title: DB link to standby
On standby database server, you can connect to / as sysdba and query
fixed tables/views. Is it possible to create a database link which connects
to sysdba user to query the fixed tables/view?
I tried, but getting following error
ORA-02068: following severe error from
:[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
Title: SQL Area Reloads
The statspack report is showing 10,684 reload for SQL AREA with 2.2% misses.
==
Library Cache Activity for DB: MAIN Instance: MAIN Snaps: 18089 -18090
-Pct Misses should be very low