11-13-2017
Automation Script for Oracle
Hi,
As a Oracle Developer, I am writing many Procedures,Functions and Packages. Facing Many optimization issue after writing these Database objects. Trying to tune it manually.
Can we write any Shell/Perl/Python script to Optimize these Database objects instead of doing manual check and optimize?? It would be great if we can optimize/fining the issue where the query is taking long time ( instead of going through the Explain Plan).
Please advise.
Thanks,
Vasu
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
Is there any way to automate the reset of passwords.I mean can we write some scripts and do it. Would be great if anybody can help in this regards. (9 Replies)
Discussion started by: yakyaj
9 Replies
2. Shell Programming and Scripting
Hi,
I have got a requirement like this.
a parameterized function custFtp which will take 5 i/ps and will do the following tasks.
p1) server name
p2) username
p3) password
p4) path name of the server where the file resides
p5) file name pattern
the function will work like this.
... (1 Reply)
Discussion started by: ani_datta
1 Replies
3. Shell Programming and Scripting
can someone look into this one please... I am struck at this point. I do not know what logic to be followed here. I can go ahead with my work only, if this step is done. Please Help.
I have a process X in a shell script. Once the process X is done, it generates a log file. Process X is basically... (1 Reply)
Discussion started by: ss3944
1 Replies
4. Shell Programming and Scripting
Please close this thread.
I have raise this question in appropriate thread.
Thanks (0 Replies)
Discussion started by: KuldeepSinghTCS
0 Replies
5. Shell Programming and Scripting
Hi Gurus,
I have a clearcase script that i use to check in a single file at time on my clearcase server. the script is as follows
setmyview
settask 75098_MSI_TRILOGY_EIM
cd /vobs/Trilogy_R12/custom/msieim/12.0.0/sql/
cleartool co -nc .
ct mkelem -nc Filename_1.sql
cp... (3 Replies)
Discussion started by: r_t_1601
3 Replies
6. Shell Programming and Scripting
I have the below code which calculates the time difference between src and dst from a large trace file. The code works for a given source and destination. However, I want to automate the code to go over any src and destination. The format of the source is like that: X.Y where x is always =2 and Y... (10 Replies)
Discussion started by: ENG_MOHD
10 Replies
7. Shell Programming and Scripting
Hi All,
Am trying to write a shell script to automate one of the product utility but am struck with how to send/key in the inputs and most importantly it requires to press "Enter" key every time after giving the input.
Not sure how to take control of utility from script and key in... (1 Reply)
Discussion started by: Optimus81
1 Replies
8. Shell Programming and Scripting
Hello All ,
I came across a tricky solution to devolop . Here is a part of the requirement automation .
I have different set of server say : Web ( has 4 servers under it ) , App ( has 4 servers under it ) , DB ( has 2 servers under it )
Above each i have different load balancers , Say : Web... (4 Replies)
Discussion started by: radha254
4 Replies
9. Shell Programming and Scripting
Hi Team,
I am Oracle Databse developer. I am currently working on two databases.
DB1 and DB2.
in DB1 I have a Select query which will return 100 records.
In Db2 I have a Select query which also return 100 records.
In these two tables ( in different Schemas) we have a common column.
... (2 Replies)
Discussion started by: vasuvv
2 Replies
10. Shell Programming and Scripting
Hi all,
I have some audiobooks which i'm trying to add the mp3tags based using id3v2 on the folder
Example:
Abigail Gibbs - (The Dark Heroine #01) - Dinner with a Vampire
Tags that I'm hoping to write
Artist: Abigail Gibbs
Album: The Dark Heroine #01
Song: Dinner with a Vampire
Any help... (1 Reply)
Discussion started by: itschrisonline
1 Replies
LEARN ABOUT PHP
oci_server_version
OCI_SERVER_VERSION(3) OCI_SERVER_VERSION(3)
oci_server_version - Returns the Oracle Database version
SYNOPSIS
string oci_server_version (resource $connection)
DESCRIPTION
Returns a string with the Oracle Database version and available options
PARAMETERS
o $connection
-
RETURN VALUES
Returns the version information as a string or FALSE on error.
EXAMPLES
Example #1
oci_server_version(3) example
<?php
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
echo "Server Version: " . oci_server_version($conn);
// Displays:
// Server Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
// With the Partitioning, OLAP, Data Mining and Real Application Testing option
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ociserverversion(3) instead. This old name still can be used. However it is deprecated
and not recommended.
SEE ALSO
oci_client_version(3).
PHP Documentation Group OCI_SERVER_VERSION(3)