10 More Discussions You Might Find Interesting
1. BSD
Heyas
Since freebsd has set TERM to xterm when in terminal mode, i'm very curious what its value will be in GUI mode - seems its xterm (in x11/twm) as well.. how smart :eek: :(
So i've installed: awesome and xorg, but when calling awesome, it talks something about invalid display.
So i've... (1 Reply)
Discussion started by: sea
1 Replies
2. UNIX for Dummies Questions & Answers
All the autosys jobs are on server-1 and server-1 has been crashed due to some reason, Now I have to run 5 autosys jobs on server-2 (failover server) which are on server 1.
How to do with Autosys command (which command needs to fired on JIL) (0 Replies)
Discussion started by: tp2115
0 Replies
3. AIX
Hi,
I have a problem about loaded shared libraries. I'm issuing ‘procldd' for a process and AIX shows me the loaded shared libraries. I'm collecting these libraries and counting their size. They were 350MB. After this, I'm issuing ‘ps vx' and I'm seeing that the process takes 130MB from AIX's... (1 Reply)
Discussion started by: jhatzics
1 Replies
4. SCO
hi
Howto find out which driver (module) were loaded during the startup of SCO 5.0.6? (5 Replies)
Discussion started by: ccc
5 Replies
5. Shell Programming and Scripting
Hi All,
I have trying to schedule an autosys job and it is failing. The shutdown script runs fine by itself from the UNIX box but fails when i try to schedule it through autosys.
I have compared user.env with auto.env (variables obtained through an autosys script) and updated my profile... (1 Reply)
Discussion started by: userscript
1 Replies
6. Infrastructure Monitoring
Hello
I really wonder what's trap in etc/profile and in each user .profile.
I try to google for it but I think I have no luck. Mostly hit is SNMP traps which I think it is not the same thing.
I want to know ...
1. What's a "trap 2 3" means and are there any other value I can set... (4 Replies)
Discussion started by: Smith
4 Replies
7. UNIX for Advanced & Expert Users
I am trying to install a scientific program onto my mac and when i try and execute it this error comes up and i cant find any literature on the net to fix it...
dyld: Library not loaded: /usr/local/lib/libgfortran.2.dylib
Referenced from:... (4 Replies)
Discussion started by: olifu02
4 Replies
8. UNIX for Advanced & Expert Users
My project uses Autosys.
I am new to this product and I don't know where to start from.
Q1. Please provide me the link where I can get Autosys documentation
Q2. Please refer a good book on Autosys. (Beginner/Intermediate Level) (0 Replies)
Discussion started by: gram77
0 Replies
9. Programming
how to get the list of all dynamically loaded libraries in memory ?thanks! (3 Replies)
Discussion started by: rainshadow
3 Replies
10. UNIX for Dummies Questions & Answers
hi , i added ls -F to .profile. and i need to do ./.profile for the effect to take effect BUT i didnt and YET the next day when i came to work and log in, the changes took effect. i am on aix.
please explain..
thanks (4 Replies)
Discussion started by: yls177
4 Replies
DBI::ProfileDumper(3) User Contributed Perl Documentation DBI::ProfileDumper(3)
NAME
DBI::ProfileDumper - profile DBI usage and output data to a file
SYNOPSIS
To profile an existing program using DBI::ProfileDumper, set the DBI_PROFILE environment variable and run your program as usual. For exam-
ple, using bash:
DBI_PROFILE=DBI::ProfileDumper program.pl
Then analyze the generated file (dbi.prof) with dbiprof:
dbiprof
You can also activate DBI::ProfileDumper from within your code:
use DBI;
# profile with default path (2) and output file (dbi.prof)
$dbh->{Profile} = "DBI::ProfileDumper";
# same thing, spelled out
$dbh->{Profile} = "2/DBI::ProfileDumper/File/dbi.prof";
# another way to say it
use DBI::Profile qw(DBIprofile_Statement);
$dbh->{Profile} = DBI::ProfileDumper->new(
{ Path => [ DBIprofile_Statement ]
File => 'dbi.prof' });
# using a custom path
$dbh->{Profile} = DBI::ProfileDumper->new({ Path => [ "foo", "bar" ],
File => 'dbi.prof' });
DESCRIPTION
DBI::ProfileDumper is a subclass of DBI::Profile which dumps profile data to disk instead of printing a summary to your screen. You can
then use dbiprof to analyze the data in a number of interesting ways, or you can roll your own analysis using DBI::ProfileData.
NOTE: For Apache/mod_perl applications, use DBI::ProfileDumper::Apache.
USAGE
One way to use this module is just to enable it in your $dbh:
$dbh->{Profile} = "DBI::ProfileDumper";
This will write out profile data by statement into a file called dbi.prof. If you want to modify either of these properties, you can con-
struct the DBI::ProfileDumper object yourself:
use DBI::Profile qw(DBIprofile_Statement);
$dbh->{Profile} = DBI::ProfileDumper->new(
{ Path => [ DBIprofile_Statement ]
File => 'dbi.prof' });
The "Path" option takes the same values as in DBI::Profile. The "File" option gives the name of the file where results will be collected.
If it already exists it will be overwritten.
You can also activate this module by setting the DBI_PROFILE environment variable:
$ENV{DBI_PROFILE} = "DBI::ProfileDumper";
This will cause all DBI handles to share the same profiling object.
METHODS
The following methods are available to be called using the profile object. You can get access to the profile object from the Profile key
in any DBI handle:
my $profile = $dbh->{Profile};
$profile->flush_to_disk()
Flushes all collected profile data to disk and empties the Data hash. This method may be called multiple times during a program run.
$profile->empty()
Clears the Data hash without writing to disk.
DATA FORMAT
The data format written by DBI::ProfileDumper starts with a header containing the version number of the module used to generate it. Then a
block of variable declarations describes the profile. After two newlines, the profile data forms the body of the file. For example:
DBI::ProfileDumper 1.0
Path = [ DBIprofile_Statement, DBIprofile_MethodName ]
Program = t/42profile_data.t
+ 1 SELECT name FROM users WHERE id = ?
+ 2 prepare
= 1 0.0312958955764771 0.000490069389343262 0.000176072120666504 0.00140702724456787 1023115819.83019 1023115819.86576
+ 2 execute
1 0.0312958955764771 0.000490069389343262 0.000176072120666504 0.00140702724456787 1023115819.83019 1023115819.86576
+ 2 fetchrow_hashref
= 1 0.0312958955764771 0.000490069389343262 0.000176072120666504 0.00140702724456787 1023115819.83019 1023115819.86576
+ 1 UPDATE users SET name = ? WHERE id = ?
+ 2 prepare
= 1 0.0312958955764771 0.000490069389343262 0.000176072120666504 0.00140702724456787 1023115819.83019 1023115819.86576
+ 2 execute
= 1 0.0312958955764771 0.000490069389343262 0.000176072120666504 0.00140702724456787 1023115819.83019 1023115819.86576
The lines beginning with "+" signs signify keys. The number after the "+" sign shows the nesting level of the key. Lines beginning with
"=" are the actual profile data, in the same order as in DBI::Profile.
Note that the same path may be present multiple times in the data file since "format()" may be called more than once. When read by
DBI::ProfileData the data points will be merged to produce a single data set for each distinct path.
The key strings are transformed in three ways. First, all backslashes are doubled. Then all newlines and carriage-returns are transformed
into "
" and "
" respectively. Finally, any NULL bytes ("