SQL & PL/SQL :: To Select IDs Which Have No IN Or PLANNING Status In AREA 9

Apr 23, 2012

I want to select the IDs which have no IN or PLANNING status in AREA 9

ID 1 has AREA 9 and STATUS IN so dont select
ID 2 SELECT
ID 3 has area 9 BUT STATUS is OUT so Select.

So if an ID has has IN or PLANNING status in AREA 9 i do not wish to see it!

CREATE TABLE DAN_T1
(
ID varchar(8),
AREA varchar(8),
UNIT varchar(8),
STATUS varchar(8)
)
INSERT INTO DAN_T1 (ID,AREA,UNIT,STATUS) VALUES (1,6,'AA','IN');
[code]......

ID AREA UNIT STATUS
16AAIN
17ABPLANNING
17ACOUT
19ADIN
25ACIN
25AAOUT
35BAPLANNING
36DAIN
35CAIN
39CGOUT

WANT:

ID
2
3

View 2 Replies


ADVERTISEMENT

SQL & PL/SQL :: Select Query To Get Top Two Rows Based On Status Date

Oct 29, 2012

I want to get top two rows based on ACCT_UNIT & order by status_date, if there is only one row on acct_unit, get one row. IF more than two rows available, want to get the top two rows based on status_date.

SELECT ACTIVE_STATUS, ACCT_UNIT, DESCRIPTION, DIRECTOR, DIRECTOR2, STATUS_DATE, OBJ_ID, STATUS_FLAG, SUR_KEY
FROM STSI

View 10 Replies View Related

How To Do Capacity Planning For DB

Oct 31, 2011

how to do a capacity planning for a DB ?

View 1 Replies View Related

PL/SQL :: Resource Planning And Jobs Grouping In Oracle

Mar 20, 2013

I have a requirement where I need to group sessions which takes time as given below when ran individually .There are a total of 32 sesions.I want to divide them into 7 groups.I want to submit each one of the 7 groups in a job.So there will be seven jobs on the whole.Execution flow will be group 1 completes ,then group 2 starts like that.Actually I don't want to bombard the database at a time with 32 jobs ,hence the idea of grouping 32 jobs among 7 groups.grouping the sessions so that on the whole ,resources are equally allocated among sessions in a group and which in turn makes the process complete faster. I want to achieve parallelism but at the same time database should not be loaded too much.I just want to know is there any good practice from oracle side while doing this type of grouping. I am planning to group the most time taking one with least time taking jobs.

S.NO     Session_Name     DURATION(HH:MM:SEC)
1     Session_1     00:11:56.202368
1     Session_2     00:00:00.058542
1     Session_3     00:00:00.055205
1     Session_4     00:00:00.043454
1     Session_5     00:00:00.039994
2     Session_6     00:08:05.786031
2     Session_7     00:00:00.579035
2     Session_8     00:00:00.537957
[code]...

View 0 Replies View Related

Performance Tuning :: Capacity Planning For 250 User OLTP Shop

Mar 19, 2013

installing Oracle for a new Data-Center(still in planning).It will be an OLTP shop working 24/7, with 250 concurrent users.

1. Can it, in theory run with good performance on a quad processor(something like Intel Xeon Series 56XX) , with 32GB of memory?
2. What is the Oracle Database Edition required for this configuration?
3. What additional things should one take into account to plan the most cost-effective configuration?

View 2 Replies View Related

Recovery Area Cannot Be Used For Archive Log?

Sep 13, 2013

