We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [process]

The tag has no usage guidance.

11 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
67 views

How to analyze postgres client process/session memory

Is there a way to check how much of process memory is allocated for the specific buffer for a running postgres session (work memory, temp buffers, plan cache etc ... )? I'm asking because i want to ...
2
votes
0answers
837 views

How to unlock / repair mysql.sock

My issues have spawned from file permission changes leading to the popular ERROR! MySQL server PID file could not be found! error. However, I believe I've repaired them, but still cannot restart MySQL....
2
votes
0answers
136 views

Can data streams from Informatica to SQL Server be multi-threaded?

Suppose we have a database server, with SQL Server on it. And we are moving data from another database server, through our Informatica server, and onto that SQL Server database server. And our SQL ...
1
vote
0answers
20 views

SQL Agent Job: Seeking Process flow advice on managing steps

Fellow DBAs, I need some practical advice on how to solve a job timing issue on different servers. I have a SQL Agent job that currently has steps 1-10. Step #8 has a dependency on a SQL Agent job on ...
1
vote
0answers
67 views

How to set processes parameter in oracle 11g Windows in accordance with RAM in the server

Could anyone explain me whether there is any limitation in setting processes parameter in Oracle 11gr2 and how to set sga_target according to this. Right now I have set the processes to 4000 and I ...
1
vote
0answers
208 views

Reduce RAM required to process OLAP cube

I have a cube which I have created by using (in Visual studio) New Project -> Import from Server (Multidimensional and data mining). This cube is indeed created from the metadata of an already ...
1
vote
0answers
311 views

EXTPROC issue during 10g to 11g database

I am currently 10g to 11g database migration and trying to configure EXTPROC. EXTPROC32 was configured as part of 10g to execute C++ library and working fine. It appears that 11g does not provided ...
0
votes
0answers
18 views

NULL queries getting stuck and using up connections

Running show processlist in phpmyadmin for me often shows queries with an Info of NULL and a Time of apparently a few seconds, but which have in fact been stuck there for a long time (each time I run ...
0
votes
0answers
60 views

backups taking longer to run, has anything within sql server changed?

The following is an email from one of my colleagues about an hour ago: Any Idea why the backup time has gone up from 2.5 hrs to 5.5 hours since the 16th Sept? The duration has remained ...
0
votes
0answers
744 views

How to tell which process in SQL Server I should kill?

I am having an issue with an application as it is running supper slow. I don't know if it is a database issue or something else as the is nothing that I can find to be the issue. I tried select * ...
0
votes
0answers
836 views

Oracle prevent CPU usage per process/session

I have an Oracle instance to which several applications from different machines connect (http servers). Normally Oracle CPU usage is ~5-10% even on high server loads. But from time to time, one of ...