Sponsored Content
Full Discussion: Automation Script for Oracle
Top Forums Shell Programming and Scripting Automation Script for Oracle Post 303007169 by vasuvv on Monday 13th of November 2017 04:29:49 AM
Old 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

automation script for password reset

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

FTP automation script

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

Help with Shell Script automation

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

Help with Truststore automation shell script

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

Script Automation

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

awk script automation

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

Script to automation utility app

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

Automation script

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

Automation script for Oracle queries for two different Databases

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

Error on id3v2 automation script

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
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)
All times are GMT -4. The time now is 09:08 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy