Host Operating System Experiencing Significant Paging

Feb 1, 2013

I"Host operating system was experiencing significant paging but no particular root cause could be detected. Investigate processes that do not belong to this instance running on the host that are consuming significant amount of virtual memory. Also consider adding more physical memory to the host."

My database run on Windows Server 2008 R2 and have 12GB of physical RAM.

Oracle version is 10.2.0.4.0 and my sga and pga are:

sga_max_size 4000M
sga_target 3904M
pga 1200M

I try to find out something about this issue and read many blogs but unfortunately I didnt find anything which worked. Should this have something to do with the fact that on the server we have oracle database and terminal server with 30-40 users?

View 15 Replies


ADVERTISEMENT

How To Get Free Space On Operating System Drive

Nov 5, 2013

is it possible to get information about free space on drive/path for example with some DBMS_*, UTL_* package or with stored function based on Java

(e.g. CREATE OR REPLACE FUNCTION GetFreeSpace(driveLetter IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'DiskSpace.getFreeBytes(java.lang.String) return java.lang.String') but for JDK 1.3 

View 8 Replies View Related

Clusterware :: Oracle Installation On Windows Operating System?

Jun 14, 2012

install oracle clusterware on Windows Operating system

View 4 Replies View Related

Server Administration :: Unable To Claim Space For Operating System?

Sep 15, 2012

We are in the process of gaining some space in our database. We identified a tablespace that occupied around 400GB of space. The datas are required for us. Hence, we truncated (with drop storage) the tables, gathered statistics and shrinked the tables. After doing that we found the datafile occupied around 32GB of space. We tried to resize it to 5 GB and we got "ORA-03297: file contains used data beyond requested RESIZE value". We could see that size in dba_free_space against that tablespace. We would like to give back everything to OS.

We also tried exporting the tablespace without rows, dropped the tablespace and re-created and imported again. But the datafile grows to around 32G and we are unable to resize it.

We are sure that the tablespace has only the table definitions without data. But we do not know why is it occupying around 32G of space and we could see that size in dba_free_space. We would like to give back everything to OS. How can we do that?

View 5 Replies View Related

Forms :: Uploading Image Which Is Not Database Item From Operating System?

Sep 13, 2010

uploading an image item which is not a database item from the operating system. I am using forms 10g on db 10g. My platform is windows Vista sp1.

I am trying to use
GO_ITEM('BEEEE');
Set_Custom_Property( 'SALGRADE.BEEEE',1, 'READIMGFILE', 'C:/users/ajayia/Desktop/Beeee.jpg' ) ;

But I just get a blank image on runform. I am using WHEN-NEW-BLOCK-INSTANCE trigger. I have tried it on when-new-form-instance, but also not working. The file am trying to upload is a JPG file format, but i cant find the file type in forms image item property. What can I change it to. Or how to i go about changing it.

View 1 Replies View Related

Server Administration :: Remove Datafile From Operating System After Dropping Its Tablespace

Jul 26, 2012

I want to remove a tablespace with it's datafile.

I've ran: DROP TABLESPACE x_tbs INCLUDING CONTENTS;

I've read(should have read it prior to action) [URL]tm

and I understand now that I should have stated "AND DATAFILES", However, too late now. the tablespace is removed, but the datafile x_tbs is still present in a folder of my OS.

Is it safe to manually remove it by deleting it from the operating system?

View 2 Replies View Related

Forms :: How To Know Operating System Current Path In Oracle 10g Forms

Apr 19, 2011

How to Know Operating System Current Path in oracle 10g forms ?

View 4 Replies View Related

OLE DB :: How To Fetch Host Database In System To Run Web Application

Nov 4, 2012

i am having database in server and i have to run my web application in client machine. how to set the connection of server database in web.config file.

View 1 Replies View Related

Performance Tuning :: No Significant Database Activity To Run ADDM

Apr 11, 2012

As there was a database performance, we started to analyse the issue by running ADDM using below.

@?/rdbms/admin/addmrpt.sql.

The result of running ADD is below.

DETAILED ADDM REPORT FOR TASK 'TASK_64718' WITH ID 64718
Analysis Period: 10-APR-2012 from 06:00:15 to 07:00:22
Database ID/Instance: 324353546/1
Database/Instance Names: JACK/jack1
Host Name: fdsfggwe001
[code].....

There was no significant database activity to run the ADDM.The database's maintenance windows were active during 100% of the analysis period.The analysis of I/O performance is based on the default assumption that the average read time for one database block is 10000 micro-seconds. An explanation of the terminology used in this report is available when you run the report with the 'ALL' level of detail.

Current parameters set in database are below

statistics_level ---- string
timed_statistics --- boolean

1.Do i need to set the initialization parameter to some other value?

2.should i run the below command before executing the ADD report ? exec dbms_workload_repository.create_snapshot();

View 10 Replies View Related

High Paging Space For Background Processes

Mar 7, 2013

in my old database 9.2 (on AIX) i see high paging space usage for background processes.

#> svmon -Pg -t 1 |grep Pid ; svmon -Pg -t 10 |grep "N"
     Pid Command          Inuse      Pin     Pgsp  Virtual 64-bit Mthrd  16MB
2285578 oracle          304609    81552   500909   605395      Y     N     N
3350676 oracle          304588    81552   500643   605149      Y     N     N
1794254 oracle          304592    81552   500634   605126      Y     N     N
[code]....

View 7 Replies View Related

Performance Tuning :: How To Check If Paging Happening While Running The Query

Sep 26, 2013

How can i check if paging happening while running the query. As i have 4gb of PGA target but the query is taking long time in parallel and has hash join.

how to check paging in 11gr2

View 3 Replies View Related

Application Express :: JavaScript - Execute When Page Loads Not Working When Paging Results Grid

Aug 12, 2013

I have some Javascript in an Apex page, running in 'Execute when page loads'. It does some stuff to a results grid. It works fine on page load, but then doesn't run when I page through, or sort the grid. I presume this is because the grid is being sorted / paged using Ajax, which means the page isn't being fully loaded. Is there anywhere else I can put the code so it gets applied to the grid on sorts and paging?

View 2 Replies View Related

Forms :: Difference Between System.current_item And System.cursor_item?

Apr 1, 2012

We have system.current_item and system.cursor_item.....

both represent the same....

like this we have few other system variables also .....

what is the main difference between current_item and cursor_item?

View 2 Replies View Related

CPU System Time (percentage) For Multi Core System?

Aug 21, 2012

couple of questions about below parameters, do they measure single processor or avg usage across all processorss and cpus for example will i recieve alert if CPU system time goes above 95% for single processors? or not

CPU Idle Time (%)
CPU System Time (%)
CPU User Time (%)

View 1 Replies View Related

Two SIDs On One Host With Same Name

Oct 29, 2010

We are going to test migration of g10 to g11. To reduce maintenance of configuration we want to install new Oracle on the same server and start on the same port with the same SID. To achieve that we are going to configure new Oracle on different IP and hostname (managed by DNS, whatever). So listener will be configured like for different servers with identical SIDs.

View 5 Replies View Related

Duplicate Database To Another Host

Mar 10, 2013

I will be duplicating my production database back to a few weeks ago on my test server, to retrieve certain data. I am running 11g standard edition, not using a recovery catalog.

Below are the basic steps I plan to take in a nutshell.

1. Copy the backup files to the test system

2. In the rman run block (on the test server)
A. Set newname for each of the datafiles and tempfiles (don't have many files)
B. Duplicate command to point in time, specifying backup location and no filename check.

3. Export the data

View 6 Replies View Related

Windows :: How To Set Host Credential

Jun 3, 2011

I am using windows 7 as my platform...I am not able to set host credential in my system. I want to know how to set host credential in windows 7.

View -1 Replies View Related

SQL & PL/SQL :: QUERY - Host Name And Max Logon Day?

Oct 27, 2010

I want to host name and max logon day from the below query But host name not belongs to start with 'IRS%' and 'EMEAUKIMIV00023828'.

My question is How to handle the backslash in oracle 8i and also check the below query is ok or not,

select host, max(logon_day) from (
select host,logon_day from system.stats$user_log
where host not like 'IRS%'
AND not in ('EMEAUKIMIV00023828'))
group by host;

View 10 Replies View Related

SQL & PL/SQL :: Bind And Host Variables

Dec 22, 2011

i have some confusion with bind and host variable.

View 4 Replies View Related

Performance Tuning :: How To Know Host Name Using Sql ID Or SID

Jul 11, 2012

Here i have three tier application. I want to know it host name from sid or sqlid . I want to know which query run on which host. Because i have one user from application to database. So i want to know which query consume more time on which host ?

View 19 Replies View Related

SQL & PL/SQL :: Retrieve Host Name For Small App

May 12, 2010

I have a cluster setup, and i want to retrieve host name for my small app.Is there any query which gives me the HOSTNAME where oracle is running??

View 14 Replies View Related

Forms :: Host Procedure On 6i?

Dec 28, 2009

I've got a problem when I use the HOST procedure to work with DOS Prompt. When I access the DOS Prompt via Oracle Forms HOST Procedure, the name of files and folders got limited by 8 chars plus extension. Lets suppose I want to copy a file and the file name is my_image.jpg. What I have to do is:

HOST('copy MY_IMA~1 C:TEMPIMAGE01');

I guess it sucks cause the function GET_FILE_NAME give me the filename as my_image.jpg. Do I have to convert the filename every time?

View 15 Replies View Related

Connect To Run +ASM Instance From A Different Host?

Aug 13, 2012

Is it possible, Oracle let me connect to an running +ASM instance from a different host? I.E, +ASM running on X host and i want to connect from Y host. (yes Y host has the asm entry in the tnsnames.ora).

View 1 Replies View Related

Move Database To New Host With More RAM / CPU

Apr 10, 2013

We plan to move the database to a new host with much more RAM, CPU. The new database server will have exactly the same OS version, Kernel version and the same version of database / grid standalone (ASM). I will have to install OS, Database software, Grid Standalone on the new server.

The current version of the database is 11.2.0.3.0 Enterprise Edition and the OS version is Oracle Enterprise Linux 6.3. However, we plan to use the same disks (ASM disks). I believe I don't need to use RMAN to do the migration, Is it correct?

View 7 Replies View Related

Moving Databases To New Host Server?

Oct 7, 2012

I have a requirement to move the databases to a new server.

Existing set up:

database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.2
OS - UNIX AIX-5.3

New Server (setup):

database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.3
OS - UNIX AIX-6.1

My query is what is the best way to move the database to new server(UNIX AIX 6.1)?

a) can i upgrade the database to 11.2.0.3 before moving to new server or its better to move the database in 11.2.0.2 and then upgrade there?

b)is export and import of database can work for moving this?

c) RMAN backup and restoration can be done for moving databases?

d)simply moving all the related files to new server and start upgrading it from there?

View 8 Replies View Related

Backup & Recovery :: How To Restore In A New Host

Jun 27, 2012

I have backup my database,and i want to create a new database in a new host using the backupset?

View 3 Replies View Related

Forms :: Host Common On Linux

Oct 27, 2010

My database as well as application on linux. I want to execute this command on linux. I need equivalent code.

host('cmd /c E:data empITC1'.bat');

code of ITC1.bat is
echo off
sqlldr userid=user_name/pass@database control=E:data empITC1.ctl log=E:data emplogITC1.log

echo ........

control file as well as bat file exist in respective folders.

View 9 Replies View Related

Enterprise Manager :: Host Credentials For 11g

May 14, 2013

I am trying to use Database Replay in 11g Release 1 using Enterprise Manager. In the last step it asks for 'Host Credentials' to start the capture. But when i give the username and password for the host, it throws error as 'Invalid username/password' all the time.

View 15 Replies View Related

Database Cannot Startup After Host Crash

Feb 14, 2013

the db cannot startup after host crash.

the strange thing is "lkinstrdmetdev" is the wrong name(sid is rdmetdev), and the file does not exist in the FS too. the correct file name should be "lkrdmetdev" and i've deleted this file from the directory. I did not do any changes. and no any oralce processes running while i started up the oracle instance.

Thu Feb 14 09:25:20 EST 2013
sculkget: failed to lock /u01/app/oracle/product/10.2/dbs/lkinstrdmetdev exclusive
Thu Feb 14 09:25:20 EST 2013
sculkget: lock held by PID: 272600512
Thu Feb 14 09:25:20 EST 2013
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.
Thu Feb 14 09:25:20 EST 2013
Failed to acquire instance startup/shutdown serialization primitive
[code]....

Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Failed to acquire instance startup/ shutdown serialization primitive

View 17 Replies View Related

Any Built-in Function (HOST) In Oracle

May 30, 2012

saw in one procedure using host function in below manner.

v_status:= host(v_cmd);

But i searched for the host function it is not available.

My question is --Is there any pre defined built-in function "host" in oracle 10g.

View 1 Replies View Related







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