PL/SQL :: Find A Check List To Use Against PROD / DEV / TEST Environments?

Jan 21, 2013

outlining 'key' differences between databases / configuration / hardware that can potentially make a difference to what results you get when running sql / pl/sql - I am trying to find a check list to use against PROD / DEV / TEST environments.

View 2 Replies


ADVERTISEMENT

Performance Tuning :: Export SQL Plan From Test Database To Prod Database?

Jul 16, 2013

An SQL query is taking a lot of time than usual and not completing even left after hours! The query joins a table with a quite complex view.

The same query in a test database completes in less than 2 mins.

I would like to export the sql plan from test database to prod database.

how to export/import in 10.2.0.4 version for a particular sql statement's execution plan.

View 2 Replies View Related

Export/Import/SQL Loader :: Refresh A PROD Database Into TEST Database

Jun 17, 2012

I need to refresh a PROD database into TEST database. The PROD and TEST runs on 10g. I need a full refresh. Is there any pre req's which i should keep in mind ?.

View 1 Replies View Related

Server Administration :: ASM - Disk Strategies In Production Environments?

Jan 26, 2010

I am working on ASM as i am bit confused to decide ASM Disk strategies in production Environments. For Ex:-

1.Normal Redundancy ( Allows 2 Mirror Groups ) :-
I have created Normal_DG Diskgroup with 4 Disks

Disk1-------------------
Disk2 ------- |
|--->FG2 ----> FG1
Disk3 ------- |
Disk4-------------------

According to my understanding , if Disk1 Fails Disk4 facilitates normal operations. When there is space crunch it operates in reduced redundancy . Am i right ?

2.I have got 4 Disks in one group (i.e from Disk1 To Disk4 ) i have not defined any failure group and as per my understanding all disks will be added to its own failure group without mirroring and striping.

View 2 Replies View Related

How To Check / Find Size Of Current ROLLBACK Segment

Apr 8, 2013

How to check/find the size of current ROLLBACK segment in oracle 10g ?

View 20 Replies View Related

How To Find Out The List Of Patches Applied Without Using Inventory

Jul 23, 2012

I have been asked this question once.

How will you find out the list of patches applied to Oracle Database Home without using commands like opatch lsinventory -detal etc...

I think registry$history is a view from where we can find out the list of patches applied.

But I think it will not include all the bug fixes,stand alone or one-off patches.It will mainly list out the CPU patches applied(correct me if I am wrong).

View 10 Replies View Related

Find List Of Tables Inserted / Updated In Last 6 Month

Oct 7, 2012

I tried to find out recently updated table list. I couldn't find anything.

CODE>> JUST SAMPLE  TRANSACTIONS >>

SQL> conn sam
Enter password:
Connected.

SQL> select * from tab;
TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BIN$y1TXhcjGApvgQAB/AQBOpA==$0 TABLE
TAB1                           TABLE
[code]........

View 1 Replies View Related

Security :: Find A List Of Roles And Privileges In Database?

Feb 24, 2011

How can I list all the roles and privileges of roles in Oracle? Can I get the details of the activities they perform?

View 12 Replies View Related

SQL & PL/SQL :: Query To Find List Of Tables Contains Particular Data In Schema?

Feb 3, 2012

I want to list the tables in a schema which contains a particular value or data.

View 2 Replies View Related

Networking And Gateways :: Find List Of Database Links?

Jul 2, 2011

There is a user account called 'BALA' in my database.I want to find out the database links that uses this 'BALA' account.

View 2 Replies View Related

Server Administration :: How To Find Out List Of DB_LINKS That Uses User Account In Database

Jun 6, 2011

How to find out list of DB_LINKS that uses user account in database ?

View 9 Replies View Related

Server Administration :: How To Find And Close Open Cursor List Without Restarting

May 28, 2013

In my environment found maximum open cursor exceeds error. So how can I found the open cursor list and how can I close that cursor without restarting. Any SQL commands to close the open cursor.

View 4 Replies View Related

Application Express :: Get Version Currently In PROD From CVS

Jul 4, 2012

We use Apex 4.0.1 and (to simplify) say we have 2 environments: DEV and PROD (both with same workspace ID.)Application 10 is in production, and currently being modified in DEV as part of an improvement project.However a bug is found in PROD and needs to be fixed as soon as possible. The steps we take are:

- Get the version currently in PROD from CVS
- Import it under a different application ID in the DEV environment, say application 11.
- Fix the bug

Now the problem starts. We always deploy whole applications to other environments (rather than individual components) and we want to keep the same application ID when we deploy this fix to PROD. But we only have the run-time environment in PROD, so it is not possible to override the application ID during deployment. So what we do is:

- Export DEV application 10 (the one being modified)
- Export DEV application 11 (the one with the bug fix)
- Import DEV application 11 over application 10
- Export DEV application 10 (the one with the bug fix)
- Import DEV applicaton 10 back (the one being modified)
- Deploy DEV application 10 to PROD (the one with the bug fix)

Is there a way to improve this (other than manually modifying the application ID in the export file)?

Another problem we have is that, once application 10 is imported into application 11, all the internal IDs change (hence the title of this post. :) ) This makes comparing versions in CVS a nightmare. Any way to prevent it? The only way seems to be import the application from PROD into the same application number in DEV, but this has an impact in the development process as no new development can be done until the bug is fixed.

View 7 Replies View Related

Server Utilities :: Import A Table From Prod To Dev

Jan 26, 2011

I am getting the below error when I import a table from Prod to Dev. I understand this error will be occured if length of the datatype is low. First I got the error when the datatype(length) which is 25 for the column PASSWORD column.Then I increased the length of this column to 45, then it was imported successfully.

why am facing the error when the datatye and length for this table is same in prod and dev? What are the possible ways to import the data without increasing the PASSWORD column length?

IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "ANEES"."SALSA_WEB_ACCESS"."PASSWORD" (actual: 28, maximum: 25)
[code]....

View 7 Replies View Related

Monitoring Of Prod Database Using EMCA Control

Apr 23, 2013

11.2.0.1

I am monitoring out PROD database using EMCA database control.

Under "Performance" tab I check the AVERAGE ACTIVE SESSION and I see spikes of "CPU concurrency". (figure emca1)

figure: emca1>

[URL].......

I want to investigate what causes this "spike" in cpu so I drill it down further:

figure: emca2>

[URL]........

Then figure drill down further:

figure: emca3>

[URL].......

But I can not understand what causes the spike thing.

View 2 Replies View Related

Application Express :: Refreshing Dev Workspace From Prod

Nov 7, 2013

I support an APEX app that has one workspace for Development and one for the live Production application.  When I originally created the Dev instance I was able to copy tables and data by granting select privileges between the two workspaces (I did this one table at a time). 

The development workspace data needs to be refreshed from production since it's been a long time since the initial refresh and is very out of date. I would like to do a couple things:

1) execute SQL to compare the tables in the two workspaces to ensure they're structurally identical
2) execute SQL to truncate Dev tables and refresh from Prod Is there a way to do this? 

View 3 Replies View Related

Auto Accounting Rule Is Not Taking Effect In PROD

Aug 10, 2013

we are in the migration of oracle apps 11.5.9 [version] , while uploading AR open invoices we used auto accounting rule for revenue account , but we did this changes its not taking an effect , same revenue a/c we uploaded is uploaded , but the auto accounting is not taking an effect ,

for a work around we migrated the data ! but we would be the root cause and possibilities why it hasn't worked ?

But this auto accounting rule worked in CRP & UAT as well ...!!!

View 2 Replies View Related

PL/SQL :: User Copied Table Data From Prod To Other Schema?

Apr 22, 2013

has copied one table data from Production to any other schema , know which user has done this ?

View 1 Replies View Related

Forms :: Put One Check Box To Check All The Check Boxes?

Jul 30, 2011

I want to put one check box to check all the check boxes.how can i do this?

View 5 Replies View Related

SQL & PL/SQL :: Count A List Of Number Value And Find Maximum Number?

May 21, 2010

how do I count a list of number value eg 1,1,1,1,3,3,6,4 and find the one with maximum number which is 1

View 5 Replies View Related

Forms :: How To Avoid (no List Elements Defined For List Item) Error

Sep 27, 2011

I am creating the Dynamic list but when i am compiling the form it gives the compilation error "No list elements defined for the list item".

I can eliminate it by entering the dummy list element but this dummy value will be displayed at form run time.

View 1 Replies View Related

List Products List Of Client Grouped By Type Of Product?

Dec 14, 2011

Im trying to list the products list of a client grouped by type of the product. Ex:

product type

prod.A acid
prod.B flavour
prod.C acid
prod.D cleaner
prod.E flavour

I want to list something as:

Acid

Prod.A
Prod.C

Cleaner

prod.D

Flavour

prod.B
prod.E

View 1 Replies View Related

Forms :: FRM-30351 / No List Elements Defined For List Item

Oct 30, 2011

DECLARE
CURSOR GRP IS
SELECT RowNum rn, Letter_Group_ID||'-'||A_Desc AName,Letter_Group_ID
FROM Hrs_Group;
BEGIN
Clear_list('Letter_Group_ID');
FOR I IN GRP LOOP
Add_List_Element('Letter_Group_ID',I.rn,I.AName,I.Letter_Group_ID);
end loop;
END;

FRM-30351: No list elements defined for list item.

List LETTER_GROUP_ID

View 4 Replies View Related

SQL & PL/SQL :: List All Tables Connected To Each Other With Constraints And List All Together

Apr 22, 2013

I just want to list and group all my tables that are linked together by constraints. I just want my tables to be able to be listed together as one particular database. my tables are , CUSTOMER, ORDER_INFO, ORDER_LINE, PRODUCT. They're all linked together by way of constraint and I want to list and print them all together as one DB. HOW DO I put them all in one schema and then also list them all together and print/illustrate them as one. also, I tried to import them into their own scheme but i ran into a series of probs regaurding the .dmp file being read.

View 2 Replies View Related

SQL & PL/SQL :: Test Parameter?

Jan 12, 2012

I need to test a parameter in a script that must adhere to what is currently in the database.For example, when a user enters the value when prompted from this script, ("Enter the schema copy desired: " ) the value must be of the current values in the db:, it would be something like this:

Values currently in DB: copyofschema201110 (the 2011 is the year, and 10 would be the month of oct).

copyofschema201109
copyofschema201108

So, if the user enters the value 'abc' (an incorrect value), then I would like the script to stop the user, and kick back a message, say from dbms_output.put_line, and force the user not to go forward, but re-enter a correct value.

View 13 Replies View Related

PL/SQL :: Not Show Last Row Of Test Number?

Feb 7, 2013

I have below mentioned records in mount so whenever i select any mount it should now show the the last row of that mount i.e. test no-3 any records of mount which will not show last row of test number

mount     day     org1 test_No org2 org3     org4
299.00 1     0     1     1     0     7186
299.00     1     0     2     1     0     7186
299.00     0     3     3     0     7186

[code]...

but i want test_no should be in asceding order

View 3 Replies View Related

PL/SQL :: Test Data In Query?

May 29, 2013

I suspect it uses TABLE, CAST and/or MULTISET functions in a query .. but reading the docs on those, I can't seem to piece together how to do it.

When I piece together a sample/test query, I usually do something like this:

WITH data AS
( SELECT 123  id,  'abc'  col1  FROM dual UNION ALL
SELECT 234, 'def' FROM dual UNION ALL
SELECT 345, 'xyz' FROM dual
)
SELECT *
FROM data -- usually more complex query here

However, I saw somebody do this without using the UNION ALL .. they did something with TABLE ( ... ) ? it seemed "simpler" than the UNION ALL method I've used previously

View 10 Replies View Related

Copy Database From Production To Test?

Feb 22, 2011

Would like to know if I can replicate Production database (10.2.0.2) to Test (10.2.0.4).

tell me the process to do that on windows environment.

I wonder if I can do it with two different oracle versions?

View 4 Replies View Related

Windows :: Test If Database Is Running?

Sep 15, 2010

I have a unix script that will check if the database is up and running. I need a similar script but this time in windows batch file.

this is the snippet of the code from the unix script:

#! /bin/sh
sqlplus -s /nolog > /dev/null 2>&1 <<EOF
whenever sqlerror exit failure

[Code].....

View 2 Replies View Related

SQL & PL/SQL :: Update Test Table On ID Column

Feb 21, 2012

CREATE TABLE TEST
(
NAME VARCHAR2(1000 BYTE),
ID NUMBER
)

[Code]...

I want the update the TEST table with TEST1 based on id column,i tried as like.it's not working..

UPDATE test t1
SET t1.ID = ( select ID from test1 t2
where t1.name = t2.email and rownum=1 )

View 13 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved