meta user
network profile
| bio | website | ddbcinc.com |
|---|---|---|
| location | Rochester Hills, MI | |
| age | 36 | |
| visits | member for | 2 years, 4 months |
| seen | 33 secs ago | |
| stats | profile views | 364 |
Oracle ACE
|
Feb 4 |
reviewed | Satisfactory What would be the correct size of redo logs? |
|
Feb 4 |
comment |
Does a standby slow down Oracle imp? They should hardly influence each other assuming that the network between the servers has enough bandwidth to allow the archiver to copy the logs over the network faster than the primary can generate them at peak utilization. If the network between the servers doesn't have enough bandwidth and the import process generates a bunch of REDO, the primary could easily be stuck waiting on network transfers to the standby server. |
|
Jan 23 |
answered | How to list all users that have grants over a package |
|
Jan 19 |
awarded | Yearling |
|
Jan 16 |
comment |
How to find the actual space being consumed by indexes on a table in Oracle? @RichardDingwall - Assuming that you are logged in as the Oracle user that owns the index, that will work. If you are a DBA interested in how much space is being used, though, you'll generally be logging in as a user other than the one that owns the table. |
|
Jan 10 |
revised |
improving this goal query added 202 characters in body |
|
Jan 9 |
answered | Oracle delete technique for table's segment size (data compactness) |
|
Dec 17 |
comment |
Expanding system tablespace @user16308 - The size of the database should have little or nothing to do with the size of the SYSTEM tablespace. The SYSTEM tablespace needs a few bytes to store information about the definition of a table or an index. That space is constant, though, whether the table is empty or whether it has 1 billion rows. |
|
Dec 17 |
comment |
Expanding system tablespace I'm not sure what an "undersized system tablespace" means. Normally, the SYSTEM tablespace doesn't grow meaningfully after the database is installed and the application is created. A full database backup would be done using RMAN, DataPump would be for creating a logical backup (which is not a substitute for a physical backup-- if you don't have a physical backup, you absolutely need to back up your database). It seems highly unlikely that performance issues would be caused by a lack of free space in the SYSTEM tablespace unless something was badly configured. |
|
Dec 17 |
comment |
Expanding system tablespace Do you know why the SYSTEM tablespace is running out of space? That's pretty odd in an 11.2 database-- if someone has incorrectly created an object in the SYSTEM tablespace, that's something you need to correct. Even things like AUD$ are normally moved to SYSAUX. If you really are simply running out of space but everything in the tablespace should be in the tablespace, adding a new data file isn't a big deal. |
|
Dec 17 |
comment |
Oracle Sql Query Mutiple rows You want a result set with a single row that contains the literal string 'Frog and Elephant and tiger'? Or a result set with three rows? I'm not sure what s//y is supposed to mean. I'm not sure why tiger would be returned since it only has a start and an error row. Should we ignore the fact that you're mixing the case of your status values-- you have both Start and start as well as the misspelled Strat. "Frog" also has no Stop or Completed row, just Start, Process, and Error. |
|
Dec 17 |
revised |
Oracle Sql Query Mutiple rows added 76 characters in body |
|
Dec 17 |
comment |
Oracle SQL Query/SubQuery Single column with mutilple data @user16301 - Define "its not taking". Are you getting an error? If so, what error? Are you sure that you are specifying two string literals in the IN statement (as I am doing here) rather than using an unquoted identifier as you did in the query you posted initially? |
|
Dec 17 |
answered | Oracle SQL Query/SubQuery Single column with mutilple data |
|
Dec 13 |
answered | Cardinality rule for bitmap indexes |
|
Dec 12 |
comment |
Materialized view for the last 24 hour period @ypercube - Possibly, sure. I would expect, though, that the spatial data itself would need to be stored outside the index in the overflow segment in which case you'd still end up doing a range scan of the IOT's index and then doing a lot of single-row reads of the overflow segment. That's probably a bit more efficient than a heap-organized table but I wouldn't expect the performance difference to be large |
|
Dec 12 |
comment |
Which RDBMS has the most advanced “table-valued” functions? @All - Sure, on rare occasions, it is necessary. But I'm hard-pressed to imagine a situation where it is beneficial from a performance standpoint to denormalize a database by creating a delimited, composite value. Occasionally, it's reasonable to denormalize by, say, storing redundant data or storing a computed value. But I've never come across a situation where it would have been helpful to store composite data rather than creating a proper child table. |
|
Dec 12 |
answered | Materialized view for the last 24 hour period |
|
Dec 12 |
comment |
Which RDBMS has the most advanced “table-valued” functions? Why are you splitting a string so frequently that it becomes part of the criteria for what database engine to use? To @RemusRusanu's point, if you are storing a value in a cell that is a composite, you're violating basic principles of normalization. If you are going to work with any relational database, you are going to be much better served normalizing the data model. That's the "relation" in "relational database"-- any relational database is going to perform better and be easier to use when your data model is normalized. |
|
Dec 11 |
comment |
Searching transaction logs for changes What type of database are you using? Oracle? SQL Server? MySQL? PostgreSQL? Something else? The answer is going to be very specific to the database in question. |
