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
, 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

[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
TEST_SB ORA-01033: ORACLE initialization or shutdown in progress Thanks Ashish

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
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

RE: Memory strangeness on Win2k

2003-04-05 Thread 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

RE: PL/SQL- cursors and commits

2003-04-04 Thread Ashish
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,

Sub-query in order by clause

2003-04-04 Thread Ashish
this can be used? Any ideas? -Ashish OCP DBA