Statspack wierd Output

-- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

Standard Vs. Enterprise Edition for Application Compilation

OCI Calls to the DB. Does Standard Edition support the same? Qs Which are the important differences between Standard Edition of 8i/9i versus Enterprise Edition? Will provide any info needed Thanks Vivek -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA

Standard Vs. Enterprise Edition for Application Compilation

OCI Calls to the DB. Does Standard Edition support the same? Qs Which are the important differences between Standard Edition of 8i/9i versus Enterprise Edition? Will provide any info needed Thanks Vivek -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA

Standard Versus Enterprise Edition

OCI Calls to the DB. Does Standard Edition support the same? Qs Which are the important differences between Standard Edition of 8i/9i versus Enterprise Edition? Will provide any info needed Thanks Vivek -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA

Code Conversion from MSSQL into Oracle

pe='D') where [EMAIL PROTECTED] and branch_id = @branch_id FETCH NEXT FROM cur_temp_GEMT INTO @branch_id, @entity_id END CLOSE cur_temp_GEMT DEALLOCATE cur_temp_GEMT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMA

RE: Code Conversion from MSSQL into Oracle

    Are there any TOOLs for converting Sample Code (like the following) from MSSQL into Oracle?   SAMPLE :- DECLARE @entity_id char(32), @branch_id char(9)   DECLARE  cur_temp_GEMT CURSOR FOR select branch_id,entity_id from GEMT where other_party_name='' and entit

RE: Code Conversion from MSSQL into Oracle

  Are there any TOOLs for converting Sample Code (like the following) from MSSQL into Oracle?   SAMPLE :- DECLARE @entity_id char(32), @branch_id char(9)   DECLARE  cur_temp_GEMT CURSOR FOR select branch_id,entity_id from GEMT where other_party_name='' and entity_t

Code Conversion from MSSQL into Oracle

  Are there any TOOLs for converting Sample Code (like the following) from MSSQL into Oracle?   SAMPLE :- DECLARE @entity_id char(32), @branch_id char(9)   DECLARE  cur_temp_GEMT CURSOR FOR select branch_id,entity_id from GEMT where other_party_name='' and entity_t

SQL_Trace versus Statspack

partly visible above too in statspack Output Will provide any data needed Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

RE: Trace (SQL) versus Statspack data

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

Trace versus Statspack data

