09-15-2009
I get one Oracle audit log every time a priviliged user connects to the database (for example for startup and shutdown). Because my database is stop/started daily for backup these logs accumulate rapidly and I normally only keep a week's worth. Similarly for Oracle alert logs, Oracle listener logs adn Oracle trace logs.
Your situation may be different.
What are you trying to do?
10 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
Can I back up all the files I work with each day using tar? (2 Replies)
Discussion started by: jo calamine
2 Replies
2. UNIX for Dummies Questions & Answers
Is there a command or shell script which can be used for Finding all files created by a specified userid in a directory and its subdirectories.
Say, I want to find all such files in directory /abc as well as in all the subdirectories such as /abc/xyz or /abc/xyz/pqr aqnd so on which was created... (5 Replies)
Discussion started by: abhilashnair
5 Replies
3. Shell Programming and Scripting
find . -name *.txt -mmin -30
This is working in Redhat but not in Solaris..
What is the equivalent option in Solaris? (1 Reply)
Discussion started by: tene
1 Replies
4. UNIX for Dummies Questions & Answers
HI,
I have 2 questions.
1>
Is there any code to see files that created some day or some time before in a directory???
2>
how or where i will find the last exit status of a process??
thanks (6 Replies)
Discussion started by: jyotidas
6 Replies
5. Shell Programming and Scripting
Hi,
I need to find all files of particular day lets say for 2nd august in below.
-rw-r--r-- 1 skl eusdc 8168 Aug 5 19:31 aabc123.txt
-rw-r--r-- 1 skl eusdc 4251 Aug 5 19:31 aabc124.txt
-rw-r--r-- 1 skl eusdc 4252 Aug 6 19:31 aabc125.txt
-rw-r--r-- ... (15 Replies)
Discussion started by: sachinkl
15 Replies
6. Shell Programming and Scripting
what is the find to command to find the files created last 30 days (5 Replies)
Discussion started by: rajkumar_g
5 Replies
7. Shell Programming and Scripting
Hi,
I want to find the sum of all the files created 5 days ago and store it in a variable. (os is HP-UX)
can this be extracted from ls -l
Is there any other way of getting the sum of all the files created (4 Replies)
Discussion started by: bang_dba
4 Replies
8. Shell Programming and Scripting
Dear All,
I want a Hp Ux command to find out the files created today in a particular directory or mountpoint.
Kindly help.
Thanks
Bhaskar (10 Replies)
Discussion started by: sudiptabhaskar
10 Replies
9. Shell Programming and Scripting
Hi,
I want to display the file names and the record count for the files in the 2nd column for the files created today.
i have written the below command which is listing the file names. but while piping the above command to the wc -l command
its not working for me.
ls -l... (5 Replies)
Discussion started by: Showdown
5 Replies
10. Shell Programming and Scripting
Hi Gurus,
I want to find the file created within one hour in solaris.
I have tried below command, but it is no lucky.
$find . -mtime -1/24, -name "abc*"
above command give me the file name which created two hours ago
find . -cmin -60, -name "abc*"
above command I got error as... (4 Replies)
Discussion started by: ken6503
4 Replies
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::oracle::wherejoins5.18
DBIx::Class::Storage::DBI::Oracle::WhereJoins(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)
NAME
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI).
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
DBIx::Class should automagically detect Oracle and use this module with no work from you.
DESCRIPTION
This class implements Oracle's WhereJoin support. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the SQL query, it's already too late.
METHODS
See DBIx::Class::SQLMaker::OracleJoins for implementation details.
BUGS
Does not support full outer joins. Probably lots more.
SEE ALSO
DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::OracleJoins
DBIx::Class::Storage::DBI::Oracle::Generic
DBIx::Class
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.18.2 2013-07-12 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)