Hi..
Yep it's still a problem....
i can direct it to a $PPID.sql file, but how to catch that number to start.....
SQL> !echo define a=$PPID >$PPID.sql
SQL> @$PPID
SP2-0310: unable to open file "$PPID"
And yes there is now a file with 12345.sql but now i must start that sql with...
Hi Sem...
We cannot connect (yet) because we are making a new login procedure with encrypted password program....
after we have a unique number for the sqlplus process, we create an tempory file (with this number) where the connect string is in the (new)(temporarily)sql-script....
for example...
Sorry Sem...
For your info i am working on AIX 5.2 ML5...
SQL> !echo -e select $PPID' a from dual \n/'>1.sql
column a new_value b
@1
SQL> SQL> SP2-0734: unknown command beginning "-e select ..." - rest of line ignored.
SP2-0103: Nothing in SQL buffer to run.
Thanks Dima...
But PPID reflects on that moment not the OS Process ID from the sqlplus command....
and that is the one i want to have....(this reflects the ProcesID from the OS-shell and not the sqlplus process id)
and when i am in sqlplus and than starts the ! or host command the OS-variable...
Hi,
I want to fill an sqlplus variable with the output of an external command, but before the connect to a database...
So:
# sqlplus /nolog
sql >!echo $PPID
123456
and now i want to fill (with define?) an variable (let see ospid) with 123456
but how?
Greetings
Peter
Hi,
My problem (or is it realy a problem...) that i get a lot of errors in the daemon.log (AIX 4.3.3)
These probems occur every minute
# tail -10 daemon.log
Nov 12 08:25:32 hostname named[51378]: sysquery: nlookup error on ?
Nov 12 08:26:51 hostname last message repeated 11 times
Nov 12...
Hi,
Yes i know about disk 4&0...
There are the rede-log file's from Oracle... so with 1000 users those file's are continue updated...
And so spread is no option because another disk will olso be very busy....
Or do you know another solution to spread redo-logs from oracle...
The problem with...
Hi Bjverzal,
No we see no errors in the errpt...
No we are not using Jumbo Frames.. We tried it but with our network cards the network went down if we down/uploaded very big file's... we never discovered why....
No we have still retransmitted packages...
# netstat -p tcp
tcp...
Hi,
I have encountered a lot of network issues on our networkcard.
We have a IBM P-series server & AIX 4.3.3
The networkcard is a Gigabit Ethernet-SX PCI Adapter (14100401)
When we look at "netstat -p tcp"; and calculate packet retransmitted/data packacts sent it is more than 17% and...
Hi Ali,
We want to minimize the swapping computationalpages to pagingspace(disk)...
Swapping from filepages to disk is therefore the more wanted situation...
Do you know if there is an administration of computational or filepage kept in memory?
OR....
We are using NFS (and the most...
Dear Raztaboule,
Hereby the output your requested...
Ofcourse it wasn't so very busy today on the system....
The proble occured around 2 months ago, befoe that there wasn't swapping (paging to disk) at all. (the normal 1%)
But the last weeks we have seen it grow to now 24%
And i think because...
Hi,
We have a seriuos performance problem with our AIX-P-series server & AIX 4.3.3
The P-series is a S85 server with 8 CPU and 24 GB internal memory (and 6 GB Paging space)
We are using a Oracle 8.1.7 database and have around 1000 oracle connections.
The last month we are have more and more...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.