Database Connection And Memory Parameters

Sep 4, 2012

I have 3 questions.

I have 11.2.0.1 database on Windows 2008 R2 SP1.

1) While connecting to the database as sysdba (sqlplus "/as sysdba"), it takes about 12 to 15 seconds what things I need to check/change so that connection will be faster?

2) Also, I have read somewhere that changing the sga/memory parameters connecting to the database. is it true?

3) This is not concerned with above 2 questions. What should be the memory parameters size for a 8 gb database?

What I have is:

Total System Global Area 1068937216 bytes
Fixed Size 2182592 bytes
Variable Size 1027605056 bytes
Database Buffers 33554432 bytes
Redo Buffers 5595136 bytes

View 14 Replies


ADVERTISEMENT

Performance Tuning :: Memory Parameters In Oracle Database 9.2.0.8

Nov 18, 2012

I have a question regarding memory parameters in oracle database 9.2.0.8, especially sga_max_size and db_cache_size. Database server has 32G of ram. Oracle parameter on server shmmax is set to 16G. Is reasonable to set sga_max_size to the same value, and db_cache_size to 80% of that size?

View 2 Replies View Related

Memory Of Each Connection?

Mar 18, 2013

Currently weblogic has 120 concurrent connections to the database.There is a requirement to scale up the number ofconcurrent connections to 300.We have did some study and quite be quite sure that the current sga and pga is required. (the additional connections will be firing the same sql which is very well tuned.

However each additional connection to the database will take up additional memory just for the connection?Will is be using the memory in the PGA? Or outside the PGA for the connection overhead?We are not using MTS.

View 19 Replies View Related

TimesTen In-Memory :: JDBC Connection - Is It TCP/IP?

Jul 18, 2012

I connection to TimesTen as follow:

String url = "jdbc:timesten:direct:dsn=my_ttdb";
String username = "ADMINISTRATOR";
String password = "";
Connection connection = DriverManager.getConnection(TestTT.url, TestTT.username, TestTT.password);

I wonder if this JDBC Connection is a TCP/IP connection on the backend? If this is not a TCP/IP connection, how can I make a connection with TimesTen via TCP/IP protocol?

dsn:my_ttdb configuration likes:
[my_ttdb]
Driver=/home/tttest/TimesTen/tt1122/lib/libtten.so
DataStore=/home/tttest/ttdata/database/my_ttdb
LogDir=/home/tttest/ttdata/logs
PermSize=40
TempSize=32
DatabaseCharacterSet=ZHS16GBK
OracleNetServiceName=orcl

View 12 Replies View Related

Memory Management - Choose Parameters For Server With A Fixed RAM?

Apr 18, 2011

the erelationship between sga_max_size,sga_targt,shared_pool_size,pga_aggregate_target and the server memory.

In short how shud i choose the above parameters for a server with a fixed RAM.

View 1 Replies View Related

TimesTen In-Memory :: Process Of Initialization Of Database Into Memory

May 23, 2013

Can i know the internal process of initialization of DB into memory in timesten , when a new connection is establishing? Will timesten create tables and indexes in RAM when first connection is established if the RAM policy is default?

want to know the internal functional flow of timesten when any command is fired against it.

View 3 Replies View Related

Server Administration :: Settings Infringe On Any Available Memory On System That Is Already Tight On Memory?

Jul 25, 2012

I have the following setup

SQL> show parameter sga;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 3G
sga_target big integer 2G

from what I read I beleive this will initially grab 2GB of memory on startup and will grab up to to 3GB of memory total for the SGA. The "total" memory can be allocated to different peices of the SGA when needed but will never exceed 3GB. Is this correct or would these settings infringe on any available memory on a system that is already tight on memory?

Secondly, what happens if both these values are set to the same value?

View 8 Replies View Related

11.2.0.3 Database Running On AIX - Memory?

Nov 12, 2012

I have a 11.2.0.3 database runing on AIX. The instance hangs and crashes due to memory usage issues. I checked the alert log of the database and this is what i see:

WARNING: Heavy swapping observed on system in last 5 mins.pct of memory swapped in [11.85%] pct of memory swapped out [3.45%]. make sure there is no memory pressure and the SGA and PGA are configured correctly. Look at DBRM trace file for more details.i also see the following in the alert.log:

Errors in file
/opt/oracle/diag/rdbms/iut3px1/iut3px1/trace/iut3px1_cjq0_55312404.trc:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared pool","select audit$,options from p...","sga heap(1,0)","kglsim object batch")

The file contents of iut3px1_cjq0_55312404.trc are:

====================
Process State Object
====================
----------------------------------------
SO: 0x70000007b97de70, type: 2, owner: 0x0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x70000007b97de70, name=process, file=ksu.h LINE:12616 ID:, pg=0

[code]...

View 3 Replies View Related

Restore A Database Into A Server With Fewer Memory?

May 12, 2013

I'm running Oracle 11.2g enterprise and we have a database on a server. We want to take a backup from this database and restore it in another database with fewer memory. In restore procedure after edition of pfile I try to restore controlfiles with my edited pfile(initdb.ora), but i'm getting an error related to memory shortage. So i decreased the amount of *.memory_target(3.5G to 2.5G) and the restore procedure continued. At the end when i try to Open database(alter database open resetlogs) i got the following error and the database does not work normally.

RMAN> alter database open resetlogs
database opened
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT row
s
ORACLE error from target database:
ORA-06553: Please-801: internal error [56319]
ORA-00604:error occurred at recursive sql level 1.

View 13 Replies View Related

How To Identify And Update The Database Parameters

May 17, 2013

I have to check some parameter values for an OID tuning I do not have sys access, I have only schema user access

Now how do I see the values of SGA_TARGET, db_cache_size etc parameter

I manage to see these var in init.ora file under /dbs folder but there are 2-3 spfile also having containing these attributes, not sure which reflect the actual.

Also can I alter also these value via schema user or do I need SYS access?

View 17 Replies View Related

Windows :: No Connection When Specifying Database Name

Jul 21, 2010

I have an issue with an Oracle 9 database where I can connect if I do not specify a database to connect to but when i do specify one i get an error. For example, my database is called WEB. If i open sqlplus and type connect username/password it will connect fine. If I type connect username/ password @web I get an error.The full error that appears in the log is:

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error

I have checked the tns entries and listener file and both are fine. Here are the entries:
TNSNAMES:

WEB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = web)
)
)
[code]....

View 3 Replies View Related

Forms :: 11g And Database Connection

May 13, 2010

I have just installed Oracle Forms 11g with the Weblogic web server. I have a local installed database, and access to our network databases also.

I can do a TNSPING and get valid results back from that. I can connect with SQL Plus, and SQL Devloper. However, I cannot connect with the Forms 11g Forms Builder. where to copy the TNSNAMES.ORA file for use with Forms 11g?

View 5 Replies View Related

Forms :: Get Live Connection To Database?

Jun 19, 2012

Our database is on one site . There is a form which is used by users on another site. The internet connection is lost sometimes and the form that they use looses connection to the database. What I would like to do on the form is whenever the connection is lost to the database i,eORA-03114,I want to reestablish the connection so that the form can be used by users all the time.

View 1 Replies View Related

RAC & Failsafe :: JDBC Connection To A 10g Database?

Mar 30, 2005

The problem i mentioned in my last posting "CRS installation/PRIF-10: failed to initialize the cluster registry" was due to the fact i was using Redhat Linux 9 that seems to have some missing packages. I installed White Box RH 3 and everything worked fine.

if it's possible to connect to a 10g RAC database using the jdbc java thin client. the java thin client requires an ip, and database sid. I am running a two node cluster and i have two ip's and a service name that uses TAF option.

View 5 Replies View Related

Forms :: Connection Between 6i And Oracle Database 11g

Jun 8, 2011

I´m just having a problem whit the connection between Oracle Forms 6i and Oracle Database 11G. Is just when i login to the database schema i cant log in using Forms.

