Rating Thread / Thread Starter	Last Post	Replies	Views
Prophecy Regarding Future of Oracle DBAs ( 1 2 3 ) Good Morning Everyone, Just wanted to share my observation regarding Oracle. If we compare when Oracle 7 with what we have right now i.e. Oracle... takveen@gmail.com	04-11-2007 09:24 PM Mladen Gogala	22	91
Another oracle resource goes down the drain ( 1 2 3 ) I was not overly active on this forum, traditionally I was more active on the oracle list (oracle-l (AT) freelists (DOT) org). Recently,... Mladen Gogala	04-11-2007 07:57 PM Fuzzy	28	111
SQL: Working with huge tables of chronological data ( 1 2 3 4 5 ... Last Page) Hi, I'm trying to figure out an efficient way to search for the non existence of events in chronological data with SQL. The goal (detailed below)... John	04-11-2007 05:58 PM John	50	200
RMAN "delete obsolete" question Target DB is 9.2.0.1 Catalog is 10.2.0.2 I have my retention policy configured to "recovery window of 30 days" on one of my databases but... Chuck	04-11-2007 05:05 PM Chuck	4	43
Call for Papers is open at Oracle BIWA Summit (oct 2-3) The call for papers is open at Oracle Business Intelligence, Warehousing and Analytics Special Interest Group (BIWA SIG) for BIWA Summit 2007. BIWA... Oracle Data Miner	04-11-2007 05:05 PM Oracle Data Miner	0	52
Create a Trigger for an existing View ( 1 2 ) Hi! I created a view from the two existing tables (DEMO_USERS and DEMO_ORDERS). Code: CREATE VIEW DEMO_MY_TEST AS SELECT DEMO_USERS.USER_ID,... Dean Tomasevic	04-11-2007 01:44 PM hpuxrac	11	98
Oracle tutorial and Interview questions and answers- Oracle tutorial and Interview questions and answers- Oracle tutorial- http://oracletutorials.blogspot.com/ Oracle Interview questions and... devser2006@gmail.com	04-11-2007 01:41 PM joel garry	1	36
query help Hi all, I need to show ONLY rows where columns 2 through 9 are the same. Table... Eugene	04-11-2007 01:00 PM Mladen Gogala	2	43
Oracletutorials.info is your gateway to the Oracletutorials.info is your gateway to the best sites on the Internet for data recovery! Looking for Business Plan, Work from Home, or Career... devser2006@gmail.com	04-11-2007 11:00 AM devser2006@gmail.com	0	49
Performance effect of adding a new index Hi there, I have a table with about 10-20 insert per minutes and it can carry up to 500,000 records, except the primary key this table doesn't have... Sam	04-11-2007 10:20 AM DA Morgan	4	315
de-duplication during backups Has anyone used 'deduplication' appliances for db backups? If yes, did you have any positive results? Such as the ones offered by... NetComrade	04-11-2007 09:41 AM hpuxrac	1	51
After adding memory on a server... Hi, We having problem on a Oracle 8.1.7 server (unable to allocate memory)... I see that I reach all of the memory on the server (2Go). I add... mtn_bikers@msn.com	04-10-2007 06:16 PM klimenkor@gmail.com	4	51
Re: Oracle and ASP.NET - advice on where to look On Apr 10, 3:06 pm, "Dereck L. Dietz" <diet... (AT) ameritech (DOT) net> wrote: I know nothing about it, but a few seconds of... joel garry	04-10-2007 05:57 PM klimenkor@gmail.com	2	54
Shared Memory and Semaphores I have doubt in both of these. Don't you think oracle is taking to much shared memory and semaphores are on these server. It's a test server, there... peter	04-10-2007 04:43 PM joel garry	4	43
Use 10g Enterprise manager to delete archived redo logs any idea on how to do this? doron.almog@gmail.com	04-10-2007 01:30 PM joel garry	5	40
Oracle rman SCN Hi everybody, I have a question connected with recovering data from oracle 9/10. elow is description and question. Please HELP. The question is... Daniel	04-10-2007 12:27 PM Daniel	7	76
Oracle 11g New features Check site for 11g new feature http://virag.sharma.googlepages.com/11gnewfeature Virag	04-10-2007 10:19 AM Virag	0	49
Creating AN External Portal Hello All, I have creater an instance in portal as http://oraapps.yantro.com/7778, its working good with all the responsibilities set to... balaji2nasa@gmail.com	04-10-2007 08:14 AM balaji2nasa@gmail.com	0	64
beginner: packaging queries? are procedures and functions the only types of queries that I can put into a package? I have painstakingly created a couple of plsql db queries and... matt	04-10-2007 04:10 AM sybrandb	1	39
Can I remove a table from the recycle bin? ( 1 2 3 ) I am trying to drop a data file from a tablespace. Oracle does not allow because the data file is not empty. So, I checked the dba segment and find... Kaka	04-09-2007 04:18 PM joel garry	23	246
Database is up or down Sun Sol> ps -ef\|grep PSPATCH\|grep -v grep oracle 5079 1 0 Apr 07 ? 0:28 ora_pmon_PSPATCH oracle 5081 1 0 Apr 07 ? 0:00... Steve Robin	04-09-2007 04:04 PM joel garry	7	46
Re: SELECT statement efficiency question ( 1 2 3 ) On Sun, 08 Apr 2007 00:30:14 -0500, Dereck L. Dietz wrote: May be a flag column defined like this: should_load char(1) default 'Y' check (col1 in... Mladen Gogala	04-09-2007 03:52 PM Charles Hooper	20	127
ORACLE OS Audit Logs Is there a way within Oracle that you can configure the type of information that you want to appear in Operating System audit logs. I know the... GABJOS	04-09-2007 03:38 PM sybrandb@hccnet.nl	3	49
Oracle, Linux & OFA - Fevered Dreams? I tried to install Oracle 10g R2 on RHEL 4 Linux this weekend and it was a nightmare. Since Oracle is pushing people to use the OFA architecture... Jack	04-09-2007 02:25 PM hpuxrac	3	43
Strange result of select Hi, i do this select joined in 2 tables for have number of block and byte from user_tables and user_segment. SELECT A.BYTES,A.BLOCKS,B.BLOCKS FROM... Andrea	04-09-2007 12:08 PM sybrandb@hccnet.nl	1	45
Oracle Database with Microsoft Active Directory hi, i'll try to install a oracle 10g DB with active directory support for take advantage of integrated authentication in the 2003 domain. I've been... Andrea	04-09-2007 08:25 AM EscVector	4	39
installation problem 9i We had an installation of 10G R2 under different user and home directories. We installed the 9i using a different user and different home directories... oracle.me34@gmail.com	04-09-2007 08:07 AM oracle.me34@gmail.com	7	40
Re: Working with huge tables of chronological data "Jonathan Lewis" <jonathan (AT) jlcomp (DOT) demon.co.uk> wrote charely Apologies for spelling your name incorrectly. I let the spell-checker... Jonathan Lewis	04-09-2007 07:47 AM Jonathan Lewis	0	34
Configuration question ( 1 2 3 ) (If I need to direct this elsewhere, that information would also be appreciated). I have downloaded the Oracle 10g Express and have installed it... oyyo500@gmail.com	04-08-2007 05:25 PM Mladen Gogala	20	119
CBO & different execution plans ( 1 2 3 ) Hello, Oracle 10.2.0.3.0 64-bit on RHEL 4 optimizer_index_caching = 80 optimizer_index_cost_adj = 20 optimizer_mode = FIRST_ROWS, statistics have... Matthias Hoys	04-08-2007 09:43 AM Jonathan Lewis	29	129
RMAN backup strategy on 10g r2 on linux ( 1 2 3 ) Hi, Please forgive a lot of my ignorance as I am very new to the entire Oracle database world. I am currently working my way through the "Oracle... Cristi	04-07-2007 01:06 PM Tobias Barth	22	186
Oracle 11g new features ( 1 2 3 4 ) How about: CREATE USER LIKE ... FLASHBACK SCHEMA ... select * from v$alertlog (ok, this one can be easily made with external tables :-)) Matthias Matthias Hoys	04-07-2007 01:02 PM Tobias Barth	35	335
How to get the current/last run SQL statement into a string variable? Hi All, I'd like to know how I can retrieve the current (or last run) SQL statement into a string variable. I'm trying to get this so in case of an... JB	04-07-2007 11:30 AM Niall Litchfield	3	51
SQL query to determine the users of undo tablespace ( 1 2 ) How do I determine which users are using undo tablespace in an Oracle 9.2 database? Thanks. yaru22	04-07-2007 10:56 AM Fuzzy	11	86
Are multiple extents still a problem with LMT? ( 1 2 ) I'm going to migrate the tablespaces of an old 8i/w2k database I've inherited from DMT to LMT as a first shot in addressing seriously degraded... Andy Kent	04-07-2007 10:24 AM Frank van Bortel	17	80
Any Comments - StatsPack Report Actually it is wrong formatted statpack report. useless "Error : Couldn't locate a valid date field in the SNAPSHOT info " "Richard Piasecki"... ronald.brayan@gmail.com	04-07-2007 08:33 AM Gerry Sinkiewicz	7	65
How to return records with mismatching criteria in the same column Hello everyone. I have result set that I am pulling that shows a customer may have a different end date on multiple records. Is there a way to... D	04-06-2007 09:07 PM Anurag Varma	2	35
MODEL clause - How to Learn ? I really want to lwearn about the MODEL clause But (to me) it seems to be rather inadequately documented and few example around.... Anyone suggest a... jeffs	04-06-2007 05:46 PM Mladen Gogala	5	44
Data Guard and nologging Oracle says that putting a table into nologging mode on the primary database in a data guard configuration can invalidate the standby. If... Chuck	04-06-2007 04:44 PM Chuck	2	55
Q: how to time a transaction I have been requested to monitor EVERY transaction for how long it takes to run/complete. I know you can trace individaul transactions but is there... eAddict	04-06-2007 03:50 PM DA Morgan	8	47
generic way to get primary key values inside trigger I need to get the string representation of the value of the primary key (possibly multi-column) of the current row being inserted into a table from... akhashnobish@hotmail.com	04-06-2007 02:21 PM akhashnobish@hotmail.com	9	60
Estimate temp space Hi, Is it possible for query to estimate its temp consumption ? Thanks in advance astalavista	04-06-2007 08:58 AM Mladen Gogala	8	66
EM scheduled RMAN backup & daylight saving time ( 1 2 ) Hello, Oracle 10.2.0.3.0 on RHEL 4.. A full RMAN backup was scheduled with the Enterprise Manager console, to be executed each night at 11:00PM GM... Matthias Hoys	04-06-2007 08:41 AM epokopac@excite.com	11	112
Store outline not used in PL/SQL Is it normal that a stored outline would not be used by SQL that is contained in a PL/SQL block? I have a query that is a cursor in a PL/ SQL... matta576@gmail.com	04-05-2007 10:52 PM Vladimir M. Zakharychev	2	62
Oracle Health & Statistics ( 1 2 ) Hi, Yes, I know you're probably all fed up of newbie questions and vagueness regarding checking health of an Oracle server/database. But hopefully... Bobby	04-05-2007 03:54 PM joel garry	10	98
Oracle Standby Server Hi, I have 10gV2 SE1 instance running on a RHEL4 server. I want to build a standby server. I would like to take the redo-logs from the primary... Rajesh Kapur	04-05-2007 03:46 PM Niall Litchfield	5	64
10G tns questions I am doing a first time test install of a prod database on 10G (10.2), installed the software, installed grid control, then applied latest patch and... GS	04-05-2007 02:30 PM GS	8	53
manual clone of database Hi I am trying to manually clone a database, but also renaming the database. On the source system, I issue an 'ALTER DATABASE BACKUP CONTROLFILE... chris.faulkner@gmail.com	04-05-2007 10:21 AM chris.faulkner@gmail.com	4	57
Break out instances to different ports We have three instances of Oracle on one machine under the same port (1521). I would like to break the TEST and DEV instances out to their own... ken.holm@holmcc.com	04-05-2007 09:18 AM ken.holm@holmcc.com	4	52
Where to start to become a DBA ( 1 2 ) Hi, I am Dhanasekar. Working as a system administrator.i want to become a DBA.i dont have any idea about oracle dba.please suggest me, where to... dhans	04-04-2007 06:44 PM newbie	12	133

Page 111 of 411

111

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off