Oracle
in [SQL]
|
server time reset 10.2.0.2 EE aix 5.2 we have a server that somehow got behind in time by 5 minutes. I mentioned it to the sysadmin and next thing I knew she had changed the time on the server ahead 5 minutes. First thought was panic and what is going to happen to the database now. Nothing seemed to happen. We haven't rebooted th... 24 Jun 2008 12:18
Backup of D:\oracle on Windows Hello, I have RAC 10g R2 on Win 2003 and I am trying to find a way to backup the D:\oracle. I don't really want to use a third party backup client nor do I want to shut down the DB and run a copy command. Is there a way for RMAN to include a backup of the D:\oracle? By the way, by datafiles would reside on ... 19 Jun 2008 01:14
archiver problems Hello, Oracle 10.2.0.3 on SUSE Linux here. Since yesterday, the archiver seem not to be able to archive logs anymore. The database is set up to archive logs in the Flash Recovery Area, /var/oracle/disk02/flash_recovery_area. The /var partition has 7.9G available and I am able to create a file in /var/oracle/disk... 19 Jun 2008 01:14
Effect of listener on existing connections? On Jun 13, 10:32 pm, AGT <usenetpersonger...(a)gmail.com> wrote: <groups.brob...(a)gmail.com> wrote in message news:a8f8b4b1-adbb-4916-9b23-8d72f6d221ba(a)f36g2000hsa.googlegroups.com... Writes: Oracle support is not giving us satisfactory results. Perhaps you can give some answers? We've... 19 Jun 2008 01:14
Unable to connect DBOracle10g from DOS/command prompt Hi All, I have been trying to connect by using DOS/command Prompt to my database, but I get an TNS--03505 error. What is weird is I get connection withour any problems from my SQL*plus....I checked my listener.ora, sqlnet.ora, and tnsnames.ora and they seem to be working ok. Any idea why is this happening? Tha... 19 Jun 2008 01:14
How to prevent using shared pool with dynamic sql pivoting? Oracle 10.1 here. I know there is built in pivoting in Oracle 11, but until we get it... I found two wonderful pieces of code that can ALMOST do what I want, BUT. Let me first share with you what I got: "Dynamic SQL Pivoting - Stealing Antons Thunder" by Lucas Jellema and Anton http://technology.amis.nl/blog/?... 22 Jun 2008 09:08
Need help trying to figure out accounting database schema For an accounting / banking database, I have the following in a two transaction tables showing what someone spends or credits: Transaction Table //one only -- TransactionID UserID TransactionItemID Table //many -- TransactionItemID TransactionID ItemID AccountTable //one to one from TransactionID Tabl... 19 Jun 2008 01:14
Memory problems, Oracle 10, Win 2003 (32 bit) I was hoping to get some assistance from the group.... I am working with a client who is running into some memory problems with their Oracle database. Now I am not an expert by a long shot, but the application vendor has told us that their rule of thumb is to always force a pagefile that is 2.5 times the physi... 26 Jun 2008 17:43
Do stored outlines work in Oracle 10.2.0.3? I am using 10.2.0.3 on HP UNIX 11i. I set cursor_sharing=exact. I created a stored outline using: alter session set create_stored_outlines='CUSTOM'; my sql_statement; When I run the sql statement and verify in v$sql whether outline was used by looking at outline_category and yes outline is used. But then ... 19 Jun 2008 01:14 |