TNS Names its already configured, No problems when i log in using Toad and using the TNS Names from Developer's 6i tool. I can log in just when i change the schema(user) password from the database (thats the rarest thing) and log into the application.

So whenever i want to login to the application i must to change the schema password, i need to use it directly.

View 2 Replies View Related

Forms :: Oracle 10g And Database Connection

Aug 8, 2011

Toady i have installed oracle forms 10g and oracle 10g db when i run my form it gives me this error how can i resolve it

"ora-12154 tns could not resolve the connect identifier specified"

View the image below:

Here are the values in forms 10g tns

# tnsnames.ora Network Configuration File: C:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
[code].......

and here the values of forms 10g SQLnet

# sqlnet.ora Network Configuration File: C:DevSuiteHome_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
(description =
# (address=(protocol=tcp)(host=localhost)(port=1383))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(connect_data=(rpc=on))
)

What changes should i make to overcome this problem.

View 1 Replies View Related

Error Database Connection Closed?

Jan 29, 2013

I am gettting error message databse connection closed itried

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

[code]...

View 10 Replies View Related

How To Provide The Description And Parameters Of Job Which Calls Package On Database

Nov 3, 2011

how to provide the description and parameters of job which calls package on database

package name is some 'xxxxx'

we need to find the job which call the package 'xxxxxx'.

View 2 Replies View Related

Data Guard :: Change Some Parameters On Primary Database?

Sep 29, 2012

I am going to change some parameters on primary database (db cache, java pool etc.). I am not sure, if the changes are automaticallly propagated to standby or if I have to make the changes manually on stanby site too? I couldn't find clear answer in documentation. how parameter changes work in dg physical configuration?

View 2 Replies View Related

RAC/ASM Clusterware Installation :: High Memory Usage By Grid / Database Installer

Oct 31, 2012

I am running oracle linux 5.7 on VMware Workstation 9 and trying to install Grid 11gr2, during installation my system freezes and I see out of memory errors. Actually Java installer is eating up too much memory over 1gb. Is there a way ? I can limit memory usage by Java process to a certain extent ?

View 1 Replies View Related

Security :: Creating Oracle Database Connection

Feb 26, 2013

Just installed the new 2.0.8 version. Its been a while I am interested on using PM for our company.The problem I have is creating an Oracle DB connection. When I create a new Oracle DB connection, and test it, Steps 3 and 4 fail.What is strange is that I followed the following procedure in PM 1.9-825 and worked fine. I am wondering if something changed in the new PM 2.0.8 version (I noticed that php_oci8.dll was commented out in php.ini).

Oracle Version is 10GR2
PM installed on clean XP sp3

1. Got a new Windows XP SP3 PC
2. Installed PM 2.0.8
3. Edited php.ini and uncommented [PHP_OCI8] and extension=php_oci8.dll
4. Installed oracle instant client “instantclient-basic-win32-10.2.0.5” in c:oracle
5. Installed oracle instant client “instantclient-sqlplus-win32-10.2.0.4” in c:oracle
6. Added c:oracle in PATH environment variable
7. Created ORACLE_HOME = c:oracle environment variable
8. Added TNS_ADMIN = c: environment variable
9. Copied working tnsnames.ora file into c:
10. Rebooted.
-------------------------------------
1. Tried sqlplus connection to my oracle db and worked.
2. Launched PM
3. Created a new process
4. Created a new DB connection as follows:
a. Engine:Oracle
b. Server:192.168.xxx.xxx
c. Database name: my_name (where my_name appears in tns_names.ora)
d. Username:my_username
e. Password:my_password
[code]....

View 1 Replies View Related

SQL & PL/SQL :: Verifying Database Connection From External Java Process?

Apr 11, 2013

Is there any way, in Oracle where I can find out if there is any process from some machine which has been successfully connected database ?

View 5 Replies View Related

Server Administration :: Database Connection Failure - Oracle Not Available

May 28, 2010

