Getting sysdate across a DB link

2004-01-26 Thread Ashish Sahasrabudhe
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

RE: Getting sysdate across a DB link

2004-01-26 Thread Ashish Sahasrabudhe
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

[no subject]

2004-01-21 Thread Ashish Sahasrabudhe
HELP

SQL Code release

2004-01-21 Thread Ashish Sahasrabudhe
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

RE: SQL Code release

2004-01-21 Thread Ashish Sahasrabudhe
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

dc_sequences

2003-12-29 Thread Ashish Sahasrabudhe
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

DB link to standby

2003-12-18 Thread Ashish Sahasrabudhe
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

RE: SQL Area Reloads

2003-12-11 Thread Ashish Sahasrabudhe
:[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

SQL Area Reloads

2003-12-10 Thread Ashish Sahasrabudhe
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