Viewing 15 posts - 2,671 through 2,685 (of 3,061 total)
xgcmcbain (3/17/2009)
Im looking for SQL that would work for both TSQL and PLSQL
Welcome to the exciting world of looking for SQL holly grail 🙂
What I have done in the...
March 20, 2009 at 3:21 am
dmw (3/19/2009)
I may not register because their Privacy Policy seems to suggest 'you have no privacy from our advertisers'.
You can always create a gmail or whatever email account for the...
March 20, 2009 at 3:13 am
Gift Peddie (3/13/2009)
... my actual question would be what are you doing with Oracle 9i because most people are now running 10g and 11g
This statement does not reflects reality.
Ora9i...
March 17, 2009 at 9:36 am
I would create a new filegroup in the desired drive, once you have it there you can reorg tables/indexes the way better fits your I/O strategy.
March 17, 2009 at 9:32 am
Steve Jones - Editor (3/13/2009)
March 13, 2009 at 8:54 am
Ratheesh.K.Nair (3/12/2009)
First you connect to that particular database using login 'system'ie conn system\password@DB_Name as sysdba. Then try
BA
SYS and SYSTEM are Oracle equivalents of "sa" account; you don't want to connect...
March 13, 2009 at 8:49 am
If tempdb is your bottleneck you may want to setup tempdb on as many datafiles as CPUs you have in the box.
Datafiles should be distributed so to balance I/O -Your...
March 13, 2009 at 8:46 am
Check the size of Procedure Cache, is Procedure Cache growing at the same time hit ratio goes down?
Remember that a growing Procedure Cache would take space away from Data Cache...
March 9, 2009 at 10:10 am
shri_sastry (3/9/2009)
Do you think I should just disable the transaction log job and renable it after the full backup is done
I wouldn't be enabling/disabling backup jobs, as a DBA you...
March 9, 2009 at 9:59 am
oerr ora 28547
28547, 0000, "connection to server failed, probable Oracle Net admin error"
// *Cause: A failure occurred during initialization of a network connection
// ...
March 1, 2009 at 3:46 am
RJ (2/27/2009)
March 1, 2009 at 3:32 am
I do not think the issue has anything to do with partitioning but with the concept of referential integrity.
I would start by asking myself the question: "Which parent-child relationship do...
February 27, 2009 at 6:52 am
As part of your testing do not forget to attempt to patch SQL Server.
During SQL Server patching you are going to find out if hidden mssqlsystemresource database is in the...
February 27, 2009 at 6:39 am
I'm not sure if I'm following you to the atomic details of the issue but I would say you may want to work in two fronts.
1- Setting a explicit transaction
2-...
February 27, 2009 at 2:34 am
Why would you like to install express edition to work on a production environment?
My suggestion is to install the full version.
I know... it doesn't install, huh?
You have to uninstall express...
February 26, 2009 at 2:29 am
Viewing 15 posts - 2,671 through 2,685 (of 3,061 total)