Re: Hints on optimizing Oracle!

From: Adrian Harrison <adrianh_at_globalnet.co.uk>
Date: Mon, 02 Nov 1998 11:36:42 GMT
Message-ID: <363d97f2.1797654@news.globalnet.co.uk>

Murali,

Have copied contents of all *.ORA files below - hope this is what you meant!

To change the protocol order do I have to remove all current protocols and reload then TCP/IP first or is there a better way?

When you ask "Does your system swap memory?" I assume you mean do you have aswapfile setup - the answer is yes 100mb on a SCSI disk - my main disk is an IDE one because I had lots of problems trying to boot from a SCSI disk when an IDE one was present in the system!

 You may consider stopping unwanted services. Also, remove

LISTENER.ORA

///////////////////////////////////////////////////////////////////////////////////
################
# Filename......: listener.ora
# Node..........: local.world

# Date..........: 24-MAY-94 13:23:20

################

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= oracle.world)


        )
        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= ORCL)


        )
        (ADDRESS=


          (COMMUNITY= NMP.world)


          (PROTOCOL= NMP)


          (SERVER= P300)


          (PIPE= ORAPIPE)


        )
        (ADDRESS=


          (COMMUNITY= TCP.world)


          (Host = p300)


          (PROTOCOL= TCP)


          (Port= 1521)


        )
        (ADDRESS=


          (COMMUNITY= TCP.world)


          (Host = 127.0.0.1)


          (PROTOCOL= TCP)


          (Port= 1521)


        )
        (ADDRESS=


          (COMMUNITY= TCP.world)


          (Host = p300)


          (PROTOCOL= TCP)


          (Port= 1526)


        )
        (ADDRESS= 


          (COMMUNITY= SPX.world)


          (PROTOCOL= SPX)


          (Service= p300_lsnr)


        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )
PASSWORDS_LISTENER = (oracle)

///////////////////////////////////////////////////////////////////////////////////

SQLNER.ORA

///////////////////////////////////////////////////////////////////////////////////

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world
names.default_domain=world

///////////////////////////////////////////////////////////////////////////////////

TNSNAMES.ORA

///////////////////////////////////////////////////////////////////////////////////
#This is a SQL*Net Configuration file generated by SQL*Net Easy Configuration.

#Attention: Do not modify this file yourself. #If you do, your SQL*Net Easy Configuration may not function properly.       

Example1.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = Production1)


          (Port = 1521)


        )

    )
    (CONNECT_DATA = (SID = SID1)
    )
  )
Example2.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = spx.world)


          (PROTOCOL = SPX)


          (Service = Server_lsnr)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Example3.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = nmp.world)


          (PROTOCOL = NMP)


          (Server = FinanceServer1)


          (Pipe = ORAPIPE)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Tcp-loopback.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = 127.0.0.1)


          (Port = 1521)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Beq-Local.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = beq.world)


          (PROTOCOL = BEQ)


          (PROGRAM = oracle73)


          (ARGV0 = oracle73ORCL)


          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
p300.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = p300)


          (Port = 1521)


        )
        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = p300)


          (Port = 1526)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
comtest.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = swat)


          (Port = 1521)


        )
        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = swat)


          (Port = 1526)


        )

    )
    (CONNECT_DATA = (SID = comtest)
    )
  )
litmus.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = 146.213.11.12)


          (Port = 1521)


        )
        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = 146.213.11.12)


          (Port = 1526)


        )

    )
    (CONNECT_DATA = (SID = litmus)
    )
  )
p133.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = p133)


          (Port = 1521)


        )
        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = p133)


          (Port = 1526)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
cdstest.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = 146.213.80.27)


          (Port = 1521)


        )
        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = 146.213.80.27)


          (Port = 1526)


        )

    )
    (CONNECT_DATA = (SID = cdstest)
    )
  )

///////////////////////////////////////////////////////////////////////////////////

Thanks once again!

Adrian Harrison

On Sun, 1 Nov 1998 12:59:22 -0800, "Murali Kazhipurath" <murali_at_jps.net> wrote:

>You can find  SQL*Net configuration files in the directory
>c:\orant\network\admin (assuming that c:\orant is your ORACLE_HOME). They
>have the extension .ORA.
>
>Your hardware seems adequate. Now as far as you can tell, does your system
>swap memory? You may consider stopping unwanted services. Also, remove
>unwanted network protocols. Another thing to pay attention to is the order
>of precedence of the network protocols. Make sure that TCP/IP is top in the
>list.
>
>Murali
>
>
>
>Adrian Harrison wrote in message
><363c671a.12048064_at_read.news.globalnet.co.uk>...
>>Mural,
>>
>>I'm using a PII 300, 128mb ram, 3.8 IDE & 4.3 SCSI Harddisk!
>>
>>I have TCP/IP, Netbios & IPX running!
>>
>>20 services started - don't know what most of them are!
>>
>>Where do I find my "SQL*Net configuration information"?
>>
>>Thanks
>>
>>Adrian Harrison
>

Received on Mon Nov 02 1998 - 05:36:42 CST