I`m using the the version 11.0.2.3 for testing.  I read a line as below from the OCP book.

If none of the LOG_ARCHIVE_DEST_n parameters have been set, then transitioning. the database to archivelog mode will internally set LOG_ARCHIVE_DEST_10 to the flash recovery area, if it has been configured. In my database the fast recovery already been set as below.

SQL> show parameter db_recovery
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +FASTRECOVERY
db_recovery_file_dest_size           big integer 4248M

So I thought if I turn the database into archive log mode, then the log_archive_dest_10 will be set as the same value as db_recovery_dest.

SQL> alter database archivelog;
 
Database altered.
 
SQL> alter database open;
 
Database altered.
 
SQL> show parameter log_archive_dest
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string

See, after the database become archive, the log_archive_dest_10 still be empty.  So is there any thing wrong with my understanding?

View 5 Replies View Related

Forms :: Using A Java Program In Bean Area?

Jul 13, 2010

I want to use a java program in Bean Area.

But I can't understand the implement class and how it is implemented.

View 1 Replies View Related

Windows :: OUI-10133 / Invalid Staging Area

Oct 5, 2005

I have a prob installing Oracle 10g on Window 98 SE :

OUI-10133:Invalid staging area.

There are no top level components for Windows 98 available for installation in this staging area.

View 8 Replies View Related

Application Express :: Setting Up SSO In Work Area?

Jul 5, 2012

How to set up Apex SSO in your work area? I have been trying to set it up, but to no avail. I even tried asking support but still under oblivion.

Have you able to run this script before?

apex_sso.sql, apex_verify.sql, apex_sso_server.sql

My output for this scripts are good.

View 0 Replies View Related

Windows :: Scheduled Removing Of Trm And Trn Files From Dump Area

Sep 19, 2011

As I was observing the space issues on my db server. I found that there is lots of Trm and Trc file which is being created very much frequently. Due to this its consuming lots of space even the size of each files is not more than 1Mb.

For cleaning I am deleting all the trm and trc files mannully using DEL command Os level. How can i schedule the purging of trm and trc files.

View 3 Replies View Related

Server Administration :: Flash Back Recovery Area

Mar 3, 2012

what is flash back recovery area? what is its main function and usage

View 1 Replies View Related

Enterprise Manager :: How To Reduce The Dump Area Size

Jan 31, 2010

i just now installed oracle and import some schema to this new DB. but in OEM showing 40 % full of dump area

how to reduce the dump area size?

View 4 Replies View Related

Server Administration :: How Much Flash Recovery Area Is Enough For Flashback

Aug 18, 2011

here's my settings

SYS@boston>SELECT ESTIMATED_FLASHBACK_SIZE FROM V$FLASHBACK_DATABASE_LOG;

ESTIMATED_FLASHBACK_SIZE
------------------------
45195264

SYS@boston>select name, value, issys_modifiable from v$parameter where name='db
_recovery_file_dest_size';

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
ISSYS_MOD
---------
db_recovery_file_dest_size
9663676416
IMMEDIATE

SYS@boston>select * from v$recovery_file_dest;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
D:Ora102chicagooston_recover
9663676416 1671241216 1103842304 50

SYS@boston>select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG .04 0 1
ARCHIVELOG .16 .01 21
BACKUPPIECE 16.84 11.41 22
IMAGECOPY 0 0 0
FLASHBACKLOG .25 0 6

6 rows selected.

SYS@boston>

I have configured a flash recovery area of 9g yet the system keeps complaining that i have not enough flashback logs?

SPACE_RECLAIMABLE 1103842304
ESTIMATED_FLASHBACK_SIZE 45195264

the space_reclaimable is more than ESTIMATED_FLASHBACK_SIZE, so how is it possible the system always complain not enough space?

[URL].....

Quote:

SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE;

it returns me 0, I try to flashback the now defunct former primary db chicago, the system complains. so how much is really enough?

from

[URL]......

Quote:
V$FLASHBACK_DATABASE_LOG

View 1 Replies View Related

Application Express :: 4.2 Front Page Login Area Alignments

Dec 2, 2012

I am running Apex 4.2 on Oracle Express Edition (Linux). Sometimes my login page has the alignments of the Workspace/username/password login area below the Apex image as below: [URL] ........

This is with using Firefox. The font page renders ok with other browsers like IE or Chrome.

View 2 Replies View Related

Application Express :: HTML Text Area With Save Button

Oct 22, 2012

I have created a region Q_INFO and in the region i have added HTML text area. This text area is editable for only few users. If the user types in the text area and presses save button. The text is stored in the table INFO. And this text is displayed to all other users. But when i enter any data in the text area with multiple new lines and press SAVE button. The text is displayed in single line. I want to maintain new line and paragraph in the text area.

View 2 Replies View Related

Application Express :: Retain Text Area Line Breaks

Nov 3, 2013

I am using textarea item to enter and save data into table but saved data doesn't retain all formatting eg line breaks so how can i format the text entered in the textarea so it retains line breaks when saved in the table or sent in the email via APEX_MAIL.SEND...  in APEX 4.1.1, 

View 0 Replies View Related

Performance Tuning :: How To Tune Order By Clause Without Changing Sort Area

May 1, 2008

How to avoid sort operation by an order by clause without changing the sort area size.what hints or changes should be done in query so that order by clause work faster.

View 10 Replies View Related

Reports & Discoverer :: Continuous Pages Not Printing In Exact Pre-printed Area

Nov 29, 2011

I have a Invoice Report, i will give the parameters.

From_Inv_No:
To_Inv_No:
From_Inv_Date:
To_Inv_Date:

so i will give 10 invoices with dates in the above parameters to generate the report, actually the report prints in a pre-printed sheet, well it prints the first page correctly but the second page and continuous pages not printing in the exact pre-printed area. example see below;

(Page2)
506176
28/11/2011
(Preprinted text)INVOICE NO :
INVOICE DATE:

how to give spaces between pages actually every pages it should print 3 to 4 inches gap between the first page but it prints just one inch above the preprinted area. how to make it print without gaps. Additional Information: Preprinted sheet Height 17 inches.

Paper Layout Width 8.5
Height 12

Character Mode

Report Width 80
Report Height 72

for header section, main and trailer sections above readings only given.

View 3 Replies View Related

SQL & PL/SQL :: Will Oracle Automatically Deallocate Memory Occupied By Records In Cursor Area

Feb 25, 2013

i have a ref cursor and i have used 'open cursor for' statement:

CREATE OR REPLACE PACKAGE aepuser.pkg_test
AS
TYPE cur1 IS REF CURSOR;
PROCEDURE get_empdetails (p_empno NUMBER, io_cur OUT cur1);
END;

[code]...

then i want to know that- will oracle automatically deallocate the memory occupied by records in cursor area?if yes, then when it will be free , in case of 'open cursor for' ?

View 7 Replies View Related

Application Express :: Prefix Text Entered Into Text Area With Userid And Timestamp?

Sep 12, 2012

Have got basic form on a table and have a textarea which holds Notes added by user.

So Notes database field is updated on Save / Apply changes button being pressed.But would really like any text added / appended to the Notes field to be prefixed by userid and date / timestamp.

Is it possible via dynamic actions or Javascript to have any new text added / typed to be auto prefixed as per above.

Would only want the first key press in the filed to trigger the auto-prefix and if added text was deleted then the auto prefix to be deleted as well ?? If user doesn't press Save / Apply changes obviously want to leave existing Notes as is.

View 5 Replies View Related

Backup & Recovery :: Cannot Update Recovery Area Reclaimable File List

Oct 18, 2012

I just switched my STBDY DB to a PRIMARY DB and I am ran the following:

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters are successfully stored
ORA-00245: control file backup operation failed

RMAN-08132: WARNING: cannot update recovery area reclaimable file list

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORARZULB are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
[code]....

what causes this warning and how to get rid of it?

View 2 Replies View Related

Data Guard :: DATA FILES IN Storage Area Network (SAN)

Mar 29, 2011

I am working in a bank as an system consultant, i have a SAN Storage Area and oracle as below.

SAN 1

This interface includes the DATA FILES of the oracle tablespace

SAN 2

SAN1 Mirrors the DATA FILES of the oracle tablespace to SAN 2

1. Can i rely on real time data recovery from SAN2 ?
2. if SAN1 (Data Files are currupted) will the SAN2 Data Files will be currupted as well.
3. If the SAN2 is currupted then what Oracle Features can be used to have uncurrupted data.

View 5 Replies View Related

Backup & Recovery :: Flash Recovery Area 9i

May 22, 2011

I want to change backup location for Oracle 9i Database. there is no flash recovery area in 9i, so i want the parameter which i can use to modify backup location to anywhere i want.

View 4 Replies View Related

Status Online Logfile

Nov 2, 2010

I delete member logfile from disk with statement: shred -fu /u01/app/oracle/redologs/activeredolog/DB1/redo0102.log

But if I check status one logfile with statement:

select status from v$logfile wheremember='/u01/app/oracle/redologs/activeredolog/DB1/redo0102.log';

Status is still null. I think status should be change.

My database is 11.2.0.1 with single instance.

Status is changed after restart instance.

Haw can I monitor status logfiles without restart instance?

View 2 Replies View Related

SQL & PL/SQL :: Batch ID From Child Status

Mar 27, 2013

Im looking for a query which returns the batch for which all the child should either be in 'A_STATUS','B_STATUS' or 'C_STATUS'. In this query im expecting a query which returns batch 2,3 and 4.

create table batch (batchid number);
insert into batch values(1);
insert into batch values(2);
insert into batch values(3);
insert into batch values(4);

[Code]...

View 9 Replies View Related

Forms :: Record Status Bar?

Jun 2, 2011

i am migrating forms 6i to 10g, when i compile one form to checking purpose all are successfully fine but the record status bar not showing there fore message are not appear how to solve this problem

View 1 Replies View Related

SQL & PL/SQL :: Query To Get Overall Status For Clients

Sep 11, 2010

I have a clients table called CLIENTS. One of the fields in this table is called 'status'

I need to set this status field, depending on if the transactions for this client have passed.

The transactions are in a table called TXNS and has fields
client_id, txn_id, txn_status

txn_status can be 'success' or 'failed'

I need to somehow set the overall 'status' field on CLIENTS to success or fail depending on if any transactions failed or not

So for every client I want to list the status, any query that can possible list the overall status for the client?

select client_id, MAX(status)
from txns
group by client_id

but the max(status) bit needs to get the overall status part

View 10 Replies View Related

SQL & PL/SQL :: Get Continuous Dates With Same Status Value

Feb 23, 2012

I'm looking for a way to get continuous dates as a period in the result.My tabledata contains a date and a status, I want to get continuous dates with the same status value.

That's my tabledata:
select * from (
select to_date('01022012', 'ddmmyyyy') as thedate, 1 as status from dual
union select to_date('02022012', 'ddmmyyyy') as thedate, 1 as status from dual
union select to_date('03022012', 'ddmmyyyy') as thedate, 2 as status from dual

[code]...

THEDATE STATUS
---------- ------
01.02.2012 1
02.02.2012 1
03.02.2012 2
04.02.2012 1
05.02.2012 1

[code]...

And that's the result I am looking for:
select * from (
select to_date('01022012', 'ddmmyyyy') as startdate,
to_date('02022012', 'ddmmyyyy') as enddate from dual
union select to_date('04022012', 'ddmmyyyy') as startdate,

[code]....

View 6 Replies View Related

SQL & PL/SQL :: Monitoring Status Of Procedure?

Feb 24, 2010

I've got a pl/sql procedure that i would like to monitor its progress. Its been running for quite a few hours now and i dont really know if it is stuck in a loop or if it is just taking too long read/execute queries. Is there a way to find out what is the status of the procedure? or what it is currently doing?

I looked at views like v$sessions or v$session_longops but they dont actually tell me what it is currently doing. All of them just point to the call to the pl/sql procedure. Also, is it possible to look at the physical files on the filesystem to know if there is actually any processing going on and files are being written to? Is this possible or a files written to only after a commit?

View 17 Replies View Related

SQL & PL/SQL :: Display Output IDs Which Are Having Status Both Y And N?

May 11, 2012

CREATE TABLE stud(id number,Status CHAR(1))

INSERT INTO stud values(10,'Y')
INSERT INTO stud values(10,'Y')
INSERT INTO stud values(10,'Y')
INSERT INTO stud values(10,'N')

[code]...

ID STATUS

10 Y
10 Y
10 Y
10 N
20 Y

[code]...

I want to display the out put the IDs which are having the status both 'Y' and 'N'The output should be

ID STATUS

10 Y
10 Y
10 Y
10 N
20 Y
20 N
20 N

View 12 Replies View Related







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