Search Results

Hi Cero,

Thanks for your help on this. You were in the ball park and I used your execute immediate statement. Here is the final solution that I was looking for.

CREATE OR REPLACE...

Morning
This output is not what I was looking for. The correct answer can be found in the user_ tables.

connect as HR

SQL> col table_name format a30
select table_name, num_rows counter...

Hi All,
I have a syntax problem with a procedure in oracle. I am looking to just produce the number of rows
from each table located in the HR schema nothing complex. This procedure works great up...

Good Morning Don,

Hope you had a nice 4th of July.

Here is the output that I found. It is a bit unusual.

$ grep -v "^#" /var/opt/oracle/oratab|od -bc
0000000 012 012 012 012 104...

I am using the vi editor. thanks for your response.

Hi All,
I did a review of some threads to see if someone had come across this problem.

My system is an oracle virtual box solaris 10 installed on a windows 10 system.

Right now I am...

I found the problem:


grep -v [#] oratab | /usr/xpg4/bin/awk 'BEGIN { RS = ":" } ; /Y/ { print $1, $3 }'


The RS in the begin statement should have read FS.

this thread can be...

Good Moring,
I am currently reading about awk in a manual and following the examples using the oratab file.
My system is SOLARIS 10
I think I am getting strange behavior judging by what the book...

Morning,

I will put your explanation in my note book.

That is what I was surmising but wasn't sure. I am some what familiar with programming but never really had a chance to get my head into...

Hi Chubler,

Just received your message and will try this tomorrow at work.. I saw that FILENAME and after reading about it knew it would be applied some where some how.

thanks

I will...

Hi

No rush we are all busy.

I wrote up a detail for ease of understanding. Sorry if it is long. See below:

My operating system is:

OPERATING SYSTEM:
uname -a
SunOS snslcsunu04...

Hi everyone,

Can someone look this over?

find /oracle/diag/rdbms/*/*/trace -type f -name '*d00*.trc' -mtime 0 \
-exec egrep -c 'TNS-12535: TNS:operation timed out' '{}' '+' |
...

Morning,

Thanks for this. I will run it and get back to you on the results today.

regards
al

---------- Post updated at 07:11 AM ---------- Previous update was at 06:57 AM ----------
...

Hi Vgers
Have to admit I am really new at this and am trying to learn by reading and doing.

The code that I listed was wrong I was just trying something. I tried your code and it returned a...

Hi,
I have a question, during my readings it appears that these two variables in the snippet below need to be on the same line to return a “true” answer and listed in the output otherwise it won’t...

Hi All,
Solaris 10 o/s
With your help I developed the following script.
find /oracle/diag/rdbms/*/*/trace -type f -name '*d00*.trc' -mtime 0 -exec egrep –c 'NS Primary Error' '{}' '+'
which...

Hi ,

Here is the final solution that works for me. I spent 3 hours learning about the syntax and making adjustments. This I am presently using at work.

find /oracle/diag/rdbms/*/*/trace -type f...

Hi,
Using solaris 10 5.10 o/s
I am learning awk as I work here on the job.
What I need to do is isolate the trace file for the last 24 hours. After that I need to open those trace files and...

Good Morning,

Thank you for the quick response. All this bash scripting is new to me so I will go over in great detail what was just written to understand this code. I need to get this stuff in...

Hi Everyone,
I am a bit new at learning this bash syntax. I have a problem at work that needs to be addressed. We find we are spending quite a bit of time killing old processes created by oracle...

I got this running properly. I will post it tonight as the final solution.

Evening,

We are in the process of testing the script now. I had help with the fine details of this thing.

We I see that it is properly working I will post the results on the board.
...

It will but I need to get some knowledge first.

thanks

al

Hi Methyl,

Thanks for the advice. This evening I did some research on syntax which I was in dire need of knowing and found a good tutorial. In it is showed how to use the $? in a if statement. ...

Hi

The reasoning I am trying to corral this is as follows.

We have two databases one here and the other in Europe replicating. There is one large table over 8 mil rows that has fallen way...