27;) ,TO_CHAR(booked_upto_date_dr,'DD Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

Trace versus Statspack data

  We are doing Interest processing on a SET of 10,000 Bank A/cs   Following SQL Query Shows DIFFERING values for :- “Execute” from SQL_TRACE = 2584 “Executions” from Statspack report = 10,000   Qs. What is the reason for this?   SQL_TRACE :-   call count   cpu    elapsed

Trace versus Statspack data

  We are doing Interest processing on a SET of 10,000 Bank A/cs   Following SQL Query Shows DIFFERING values for :- “Execute” from SQL_TRACE = 2584 “Executions” from Statspack report = 10,000   Qs. What is the reason for this?   SQL_TRACE :-   call count   cpu    elapsed

ORA-4031 errors no a high Load Database

  Intermittent ORA-4031 errors Out of shared Pool :-   Oracle ver 9203 Solaris 9 Concurrent Users = 6000 Shared Servers / MTS being used Listeners = 4 Application using Bind Variables Application = Banking - Hybrid in Nature Database size = 1 TB m/c = SF15K   How can this issu

RE: Optimizer related init parameters

se values. If you have enough "trace data" to warrant these changes, then by all means. Otherwise, you may be setting yourself up for surprises in the future. Cheers, Gaja --- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: > How Good/advisable are the following 4 parameters' >

Optimizer related init parameters

How Good/advisable are the following 4 parameters’ Values in a Hybrid Application? Are there any know ill-effects of the same?   Application – Banking (Hybrid) Solaris 9 Oracle 9.2      optimizer_max_permutations=8000  optimizer_index_cost_adj=10  optimizer_index_caching=50  optim

Dataguard Benchmark - (re-posting)

recipients of list ORACLE-L   No. I mean the goals of the benchmark. What are you measuring and why.   On 2003.09.16 06:10, VIVEK_SHARMA wrote: > Hi > > Plan of the Benchmark = ? If you mean an action plan of important steps > ? > > We have just started. I Shall s

Dataguard Benchmark

-Original Message- Sent: Tuesday, September 16, 2003 5:25 PM To: Multiple recipients of list ORACLE-L   No. I mean the goals of the benchmark. What are you measuring and why.   On 2003.09.16 06:10, VIVEK_SHARMA wrote: > Hi > > > > Plan of the Benchmark = ? If

RE: Logical standby mode - Dataguard - 9.2.0.4

(in alert_.log) & all Our Commands complete successfully, DMLs on Primary tables are NOT getting applied to Standby Database   We have raised a few Oracle TARs too.   Thanks     -Original Message- From: VIVEK_SHARMA Sent: Monday, September 29, 2003 1:40 PM To: Multiple recipi

RE: Logical standby mode - Dataguard - 9.2.0.4

OR is it so that logical Standby mode is just NOT possible for the Entire Database if the Database has even 1 Table with a LONG field datatype ?     -Original Message- From: VIVEK_SHARMA Sent: Monday, September 29, 2003 1:25 PM To: Multiple recipients of list ORACLE-L Subject

Logical standby mode - Dataguard - 9.2.0.4

A Basic Qs. On Logical standby mode - Dataguard - 9.2.0.4 . Is the following statement correct ?   From the Primary Database the DMLs on tables NOT having LONG columns are successfully applied across to the Logical Standby database while those tables containing LONG columns fail .  

RE: Dataguard Benchmark

? What did you decide to monitor in the planning phase?     -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of VIVEK_SHARMA Sent: Monday, September 15, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Subject

Dataguard Benchmark

We are doing a Data guard Benchmark.   INFO.:- - WAN Simulator :- We have a WAN Simulator with 2 routers at either ends of it. Thruputs from 0 to 2 MBPS can be manually set as is required by the run.   Application = Banking :- Transactions mainly OLTP in nature (Both DML & SEL

Trapping of Rogue Statement

An unwanted update - del_flg=”Y” is happening while an application is underway with thousands of Concurrent Users   We need to trap & get as much info on this update which is somehow happening from somewhere in the application code .   How as a DBA can we do this?   Thanks        

RE: Urgent INFO needed. - OFF TOPIC

ts of list ORACLE-L > >> *Subject:* Urgent INFO needed. > >> > >> Dear Friends, > >> > >> One of my friends has got the offer from CSC india ltd. Please > >> respond this mail if any on

RE: Oracle Standby Database Backups.

Arup,Indy, List   Some Clarifications please   If the Primary Database is in ARCHIVELOG Mode (Physical Standby) & archived files there from are being shipped & applied to the Standby Database, What is the need to run the Standby Database in ARCHIVELOG Mode?   Are you implying 9i Dat

RE: Urgent INFO needed. - OFF TOPIC

-- >> Do you Yahoo!? >> Yahoo! SiteBuilder >> <http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com> >> - Free, easy-to-use web site design software >&g

log buffer space wait

At a Benchmark a particular Processing + DML intensive batch Job (Accounts Interest Calculation) is experiencing “log buffer space” wait .   Config :- On Solaris 9 Cpu_count = 72 Oracle 9.2 Online Redo logfiles are on a RAID 0+1 Volume (NOT Raw or RAID 1) Log_buffer = 10 M $ sar C

Simulating WAN on LAN for Dataguard Benchmark

  Is it possible to simulate WAN on LAN for a Dataguard Benchmark ? Any Docs , Links ?   Thanks  

RE: Query results to .csv

-- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mail

Oracle 9i versus MS SQL 2K w.r.t. Performance

  Need to give a presentation on Oracle 9i versus MS SQL Server 2K with respect to Performance primarily .   Any Docs , Links ?   Thanks    

RE: Redo Logs Problem

PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of VIVEK_SHARMA Sent: Monday, August 04, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo Logs Problem   Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation     -Original Message

RE: Redo Logs Problem

Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation     -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Subject: Redo Logs Problem   Hi Li

Oracle Tools Comparable with OEM ?

Any Oracle Tools Comparable with OEM having  Free Evaluation Copy or Freeware for Download  ?   Any names ,  Links etc ?   Thanks  

RE: Triggers - How expensive when set on heavily loaded tables ?

& based on the time criteria generates the alert ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Maili

High disk , query values with Global & non-prefixed Local indexes

Qs  Why the larger values of disk=45 , query = 525 when using Global indexes & Non-prefixed local indexes VERSUS Local Prefixed indexes where dis = 0 & query = 0 in the CASES below ?   Qs How significantly can this affect the performance thruput ?     CASE : Comparison with global p

RE: piece-wise return of records from table

the responses . -Original Message- Sent: Wednesday, July 23, 2003 7:30 AM To: VIVEK_SHARMA HiVivek , Use this SQL query to achive your piece wise operation... Select * from ( Select a.*, rownum r from ( Select * from tablename

Triggers - How expensive when set on heavily loaded tables ?

d a cron job running every 5 min. look at TABLE_2 & based on the time criteria generates the alert ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.c

piece-wise return of records from table

CASE   select * from table gives  1000 records (say) We want only first ten of these records to be returned to the front end & then records 11 to 20 & so on …   How may the above be optimally possible ? SQL or PL/SQL any for it ?   Thanks    

RE: RAC system Calls .......

; SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ravi Kulkarni > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http

RE: inline views

loop and making multiple trips, it made 1 trip and brought over all of the data. The query time was reduced from 30 minutes to 5 minutes. -- Daniel W. Fink http://www.optimaldba.com VIVEK_SHARMA wrote: >Where are they advantageous to use & where not ? > >Thanks -- Please see

DataGuard & Logical Standby Benchmark

www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from thi

SELECT Output Default Ordering ?

index Key fields. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Migrating 8i OPS to RAC 9.2

complexities in the upgrade/migration/or whatever.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Migrating 8i OPS to RAC 9.2

Any Good Docs , Links ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Migration to 9.2.0.3.0 (64 Bit) on Solaris 8 issues

.7 3,5050 TRIGGER 610.0 616.6 40 - Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City

Data Guard modes & performance impact

ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

RAC vs. OPS a comparison ?

RAC vs. OPS any comparison study , doc , link ? Need it for customer already on OPS , who is considering moving to RAC Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Fragmentation ?

espace ? NOTE Allocation_type can be made = "USER" by using the stored procedures :- dbms_space_admin.tablespace_migrate_from_local / dbms_space_admin.tablespace_migrate_to_local Am i still Lost in the World of Oracle 7 ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Fragmentation ?

ed Tablespace ? NOTE Allocation_type can be made = "USER" by using the stored procedures :- dbms_space_admin.tablespace_migrate_from_local / dbms_space_admin.tablespace_migrate_to_local Am i still Lost in the World of Oracle 7 ? Thanks -- Please see the official ORACLE-L FAQ: http

inline views

Where are they advantageous to use & where not ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

count(*) vs count(0)

Is there a performance equality between COUNT(*) & COUNT(0) ? Is it same , indpendent of the Oracle Version ? Forgive the repeat raising , as this issue seems to have come before . Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [E

Migrating from Informix to Oracle 9.2 ( with O.S. Change from AIX to Linux )

What may be Easier ways of doing the same ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

library cache pin wait

gt; INDEX 38,620 19.0 38,618 24.5 80 > SQL AREA 1,627,3546.3 26,006,4720.8152,1168 > TABLE/PROCEDURE1,206,3670.3 1,875,867 15.4158,7380 > TRIGGER1,4050.2 1,7

library cache pin wait

--- shared_pool_reserved_size 104857600 shared_pool_size 419430400 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: skip scan index

PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http

Off Topic : MSSQL Competence building

need to do MSSQL database Competence building More from the DBA's end though should have good functional knowledge of SQL prog. too Any Good BOOKS , Lists , Sites , Links , forums ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [

RE: RMAN - Some basic Qs.

Block Corruption while > taking backup ? > > Qs.4 Is it easy to integrate 3rd part tools like > Legato etc with RMAN for enabling taking > of backups onto backup devices OR does it need an > extensive setup ? > > > -- > Please see the official ORACLE-L FAQ: >

RMAN - Some basic Qs.

for Block Corruption while taking backup ? Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA

audit_trail=db Overhead ?

-- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

POLL by Application Service process taking too Long

truss -fdD of an application service which received data in messages format & passes it on to the Database gives the following output .   5.1130 poll(0xFFBFA0D8, 1, 24) = 1  0.0002 recv(17, "   N 0 0 1 4 4 1".., 28, 0)   = 28  0.0003 poll(0xFFBFA0D8, 1, 24)

Error SQL 02115 "Code interpretation problem check COMMON_NAME usage"

  At a production database after making a Pro C source change we are getting the Orace error SQL-02115 "Code interpretation problem -- check COMMON_NAME usage"   The same executable works fine on another Dummy machine with a test database    Oracle 8.1.7 on Compaq Tru64 Unix 5.1 Product

RE: OEM - Automation of Start of Collection for Performance Reports

www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mail

OEM - Automation of Start of Collection for Performance Reports

nsactions' run thereby containing lots of unnecessary data . NOTE - Collection for All these STARTed performance reports can be STOPPED by a Single Click . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Ne

File Table Overflow on Oracle DB Server

rver > through the application still this error keeps coming after running > the test for some duration. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 ht

RAID 5 impact on "sys" Utilization

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---

Lgwr , CKPT - Some Misc. basic Qs.

should preferably be n+1 . Why ? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cal

RAID 5 impact on "sys" Utilization

8.1.7 Solaris 8 VXFS SF15K DB Server - 40 CPUs Hitachi Storage Box from HP Concurrent Oracle sessions = 5000 Will provide any info needed Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services

Lgwr , CKPT - Some Misc. Puzzlers ?

l ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

RE: Commit boundary <-> Stripe Unit Size Co-relation

of the SAME INSERT Statement Write to a Different Underlying Disk of the same Striped Volume within the SAME Segment Extent ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatc

RE: Commit boundary <-> Stripe Unit Size Co-relation

te to a Different Underlying Disk of the same Striped Volume within the SAME Segment Extent ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com Sa

RE: Commit boundary <-> Stripe Unit Size Co-relation

Statement Write to a Different Underlying Disk of the same Striped Volume within the SAME Segment Extent ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San D

RE: Index update = Delete + insert ?

Vijay,List When Updating to the Field to the SAME (Previously Existent) Data Value , Does a DELETE & RE-Insert of the Same Row to the index happen nevertheless ? Thanks -Original Message- Sent: Wednesday, February 12, 2003 12:50 PM To: VIVEK_SHARMA Hi Vivek, Index rows are f

Index update = Delete + insert ?

Is an index Fields' update actually a DELETE followed by an INSERT of the index row ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Calif

vxio:vol_maxio (Veritas) impact on Database performance ?

width 512KB) then you want to set your vol_maxio to match 512KB, but not exceeding 1MB. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Commit boundary <-> Stripe Unit Size Co-relation

ww.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this

Commit boundary & Stripe Unit Size Co-relation

ww.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this

Find index row length ?

: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an

vxio:vol_maxio (Veritas) impact on Database perf ?

stripe width 512KB) then you want to set your vol_maxio to match 512KB, but not exceeding 1MB. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: SQL*Net Connection under-performing

by01) (SRVR = DEDICATED) ) ) -Original Message- Sent: Tuesday, February 04, 2003 8:20 PM To: VIVEK_SHARMA Could be a DNS issue. Do you have the host name in the tnsnames.ora, or the IP address for both the databases? To: Multiple recipients of list ORACLE-L <[EMAIL PR

RE: Version Controlling in Oracle database - Ideas ?

CM ... Raj    -Original Message----- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Version Controlling in Oracle database - Ideas ? Looking for a solution to version controlling of database

Version Controlling in Oracle database - Ideas ?

TOAD was not acceptable since it would be file based(saving the .sqls). Qs. Is there any feature available in Oracle(with oracle 8.1.7) or any third party tool that does this ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat

RE: SQL*Net Connection under-performing

by01) (SRVR = DEDICATED) ) ) -Original Message- Sent: Tuesday, February 04, 2003 8:20 PM To: VIVEK_SHARMA Could be a DNS issue. Do you have the host name in the tnsnames.ora, or the IP address for both the databases? To: Multiple recipients of list ORACLE-L <

9i "Reliability" means ?

s of sizes upto 1 TB working optimally . Do you believe we can give a Talk on the Subject "Reliability" ? The presentation might have in attendance some of the Leading Oracle minds . Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INE

RE: SQL*Net Connection under-performing

ter that may take you a minute until all the prespawned connections are initiated.   HTH. Regards : Ferenc MantfeldDreaming costs you nothing. Not dreaming costs you everything. - Original Message - From: VIVEK_SHARMA To: Multiple recipients of list ORACLE

RE: Memory Free up Failing on Solaris 8 - Off-topic

Private Permissions Mapped File > 00022000 32 32 - 32 read/write/exec [ heap ] > > STEP 4 - Freeing the memory allocated in the above Step > Freeing [2] > > pmap -x > > Address Kbytes Resident Shared Private Permissions Mapped File > 0

SQL*Net Connection under-performing

Title: Details about Tar logged SITUATION - With DB Server CPU Idle being  0 %  & load average 60-70 % :- tnsping Connect to one of the  Databases (1) takes about 10,000 ms truss -fdD tnsping       29504: 20.0006 18.8113 read(3, "\0 K\0\004\0\0\0 "\0\0 ?".., 2064) = 75   Thus 18  sec

Memory Free up Failing on Solaris 8 - Off-topic

K Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---

MAX Length of of Name for Table / Index ?

What is the MAX possible Length of of Name for Table / Index ? Why ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RMAN backup - basic Qs

Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

2 basic Qs. on export

R NON-Updated Data ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hos

RE: Different Backups - A Comparartive analysis

the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Different Backups - A Comparartive analysis

llow any incremental Backups ? Is incremental Backup Disabled from 8i onwards for exp ? 12) Limitations - Compress/Splitting of exp files etc ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-

rsh on Unix hangs - OT

t; subbu > After stops > after runs > subbu > > After that that the rsh command is hanging. Actually it is running all the commands >of remote script and then it is hanging. > Any pointers to solve this problem. > > This is required as a part of failover between two m

Simulate Database Writes

Dependency on the Size & Volume of our Batch Job related Database Commits ? Any Other Boundary conditions need to be taken into consideration ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Serv

MAX Number of Records in Cursor ?

Customers . There are no oracle errors reported in the log files . Is there any size limitation in oracle while opening/fetching a cursor as the No. of records to be fetched are 102,847 ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET

explain plan parameter meanings

Title: Message In the explain plan what is meant by "cost" , "card"  and "byte"  ? How may they be interpreted practically ? Any Docs , Links on the Same ?     Execution Plan--   0  SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=

RE: log file sync Wait

Box is T3+ >File System = UFS > >Application = Banking (Hybrid ) >Oracle 8.1.7.4 >Solaris 8 >Machine Box = SF6800 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Networ

Excessive Redo Generation

gt; We shall be taking Logminer Outputs Anything in particular to Look for in the Logminer Output to Check for Excessive Redo Generation ? [VIVEK_SHARMA] Thanks > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL P

log file sync Wait

8.1.7.4 Solaris 8 Machine Box = SF6800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

  1   2   3   4   >