Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 26763 invoked from network); 21 Aug 2008 06:38:03 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 21 Aug 2008 06:38:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 99C6691A259; Thu, 21 Aug 2008 07:38:03 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24950-04; Thu, 21 Aug 2008 07:38:03 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1358691A24C; Thu, 21 Aug 2008 07:38:03 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 21 Aug 2008 07:36:07 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B6F6D919D70 for ; Thu, 21 Aug 2008 07:36:07 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24661-10 for ; Thu, 21 Aug 2008 07:36:07 -0400 (EDT) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.248]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6EDF0919989 for ; Thu, 21 Aug 2008 07:36:07 -0400 (EDT) Received: by an-out-0708.google.com with SMTP id b38so384484ana.101 for ; Thu, 21 Aug 2008 04:36:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=70uC6AnyF6PUkbN9imxC/AY+Ugt4SG0F5JoZfsvuVag=; b=vbbAL/YdJ26QkR+33HCR9Y0K0KwNhFbQSq/TbfDCFWp/6g6VTFV3X730MvgDHtUrTM OUdaskGHEAWPFgwV9MtcrD7PdKS3F6PZYA3j6RwYIcAJP8tToscP2Ds0oaJlz5rbKMNF DQ4NYUqAsmAYTojsmNWARekSJe8t4rmpmB4IA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=MZk7s40MkR3Qzq+K9Z339ao99BPVhG3crHbWItFneGwoniGtiXmK6vLKUhVx1b23f/ wn36sCEygzFiJc28a7qQVjyBhQr4T1MnAakGuwypU2/ezevsCGXbT5PnJPWSqsH/Aojx kLWcUeFvxeJndGBP44YGDHRHRjkfZLgzOZRe8= Received: by 10.100.173.18 with SMTP id v18mr1600364ane.122.1219318566737; Thu, 21 Aug 2008 04:36:06 -0700 (PDT) Received: by 10.100.57.20 with HTTP; Thu, 21 Aug 2008 04:36:06 -0700 (PDT) Message-ID: Date: Thu, 21 Aug 2008 12:36:06 +0100 From: "David Pintor" To: oracle-l@freelists.org Subject: column size - SQLPATH question MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_56162_22279241.1219318566744" X-archive-position: 10283 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: painterman@gmail.com Precedence: normal Reply-to: painterman@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_56162_22279241.1219318566744 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello, *- Oracle 9.2.0.8.0 - Solaris 8* I have two servers as above. One for production and one for staging. In both I have an oracle user, in which profiles I have the following lines: export ORACLE_HOME=/u01/oracle/ora92 ... export SQLPATH=$ORACLE_HOME/sqlplus/admin I have the same default glogin.sql in the SQLPATH for both but also a login.sql with the following lines: define editor=vi set lines 150 set pages 999 The configuration looks exactly the same for me. However, when I go to prod and type something like 'show parameter sga' I get: NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 3222769816 And the same in staging gives me: NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 2098694720 I don't understand why the size of the columns is different if all in SQLPATH is exactly the same and the Oracle version (and patch) are at the same level. Any ideas? Thanks for your help! David ------=_Part_56162_22279241.1219318566744 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hello,

- Oracle 9.2.0.8.0
- Solaris 8

I have two servers as above. One for production and one for staging.

In both I have an oracle user, in which profiles I have the following lines:

export ORACLE_HOME=/u01/oracle/ora92
...
export SQLPATH=$ORACLE_HOME/sqlplus/admin


I have the same default glogin.sql in the SQLPATH for both but also a login.sql with the following lines:

define editor=vi
set lines 150
set pages 999


The configuration looks exactly the same for me.

However, when I go to prod and type something like 'show parameter sga' I get:

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 3222769816



And the same in staging gives me:

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
lock_sga                             boolean                          FALSE
pre_page_sga                         boolean                          FALSE
sga_max_size                         big integer                      2098694720



I don't understand why the size of the columns is different if all in SQLPATH is exactly the same and the Oracle version (and patch) are at the same level.

Any ideas?

Thanks for your help!

David







------=_Part_56162_22279241.1219318566744-- -- http://www.freelists.org/webpage/oracle-l