02-12-2010
Quote:
Originally Posted by
trendzy2010
The DB operations are independent of shared mem.
I see.
Whenever you modify the DB, you
must update the shared mem. If you can't, there's no point in having it -- its contents can't be trusted. If the database isn't fast enough to rely on, you need a faster backend, or an improved interface to it -- try prepared queries, procedures, views. Try keeping a persistent connection somewhere instead of making a new one all the time.
Last edited by Corona688; 02-12-2010 at 02:30 PM..
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it.
thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies
2. UNIX for Advanced & Expert Users
Hi all,
i am new to the unix enviorment i have got a urgent requirement where we need to migrate the date from the folder heirachy that contains the "IMAGES". These images are to be uploaded on to the database table.
Uploading images from the a single folder (Static) to the... (0 Replies)
Discussion started by: shashisaini24
0 Replies
3. Shell Programming and Scripting
I want to connect to one database and collect data from any table using shell script. (0 Replies)
Discussion started by: rinku
0 Replies
4. UNIX for Dummies Questions & Answers
Hi, I want to create a table on our unix box that allows the user to tab through it and select certain option by putting an asterix or similair into it.
e.g.
--------------
|Start App | |
|Stop App |*|
etc...
Can this be done using a script (never seen any graphics options in ksh, but... (2 Replies)
Discussion started by: dlam
2 Replies
5. Shell Programming and Scripting
Hi ,
I have inserted some records in a table having column "value1 varchar2(4000)" and want to spool in a file.
I have written as below
set echo off
set feed off
set hea off
set wra off
set lin 500
spo temp_table
and fired select query as below
select value1 from temp_table;
spo... (6 Replies)
Discussion started by: CaapAjayShukla
6 Replies
6. UNIX for Advanced & Expert Users
Hello
I have 2 servers that need a database table to be one way synchronized (server A needs to push the table to server B)
I considered using a FEDERATED DB, but decided against it for my particular application (Server B has several apps that would be calling the table repeatedly, and a... (3 Replies)
Discussion started by: kettlewell
3 Replies
7. UNIX for Advanced & Expert Users
Hello
Hope someone can help with this problem. We are running Solaris 10 with a current kernel patch of 142900-09.
We appear to be getting a serious issue with the routing table as shown below:
Output from netstat -rnv
Destination ....Mask ............Gateway ........Device... (2 Replies)
Discussion started by: gregsih
2 Replies
8. AIX
Hello,
I was trying to install python on aix and it was taking too long and I closed the terminal.
Now when i issue the command rpm -qa instead of getting all the rpms installed I'm getting the following error.
root:stud -> $ rpm -qa
cannot get shared lock on database
rpmQuery: rpmdbOpen()... (2 Replies)
Discussion started by: gaugeta
2 Replies
9. Shell Programming and Scripting
Im trying to update an informix database table for each occurance of a head_barcode in a file called mw within a for loop
please see below - cant get the syntax correct. any help please?
for a in `cat /tmp/mw`
do
sql image - << STOP > /dev/null 2>&1
update doc_table set status =... (4 Replies)
Discussion started by: worky
4 Replies
MEM(4) Linux Programmer's Manual MEM(4)
NAME
mem, kmem, port - system memory, kernel memory and system ports
DESCRIPTION
mem is a character device file that is an image of the main memory of the computer. It may be used, for example, to examine (and even
patch) the system.
Byte addresses in mem are interpreted as physical memory addresses. References to nonexistent locations cause errors to be returned.
Examining and patching is likely to lead to unexpected results when read-only or write-only bits are present.
It is typically created by:
mknod -m 660 /dev/mem c 1 1
chown root:kmem /dev/mem
The file kmem is the same as mem, except that the kernel virtual memory rather than physical memory is accessed.
It is typically created by:
mknod -m 640 /dev/kmem c 1 2
chown root:kmem /dev/kmem
port is similar to mem, but the I/O ports are accessed.
It is typically created by:
mknod -m 660 /dev/port c 1 4
chown root:mem /dev/port
FILES
/dev/mem
/dev/kmem
/dev/port
SEE ALSO
chown(1), mknod(1), ioperm(2)
COLOPHON
This page is part of release 3.25 of the Linux man-pages project. A description of the project, and information about reporting bugs, can
be found at http://www.kernel.org/doc/man-pages/.
Linux 1992-11-21 MEM(4)