Questions tagged [process]
The process tag has no usage guidance.
11
questions with no upvoted or accepted answers
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 ...