I'm getting the error messaage:

Database Connection failure. Reason: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory

I'm not an Oracle expert, but I have research a little and seems that the SID could be wrong or that the DB is down, in fact I have already checked trhe server but everything seems normal to me.

View 3 Replies View Related

Server Administration :: Oracle Database Connection Error

Mar 5, 2013

While after connecting to server via my userid( its an externally id) ,after setting ORACLE_HOME and SID, while entering sqlplus / command,its not connecting.Error am getting is:-

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HP-UX Error: 22: Invalid argument

Attaching output session.

View 16 Replies View Related

Networking And Gateways :: Database Connection From Server To Client

Jul 15, 2010

I have one query related to database connection from server to client.I have one database in the server and I want to connect from client.I set the tnsnames in client system as follows.

BAM240T_EARTH =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 10.154.119.103)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = BAM_240T.ipdc.com)
)
)

The database name is : BAM_240T.ipdc.com

Sqlnet.ora entry is

NAMES.DIRECTORY_PATH= (TNSNAMES)
NAMES.DEFAULT_DOMAIN= ipdc.com

When I connect to server I m getting the following error.

$ tnsping BA240T_EARTH

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 15-JUL-2010 15:45:35

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/10.2.0/db/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

View 16 Replies View Related

Networking And Gateways :: How To Connect To Database When LAN / USB Datacard Connection

May 12, 2011

when i am connecting to my database in command prompt,sql * plus editor is it successfully connecting to the database but not connecting with the oracle client OEM.

but after connecting the LAN it is not connecting and also in the case when i am connecting to the internet through the USB datacard it is not connecting with the oracle client OEM.

how can i connect to database when the LAN,USB datacard connection.

View 1 Replies View Related

SQL & PL/SQL :: ORA-02019 / Connection Description For Remote Database Not Found

Mar 12, 2009

I have created ".sql" script in Unix and I am trying to execute the script at SQL prompt. But I am getting the following error message after getting the output.

ORA-02019: connection description for remote database not found

Disconnected from Oracle Database 10g Enterprise Edition

Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options

View 10 Replies View Related

Server Administration :: Database Resident Connection Pooling?

Jan 3, 2011

[URL]... says that session memory is maintained in the PGA (unlike shared server) and then gives a calculation for memory usage that I don't understand: it suggests that instead of there being one PGA per session, there is one PGA per pooled server plus a small allocation of 35k per session, but this is not what I see.

It's easy to demonstrate. As sys,
exec dbms_connection_pool.start_pool
and then launch any number of session with
sqlplus scott/tiger@127.0.0.1:1521/orcl:POOLED
and you'll see a process called Lnnn launched for each session:

[code]...

There is a mention of a process called the connection broker, but I can't see this in v$process.There is more detail in the OCI developers guide [URL]... which goes beyond my knowledge of application development.

View 3 Replies View Related

Connection To Database From Sqlplus Client Refuse ORA-03135

Sep 23, 2012

I am using oracle 10.2.0.3 in AIX

From client machine , i m not able to connect, it raise error

sqlplus t24/t24@pbldr

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 23 16:21:46 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-03135: connection lost contact

Note : after restart the listener only one time I can able to login to database next time raise above error.

View 3 Replies View Related

Forms :: Frm-40514 - Operation Requires A Database Connection

Sep 7, 2010

Am running forms 10g on windows vista service pack 1 and am having problems with the FRM-40514 error. (Operation requires a database connection).

I can connect quite alright from form builder, but when i run a form it request for login credentials again. I dont understand why this is so, when am already logged on in form builder.I tried to tacke this by creating the following

DECLARE
Uname VARCHAR2(80);
Pword VARCHAR2(80);
cn VARCHAR2(80);
BEGIN
--pause;
--logout;
--message ('Logging out');
--synchronize;
[code]....

This code suppreses the logon screen and runs the form without logging on to the database. I know this because when I try to enter and execute query it brings up the message: FRM-40514: Operation requires a database connection.

View 15 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved